Search results for query: *

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!

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

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'...

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">...

Hello. First, sorry for the long post. Others have tried to help but I need SPECIFIC instructions of what and where to add code-too confusing! :D I have a page that inserts a new record into my Access db. The vehID field is indexed to prevent duplicates. When a user enters a duplicate vehID in...

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

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

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

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

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

Hi, I did change this line before, adding &quot;ORDER 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...

Hi, does anyone know how to alter this code so the ips.asp page (code below) sorts the table &quot;Stats&quot; ORDER BY Date, Time? Or, possibly since the date is passed in a query string (as per below) then maybe only sort by TIME since the day has been established? Confusing. Thanks for any...

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!

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

simple solution: change access field from memo to text!!!!!!!!!!!!!

No, you're right, 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 =...

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)...

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

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)...

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