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: *

  1. cindy0904

    PLEASE HELP - submit form to access DB - field already exists error

    hmmm.. now I get this error: -------- ADODB.Recordset error '800a0e7d' The connection cannot be used to perform this operation. It is either closed or invalid in this context. /carlot/adminn/utils.asp, line 19 -------- Line 19 is the "rsObj.Open" line. Thanks!
  2. cindy0904

    PLEASE HELP - submit form to access DB - field already exists error

    Here are the 2 files. ===== utils.asp ===== <%'sets up dsnless connection string mydsn="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("..\") & "\fpdb\inventory.mdb" 'creates ado database objects set rs=server.createobject("adodb.recordset") set...
  3. cindy0904

    PLEASE HELP - submit form to access DB - field already exists error

    Ok, I put this: ------ rsObj.Open " SELECT vehID FROM vehicles WHERE vehID="&replace(request.form("txtvehID"),"'","''"),ObjConn If rsObj("vehID")<>"" Then Response.Write " This Vehicle ID number is already taken" ELSE ------- rec'd error: Microsoft VBScript compilation error '800a03f6'...
  4. cindy0904

    PLEASE HELP - submit form to access DB - field already exists error

    Hi, thanks for the replies. This is what I've added and where: =========== I INSERTED CODE AFTER THIS LINE: rs.CursorType = 3 rsObj.Open " SELECT vehID FROM vehicles WHERE vehID="&replace(request.form("txtvehID"),"'","''"),ObjConn If rsObj("vehID")<>"" Then <script type="text/javascript">...
  5. cindy0904

    PLEASE HELP - submit form to access DB - field already exists error

    ...2 Sport Utilities<br> 3 Pickups, Vans </font></td> </tr> <tr> <td bgcolor="#D1D1D1">vehID<font color=red>*</font></td> <td bgcolor="#D1D1D1"> <input type="text" name="txtvehID" size="30" maxlength="50"> <font size="1">Enter Stock...
  6. cindy0904

    Hi, I have a POP3 mailbox in Outloo

    Hi, I have a POP3 mailbox in Outlook. I want to ADD a IMAP account also. The only IMAP folder showing is InBox. How can I make a Sent Items folder for copies of my sent IMAP mail? (I want my POP3 to function as normal). I click query to show all folders, but only InBox appears. Can't figure out...
  7. cindy0904

    windows profile

    Great, thanks to you both. I've taken your suggestions and all is well. I appreciate it! Cindy
  8. cindy0904

    windows profile

    Hi, what is the default windows user profile? For instance, after booting up, when at the logon screen, if I choose cancel and save items in the My Documents folder, the true path to this folder is c:\my documents. But if I logon as another user, the path is c:\windows\profiles\user\my...
  9. cindy0904

    SpyBot error msg

    I ran SpyBot and rec'd this msg: datei&quot;c:\windows\hosts &quot;kann nicht erstellt werden.access is denied I looked it up and this is GERMAN for &quot;file &quot;c:\windows\hosts &quot;cannot be provided&quot; access is denied. What does this mean and where is this coming from? I assumed...
  10. cindy0904

    SQL - ORDER BY clause

    THANKS SO MUCH! You're absolutely right, I was adding the code in the wrong spot. I appreciate you taking the time to help! Cindy
  11. cindy0904

    SQL - ORDER BY clause

    ...BY TIME ASC&quot; but no change in how the page displays (the page orders by IP numerical order currently). Thanks for any other ideas. Cindy * * * * * * * * * sSQL = &quot;SELECT Stats.Date, Stats.Time, Stats.IP, Paths.PathName, Refs.RefName FROM Paths RIGHT JOIN (Refs RIGHT JOIN Stats...
  12. cindy0904

    SQL - ORDER BY clause

    ...the day has been established? Confusing. Thanks for any help. --Cindy http://www.mywebsite.com/statcountex/ips.asp?Year=2002&Month=12&Day=3 ************************************** <!--#include file=&quot;config.asp&quot;--> <%...
  13. cindy0904

    how to -- querystring not found error msg

    Ah, yes, I had tried that and my problem was I had a field left out that was still causing the problem. I needed to encompass all fields. Thanks for the reply!
  14. cindy0904

    how to -- querystring not found error msg

    Hi, I have 2 pages. One passes a user input one-line text field to the second page (request.form). It all works great IF the user enters a valid number that matches the DB. BUT, if they put in anything else, the second page displays the basic BOF/EOF error. Where and what code can I use to...
  15. cindy0904

    querystring values to form

    simple solution: change access field from memo to text!!!!!!!!!!!!!
  16. cindy0904

    querystring values to form

    ...that's the problem, I don't understand why index.asp is sending both the other 2 fields but not the itemname value. Here's the index.asp code: ********** <%@LANGUAGE=&quot;VBSCRIPT&quot;%> <!--#include file=&quot;Connections/ss.asp&quot; --> <% set Recordset1 =...
  17. cindy0904

    querystring values to form

    ...not live. Driving me crazy. Any ideas? (3 fields are itemID, itemname, amount). www.samuraisalvage.com/index.asp, then click more info button. **************** The moreinfo button on index.asp has this link: <a...
  18. cindy0904

    querystring values to form

    sorry, maybe i didn't provide enough info (or too much!) --cindy **************** The moreinfo button on index.asp has this link: <a...
  19. cindy0904

    querystring values to form

    hi, i have two pages, index.asp and moreinfo.asp. Index.asp should pass 3 querystring db field values to moreinfo.asp. It passes two but leaves the third blank. It was working and still does locally but not live. Driving me crazy. Any ideas? (3 fields are itemID, itemname, amount)...
  20. cindy0904

    runtime error expected ')'

    THANK YOU! To solve the problem I just replaced the '86-'89 with 1986-1989 and what do you know? No errors! Thanks so much for taking the time to help. cindy

Part and Inventory Search

Back
Top