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 bkrike 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 psappenfield

  1. psappenfield

    Gridview problems in Lynx browser

    The problem is with javascript. Since Lynx cannot process javascript postbacks, the paging and sorting with the gridviews do not work. Neither do select and edit commands. We are having to re-write everything as <asp:Button> commands in the field templates. Thanks for the mention of MVC - I...
  2. psappenfield

    Gridview problems in Lynx browser

    Has anyone been able to get paging and sorting working in a gridview on a Lynx browser?
  3. psappenfield

    Intelligent Messaging Filter Blocking Internal Emails

    I am having a problem with the Intelligent Messaging Filter blocking my internal emails. So far, the following has been tried: 1) Adding the IP address of the sending server under the accept connection filter. 2) The email address is NOT listed as a blocked address in any filter. 3)...
  4. psappenfield

    Request.Form problem

    I actually had to figure this out a couple of weeks ago, and I was searching everywhere for the answer. I want to make sure I understand you correctly - You are trying to get the name of the field and value, and you want it in the order that the form is laid out. If so, you must use a...
  5. psappenfield

    Regex and a Time format

    Thank you... It's working now. :-)
  6. psappenfield

    Regex and a Time format

    Hello, I am trying to get a regex to work for the following time format: 2:00PM-2:15PM /^([1-9]|0[1-9]|1[012])[:]([0-5][0-9])([AM|PM])[-]([1-9]|0[1-9]|1[012])[:]([0-5][0-9])([AM|PM])+$/ I am fairly new to regex, but I copied the time condition from a previous regex that does work correctly...
  7. psappenfield

    Request.Form problem

    You can use an if... then... statement to test for the Hidden field, as long as the value does not match any of your checkbox values. Dim checkbox(100,2) response.Write "Hidden Field=" & Request.Form(1) & "<br><br><br>" For Each x in Request.Form i = i + 1 checkbox(i,0)=x if...
  8. psappenfield

    error '80040e14' - Incorrect syntax near the keyword 'select'

    Thank everyone for your help... It was the open connection string... I was using adCmdTable instead of adCmdText. [morning]
  9. psappenfield

    error '80040e14' - Incorrect syntax near the keyword 'select'

    It does work in Query Analyzer, and I am connected to the right database. I have had issues like this before with Sql Server 7 and column insert changes in DTS, but that was a column order issue. This time the column order has not been altered, just the name. Is there anyway to get more...
  10. psappenfield

    error '80040e14' - Incorrect syntax near the keyword 'select'

    I have the connection object at the top of the page... strConnect1="DRIVER={SQL Server};" &_ "SERVER=myserver;DATABASE=mydatabase;" &_ "Trusted_Connection=yes;" set objConn = Server.CreateObject("ADODB.Connection") objConn.Open strConnect1 set objRS =...
  11. psappenfield

    error '80040e14' - Incorrect syntax near the keyword 'select'

    I changed the MangerName field to ManagerName. Originally the query did not have this ManagerName constraint, since I was just testing my connection to the table. It worked fine at that point. When I realized that I had misspelled the field name, I changed it, and then that error started...
  12. psappenfield

    error '80040e14' - Incorrect syntax near the keyword 'select'

    The query was running just fine until I changed a column name in the SQL table. Unfortunately, ASP thinks there is an error. I am getting this error message: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the...
  13. psappenfield

    error '80040e14' - Incorrect syntax near the keyword 'select'

    Hello, I am having a problem with an SQL query string. strQry="select top 1 AvailableDayOfWeek from myMeetingAvailableTimeSlots WHERE ManagerName='sbaker'" objRS.Open strQry,objConn,adOpenStatic,adLockOptimistic,adCmdTable I have run it through SQL Query Analyzer, and there were no errors...

Part and Inventory Search

Back
Top