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...
Good catch!! I was having a similar issue in that php was not referencing the correct .ini file (had to create a totally new env. var to get it to recognize the correct path) but I totally overlooked the extension_dir. As they say, "It's the simple things." ;-) Thanks a lot.
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...
well, one of my buddies just pointed me to the answer...
In IIS Manager you have to make sure that the "application settings" section is set properly. To check this go to IIS Mgr, rt click "properties" on the virtual directory containing the application, and then examine the "application...
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...
In the original version of the code (before this issue came up) I was trimming the var arrFileContents and then attempting to use CDate with no success. I received the same type mismatch error. Any other suggestions?
Sure. I've broken apart the timestamp while trying to get a solution to this issue. Originally, I had only two variables; one for the timestamp of the file in the text file and the other for the timestamp of the file in the array. It's bailing on the formatdatetime statement. When In the...
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 using standalone .dbf files so stored procedures aren't an option. Primary keys are in my sql statement. One solution I could do is perform all the calculations using data from the first two tables, read them into an array, and then open a separate recordset of the third table and populate...
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 just moved it over so that you can see it. The address is http://204.211.135.110/test.asp. Notice the county name in the status bar as you mouse around the colored counties. Thanks.
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...
That's what I thought. However, I am having trouble getting the error handler to catch the error in the first file. I put the error handler into the first file it catches it just fine. If I continue to have an issue I'll post it up. Thx.
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...
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.