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

    Login page

    Cheers for that most appreciated
  2. SiJohn101

    Login page

    Its saying expected end of statement strSQL = "SELECT * from tblUsers where fldUsername ='" & strUsername & "' AND fldPassword ='" & strpassword "'" Afterstrpassword where the first " is. If i remove this it brings up this SELECT * from tblUsers where fldUsername ='SimonJ' AND fldPassword...
  3. SiJohn101

    Login page

    I have to changed my query to how you said but it now brings up the following error Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Syntax error in string in query expression 'fldUsername ='SimonJ' AND fldPassword ='Huddersfield'...
  4. SiJohn101

    Login page

    I have the following login page <FORM ACTION="login.asp" method="Post" name="login" onsubmit="return validate(this);"> <td align=left bgcolor=#ffff99> <p><b><FONT color="#009933">username</B><br><INPUT TYPE="text" NAME="Username" VALUE="" SIZE="20"><p><b><FONT...
  5. SiJohn101

    query not working

    No it still won't get passed strpriceband
  6. SiJohn101

    query not working

    It;s still saying expected end after strpriceband. Although i pass it across as & PB =<%=objRs("fldPriceband")% in my database priceband is a numeric field does this have any bearing
  7. SiJohn101

    query not working

    It now says expected end of statement here '" & strPRICEBAND "' where the second double quote is
  8. SiJohn101

    query not working

    I have this query but it comes up with an Expected end of statement fault. Here is the query strSQL1 = "SELECT * FROM tblPRICEBANDS, tblCOTTAGES WHERE tblPRICEBANDS.fldPRICEBAND = tblCOTTAGES.fldPRICEBAND AND tblPRICEBANDS.fldPRICEBAND = '" & strPRICEBAND "' & tblCOTTAGES.fldPROP_NO = '" &...
  9. SiJohn101

    asp string not working

    Cheers i've looked at it that many times and changed that many things that i've probaley had it working for the past few days but missed that simple thing. Cheers you've saved my sanity
  10. SiJohn101

    asp string not working

    I have this at the top of my page strPETS = Request.QueryString ("PETS") Here is the code for the whole page <%@LANGUAGE="VBSCRIPT"%><% Dim strLOCATION, IntLoop, strSQL(), strOCCUPANTS_NO, strSqlLOC, objConn, objRsLOC strLOCATION = Request.QueryString ("LOCATION") strOCCUPANTS_NO =...
  11. SiJohn101

    asp string not working

    I have changed it to how you have said but still can't get it to work. Is this how you mean't IF strPETS = "Y" THEN strSQLLOC = strSQLLOC & " fldPETS = 'Y' " ELSE strSQLLOC = strSQLLOC End If
  12. SiJohn101

    asp string not working

    I have the following checkbox on my site but it dosen't work, tried to ssolve it before but still having trouble. this is the code from my first page <P>Do you want to take pets with you? <INPUT type=CHECKBOX name = "PETS" value = "Y">Yes<br> This is the code from my second page IF strPETS =...
  13. SiJohn101

    Query not working

    I keep getting this error message Microsoft VBScript compilation error '800a0409' Unterminated string constant /tpv/test3.asp, line 11 strSQL1 = "SELECT * FROM tblPRICEBANDS, tblCOTTAGES WHERE tblPRICEBANDS.fldPRICEBAND = tblCOTTAGES.fldPRICEBAND AND tblPRICEBANDS.fldPRICEBAND = " &...

Part and Inventory Search

Back
Top