1 Reply Latest reply on Aug 10, 2006 10:11 AM by Tag2007

    Error passing url Parimeter - ASP/VBS

    Tag2007
      Hi Guys,
      Im in a bit of a muddle and hope someone can help.

      I have a set of pages..

      Page 1 displays a list of records in my accces database, there is a repeat region on the list with a link to go to an update page passing the records ID as an url parimeter.

      Page 2: update page

      The update page opens up and has an update recordset on it so I can change a value and update the record..

      This works and is set to go back to Page 1 on completion.

      But on comming back to page 1 im still carrying the url parimeter of the ID as i see it in the address bar so now im back on Page 1 when I click my link to go to the page 2 to update the next record I get an error saying

      [code]
      Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

      [Microsoft][ODBC Microsoft Access Driver] Syntax error (comma) in query expression 'id = 6, 5'.

      [/code]

      Is there any way I can clear the url parimeter once I reach page 2? so when i go back to the first page i can start again?

      Thanks in advance for any support

      Tag.