Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: spiveygb
  • Order by date
  1. spiveygb

    list records with unique values

    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...
  2. spiveygb

    php doesn't recognize mysql

    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.
  3. spiveygb

    php doesn't recognize mysql

    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...
  4. spiveygb

    application variables not recognized

    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...
  5. spiveygb

    application variables not recognized

    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...
  6. spiveygb

    comparing dates

    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?
  7. spiveygb

    comparing dates

    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...
  8. spiveygb

    comparing dates

    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...
  9. spiveygb

    transferring files to office

    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.
  10. spiveygb

    change td border

    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...
  11. spiveygb

    use with IIS

    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?
  12. spiveygb

    insufficient base table information

    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...
  13. spiveygb

    insufficient base table information

    ...bridges_pts.dbf" strSQL = strSQL & " ON usgsdata.site_id = bridges_pts.ref_id INNER JOIN bridges_pts_threat.dbf" strSQL = strSQL & " ON bridges_pts.uid = bridges_pts_threat.uid;" 'strSQL = "SELECT * From bridges_pts_threat.dbf" openRS rs,strSQL,oConn,adOpenStatic,adLockOptimistic,adCmdUnknown
  14. spiveygb

    imagemap coordinates off in Firefox/Netscape

    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.
  15. spiveygb

    imagemap coordinates off in Firefox/Netscape

    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...
  16. spiveygb

    pass array object to a function

    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...
  17. spiveygb

    updating a database has blank records

    ...ConnectString 'create the recordset Set rsGaugeInfo = Server.CreateObject( "ADODB.Recordset" ) rsGaugeInfo.Open "Select * from USGSdata.DBF", oConn, adOpenStatic, adCmdTable *** THIS IS ACTUALLY CONTAINED IN A LOOP THAT READS THE LINES OF TEXT FROM THE TEXT...
  18. spiveygb

    error handling and include files

    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.
  19. spiveygb

    error handling and include files

    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...
  20. spiveygb

    automatic download of file

    Is it possible to get IE to automatically download a file like you can with Lynx?

Part and Inventory Search

Back
Top