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

    Microsoft Ad Rotator Problem

    Hi, I'm using the same script from the link above but I can't get the images to rotate. good luck
  2. mmarkym

    where clause

    using response.write on the variables with rr as the input gets this output rr rr response.write on the select statement gets this output SELECT user, pass FROM loginMinuteman WHERE user = 'rr' AND pass = 'rr'
  3. mmarkym

    where clause

    Using the trim function got the same results and the response.write produced this- Select user, pass from loginMinuteman where Trim(user) = 'name' and Trim(pass) = 'pass'
  4. mmarkym

    where clause

    I tried that with no luck. ???????
  5. mmarkym

    where clause

    In this statement I'm getting back all recordsets instead of the ones called for. I've tried different quote options but still won't work strUserName = request.form("user") strPass = request.form("pass") strQ = "Select user, pass from loginMinuteman where user = 'strUserName' and pass =...
  6. mmarkym

    Populating an array with request.cookies

    With this code.... dim iCount dim strCookie() For iCount = 1 To Request.Form("menu").count Response.Cookies("menu")(iCount) = Request.Form("menu")(iCount) Next redim strCookie(0) 'Loop through each Cookie for each x in request.Cookies("menu") response.Write(x & " = " &...
  7. mmarkym

    Populating an array with request.cookies

    I'm trying to retreive from a cookies collection and pass each value into a variable, an array called strCookie(). I'm get this error.... Error Type: Sun ONE ASP VBScript runtime (0x800A000D) Type mismatch the code is.... <% dim iCount dim objRS dim objConn dim strConnectionString dim...
  8. mmarkym

    using redim to populate a database

    redim strCookie(0) For Each x in Request.Cookies now I'm getting the same type mismatch error on this line-------- strCookie(x) = Request.cookies(x) response.write strCookie(x) Next
  9. mmarkym

    using redim to populate a database

    I'm trying to retreive from a cookies collection and pass each value into a variable, an array called strCookie(). when I redim the array inside a for next loop, I get this error.... Error Type: Sun ONE ASP VBScript runtime (0x800A000D) Type mismatch the code is.... <% dim iCount dim objRS...
  10. mmarkym

    Really need help with cookies

    Works perfectly, thanx mark
  11. mmarkym

    Really need help with cookies

    I've got a form with many checkboxes. The name for the form checkboxes is "menu" In my ASP page I'm trying to set cookies and then test for their presence. <% dim iCount I'm confused on the syntax of setting a cookie. specificaly the name for the cookie, response.cookie("this here"). I've...
  12. mmarkym

    error reading ADO recordset.open

    Why this? Error Type: ADODB.Recordset.1 (0x80004005) Recordset is read-only
  13. mmarkym

    error reading ADO recordset.open

    Now I get this error. Error Type: ADODB.Recordset.1 (0x80004005) SQLState: 42000 Native Error Code: 1064 [TCX][MyODBC]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '1 * from Reservations' at line 1
  14. mmarkym

    error reading ADO recordset.open

    I have a database query to insert records but am getting this error message. Error Type: ADODB.Recordset.1 (0x800A0E79) Invalid operation on open object The code reads as follows. bug = 0 strFname = request.form("fname") strLname = request.form("lname") strStreet = request.form("street")...
  15. mmarkym

    Getting cookies to work

    I don't know why this code brings up a blank screen..... <% dim iCount dim strCookie for iCount=1 to request.form("menu").count response.cookies("strCookie") = request.form("menu")(iCount) next for each x in request.cookies("strCookie") if request.cookies("strcookie").HasKeys then...
  16. mmarkym

    Cookies collection

    OK now how would I test that a cookie exists? I've tried- if response.cookies("menu")(iCount) then response.write "cookie exists" end if
  17. mmarkym

    Cookies collection

    My code for retreiving checkbox values is <% dim iCount for iCount=1 to request.form("menu").count response.write request.form("menu")(iCount) next %> How would I set these values to the cookie collection? something like this I think, but it doesn't work <% response.cookies("menu")...
  18. mmarkym

    Database recordset are read

    OK, thanx for that fix, but now I'm getting this error which I don't understand. Error Type: ADODB.Recordset.1 (0x800A0E79) Invalid operation on open object this added code from above strQ = "Select * from Reservations" objRS.open strQ, objConn, adOpenForwardOnly if bug then response.write...
  19. mmarkym

    Database recordset are read

    OK now I'm getting this error and have no idea what it means. I'll paste the whole code. Error Type: ADODB.Recordset.1 (0x80004005) SQLState: S1000 Native Error Code: 1062 [TCX][MyODBC]Duplicate entry '97' for key 1 <html> <head> <meta http-equiv="Content-Language" content="en-us"> <meta...
  20. mmarkym

    Database recordset are read

    I've set up my database and have a table. I'm trying to use the ADO Connection object and recordset object to connect to the database and insert a query from a HTML form. The database is on a remote server at Lunarpages.com. I'm getting the error message below. I've tried reconfiguring the...

Part and Inventory Search

Back
Top