chopin
Last Activity: Sep 18 '13, 03:45 PM
Joined: Mar 20 '07
Location: New Jersey
-
I've actually figured out how to do this by utilizing PHP instead. PHP has a built in function that can capture a cookie value by name, called $_COOKIE['cookie_name']. When a PHP page is loaded, I execute MySQL insert commands to input temp data into a table. C# will execute the PHP page executing the PHP commands which will insert the cookie value into a table when the C# program is loaded. Since C# can grab information from a MySQL database,... -
Maybe this will help clarify what I am trying to do. The equivalent code in PHP to obtain a cookie value is:
The above will output a cookie value if that cookie exists. That's it! Is there an equivalent function in C#?Code:$_COOKIE['cookie_name']
Leave a comment:
-
I've done some more investigating, and it appears that this line of code is deleting my cookie values, which is the cause for my problem:
I'm at a loss at what to do, it seems like the code in my first codeblock example is the correct way to accomplish what I need, the only problem being the above line deletes the values of the cookies I need.Code:HttpWebResponse Response = HttpWebResponse)Request.GetResponse();
Leave a comment:
-
This is WinForms. I am developing an executable standalone program that will connect directly to my website's MySql database.Leave a comment:
-
I tried using this line here:
Unfortunately, upon executing that line of code, it prematurely opened my form, and terminated the program. I'm not sure how to proceed in obtaining the cookie values.Code:MyCookieColl = System.Web.HttpContext.Current.Request.Cookies;
Leave a comment:
-
Obtaining a cookie value from a logged in user on my website
I am trying to obtain the values of cookies from a particular website. The problem is, when I run the following code, it only loops through 4 of 10 cookie values present. Furthermore, the values are turning up as deleted: Reference
...Code:HttpWebRequest Request = (HttpWebRequest)WebRequest.Create("http://www.mysite.com"); Request.CookieContainer = new CookieContainer(); HttpWebResponse Response = (HttpWebResponse)Request.GetResponse(); -
How do you grab the title of the current page?
I am trying to grab the title of an html page using php. Grabbing the title is actually not the problem, the problem is grabbing the "current" page that a user is on. For example, the page I am on now has a title tag, and I would want to store this title in a php variable. The reason why I want to do this is to track active visitors on the site, and what pages they are currently viewing.
My strategy was to grab the current... -
How can I list all pages of a website & store them into array variables?
I think my question sums it all up. I am looking for a way to grab all urls from a website and store them into array variables. Is there a way to do this in php? -
Why is CONCAT not piecing together strings?
I have a table `city` that contains four cities (a,b,c,d)
I am trying to concatenate the city with a string. It is important that the city must come first:
CONCAT(`city`, ' text') should do the trick, but I am getting the following:
However if I reverse the CONCAT order to CONCAT('text ', `city`), then I get the proper string attachments:Code:a b c d text
...Code:text a
-
How to keep an Ajax Dialog Box Open after Partial Refresh?
I was wondering if there was a way to keep an ajax dialog box open after a partial refresh. The best way to explain my problem is by showing you by example.
If you click on "Launch PPC Builder", then choose any tab, and click a button, the form will partially refresh (executing a sql query), but then it closes out of the dialog. Ideally, I would like to keep this dialog box open so the user can continue to click on the buttons... -
Alternate data from two different columns into rows
I was wondering if there was a way to alternate data taken from two different columns in a query, then placing that data into a another query or table. For example, let's say I have the following query, with the respective columns:
column1.......c olumn2
A.............. ......1
B.............. ......2
C.............. ......3
D.............. ......4
Then I would like to input the above information... -
I wasn't specifically clear with my original post, but I will explain. Basically I wanted to extract the month and year from each line item, so I can show total monthly results. And I wanted to serially increase the mm/yyyy portion so I can present these results correctly, but I needed a sort, which is why I wanted to convert to a date. With my setup with the double m, it would not start out at day one of the month if I showed the full date (the...Leave a comment:
-
If this is impossible, then so be it. I found a reasonable solution though:
Using the one "m" forces all the dates to start at day one for some reason (but this is a good thing). Thus my output will look like:Code:CDate(Format([table].[date],"m/yyyy"))
1/1/2010
2/1/2010
3/1/2010
etc...
This is a solution that will be good enough for me.Leave a comment:
-
CDate Not Cooperating - Need mm/yyyy format only
My goal is to take a date such as 1/1/2010 and convert it to 1/2010 or 1/10, either or. The way I am doing this is by using the format function as follows:
The problem is this spits out a string and I need this as a date for ordering. The resolution should be to use the cdate function which converts the string to a date such as this:Code:Format([table].[date],"mm/yyyy")
...Code:CDate(Format([table].[date],&
-
Convert Pivot Tables to Reports
Pivot tables in Access are very powerful. The major flaw is presentation. I know exporting to excel is an option, however I want to merge many pivot tables into one report in Access. Is there any way to convert a pivot table (and multiple pivot tables) from a query, into one aggregated report view for presentation? -
I was able to figure this out with the following logic in DAO (I'm just going to enter in quick human readable code. Since my project is actually a little different than what I had asked, I don't want to confuse you all with code that may not make sense unless you know my project.)
DAO is a nightmare to learn, but...Code:Do Until rst.EOF If Account = AccountPrevious Then "1", Else "0" Loop
Leave a comment:
-
In each group, fill the first row with a 0, and the successive rows with a 1
Let's say I have groups of data. In each group, I want the first row to be filled with a 0, but each successive row with 1's.
Here is an example of data output:
Account, Date, Yes/No
account1, 1/1/2008, 0
account1, 4/5/2009, 1
account1, 3/4/2010, 1
account1, 7/7/2011, 1
account2, 1/6/2008, 0
account2, 3/3/2009, 1
account2, 4/4/2010, 1
account5, 2/3/2008, 0
account5,... -
Actually I don't need to use this format option within DAO. I just used a query in the query builder, and this has been successful. I still am unsure why this option won't work in DAO, and I hope to sometime figure out why, but the format function within the query section works flawlessly. Perhaps this is just a vba bug.Leave a comment:
-
I just tried, and that gave me the same results. When I output the actual date, I seem to get gibberish, I'm not sure if that has anything to do with it.
Here's an output example of output where the dates are printed as dates using the format function:
...Code:INSERT INTO actives (WeekNum, MonthNum, YearNum, Account, DateStart, DateEnd) VALUES('1/9/1900', '1/2/1900', '6/30/1905', 'Account', '3/6/2008', '3/5/2009')Leave a comment:
-
Thank you for your help. The problem is that I need a function that will take non static dates. I resolved this problem and I will share it:
...Code:Option Compare Database Option Explicit Public Function ActivesAccounts() As Boolean On Error Resume Next Dim db As DAO.Database, rst As DAO.Recordset, sSQL As String Dim strWeek As Date, strMonth As Integer, strYear As Integer Dim strAccount
Leave a comment:
No activity results to display
Leave a comment: