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!

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

Recent content by robbie59

  1. robbie59

    Create registry entrie

    I would like to put a button on a page so that it will add the current site to the list of trusted sites in IE. can this be done from a web page and if so How? If knowledge were power I would be a AAA battery!
  2. robbie59

    save form data in different place?

    I need to save form data to a different directory and text file based on a value from a dropdown list on a form. for example If the Physician name Smith is selected from the dropdown list and other form data is filled in I need to save it to d:\formdata\smith\formdate.txt the foldername would...
  3. robbie59

    (missing operator)????

    I am trying to use the code from this website "http://www.drdev.net/article11.asp" his db recid field is an autonumber field and he is using it as the where statement and it works just fine on his example I have been trying to get this to work for over a week now and can't seem to figure it...
  4. robbie59

    (missing operator)????

    I am not trying to update the jobnumber field only trying to use it as the where function If knowledge were power I would be a AAA battery!
  5. robbie59

    (missing operator)????

    Update : I told you wrong JOBNUMBER IS A AUTONUMBER FIELD If knowledge were power I would be a AAA battery!
  6. robbie59

    Alternate Table Row Colours in ASP

    here you go just change the color code as needed put inside <tr> tag <%if intRowColor = 1 Then Response.Write "<TR bgcolor=""#FFFF99"">" intRowColor = 1 Else Response.Write "<TR bgcolor=""#99CCFF"">" intRowColor = 0 End if %> If knowledge were power I would be a...
  7. robbie59

    (missing operator)????

    I tried your suggestions and Now I get this error [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. I can tell you That all three DB fields are number fields being updtaed by 2-Select menus and one of the fields being updated by a checkbox with a checked...
  8. robbie59

    (missing operator)????

    I keep getting this error when I submit any ideas on what is causing the error Syntax error (missing operator) in query expression ''''WHERE Jobnumber = '2940' Here is the update code: <% If Request("Submit") <> "" Then varRecIDs = Replace(Request("hidRecIDs"), "*", "") ' remove all the...
  9. robbie59

    Keep Getting Syntax Error! HELP!

    Any Other Ideas on this???? If knowledge were power I would be a AAA battery!
  10. robbie59

    Keep Getting Syntax Error! HELP!

    Would the fact that it is a checkbox be the problem should it be some sort of a different update statement for a checkbox If knowledge were power I would be a AAA battery!
  11. robbie59

    Keep Getting Syntax Error! HELP!

    I removed quotes but it did not help If knowledge were power I would be a AAA battery!
  12. robbie59

    Keep Getting Syntax Error! HELP!

    The data type is Number for iPriorityLevel the checkbox is supposed to change it to 7 if checked it is also intially unchecked if current value of iprioritylevel is other than 7 If knowledge were power I would be a AAA battery!
  13. robbie59

    Keep Getting Syntax Error! HELP!

    Thanks for the response: Now I get this error Microsoft OLE DB Provider for ODBC Drivers error '80040e07' [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. manage1.asp, line 28 If knowledge were power I would be a AAA battery!
  14. robbie59

    Keep Getting Syntax Error! HELP!

    Syntax error in string in query expression '' WHERE JobNumber = 2940'. manage1.asp, line 28 I keep Getting this above error when I submit any Ideas on what I am doing wrong Below is actual asp code <%@LANGUAGE="VBSCRIPT"%> <!--#include file="Connections/RS1.asp" --> <% If...
  15. robbie59

    Use different Querystring based on session value

    I am using dreamweaver,s recordset builder screen so where do I put the code or what portion of code goes where or should I make this a stored procedure and call it If knowledge were power I would be a AAA battery!

Part and Inventory Search

Back
Top