I have a fairly length sql statement where the results may list duplicate values from a field ("servicename" in this case). Is there a way I can modify the sql below to only list unique records from the servicename field? Thanks.
SELECT Locale.Place, ServiceNames.FIPS...
I'm at my wits end. I've installed both php and mysql. Both seem to work okay but I cannot get php to list mysql in the phpinfo page. I have changed the extensions dir path and uncommented the php_mysql.dll line in php.ini. I don't know what else I could do. I've ensured that it is indeed...
I have several variables listed in the application_onstart routine in my global.asa file. However, when I try to reference them in other pages I get nothing for the value. Can someone provide some ideas on why this is happening?
Code excerpt from global.asa...
This is about to drive me nuts so any help is greatly appreciated. I have captured the datelastmodified value from files in a directory and stuck them into an array. I'm then comparing the file name and value from the array with corresponding values in a text file. I want to compare them and...
I can now vpn into my office network to access resources. However, is there a way for me to transfer files from my laptop to say, a network drive at work using vpn/remote desktop?
Thanks.
I want to change the td border color on an onclick event. When the user clicks on content in one of the td's other functions are run. BI want to give an indication as to the currently selected td. Right now my td borders are hidden. I've tried using border-color but I'm obviously doing...
I'm having problems getting the redirector to work which allows IIS to work with Tomcat. In the isapi log file I see "unable to read worker mount file." Can someone help?
I'm unable to update a field in the recordset and I receive the "insufficient base table information" error. I need to be able to update the "bridges_pts_threat.threatco"
field. I'm using a client side cursor with the following sql statement. Any suggestions? Thanks.
strSQL =...
I've created an imagemap of the US breaking it up by states. All is well in IE, but when I try to use either Netscape or Firefox the image map becomes misaligned. For example, as I mouse over the states my mouse may be over California but the imagemap displays Nevada. Any ideas would be...
I have two parallel arrays(siteID & floodForecastValue) that I would like to pass to the function passTime (see code below). However, when I mouse over the link I see that it is passing each element in both arrays separated by commas. Is there a way to pass the array itself rather than the...
My goal is to update a dBase file with updated values extracted from a text file using the 'ID' filed as the unique value. If a match isn't found, I want to add the record to the database. If there is a match, then I just want to update a couple of fields. My problem/question is that I end up...
I have two asp files (file1 and file2). "File1" is used as an include on "File2." "File2" is also dependent on successful processing of "File1." What happens if "File1" generates an error? I have an error handler in "File2" and am...
I have a tab delimited file in the following format:
USGS 3453000 VY RIVER NEAR MARSHALL, NC 03 00065 2003-06-30 10:15:00 2.47 0 2003-06-30 10:21:12
I am trying to use RegExp to grab the information I need out of a text file. The unique field to search on is the second column (i.e., 3453000...
This is the string that I am using with RegExp:
(>)(02081500)(</A></TD><TD ALIGN=""left"" NOWRAP WIDTH=""475""> )(TAR RIVER)
( </TD><TD NOWRAP> )(06/25 10:30)( </TD><TD>)(2.48)( </TD><TD>)(66)( </TD><TD>)(18.0)( </TD>)
However, I am really only interested...
I have an html page that I automatically retrieve from a partner site and then save on my machine. The html page displays store names and addresses. What I need to do is to extract certain store names and addresses from this file. Does anyone have suggestions about how to do this? Would some...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.