Select statement error... 4

[rjn2001]

Got a little something wrong with my SQL statement:

Microsoft VBScript compilation error '800a03fd' 

Expected 'Case' 

/viewjob.asp, line 10 

SELECT * FROM tblJob Where UserID = "' &UserID& '"
-------^

SELECT * FROM tblJob Where UserID = "' &UserID& '"

Richard Noon

http://www.davidmasonconsultancy.co.uk

 

[rjn2001]

The page just looks as though it is 'hung', with the address of the site still appearing in the blue bar at the top of IE, and nothing on the page.

Richard Noon

http://www.davidmasonconsultancy.co.uk

 

[FesterSXS]

right click on the page and view source - is there an error in there?


Tony
_______________________________________________________________

http://www.SpiraxSarco.com/

 

[rjn2001]

Hi Tony -

There is nothing in the source at all, just the security stuff -

<!-- ********************************** SECURITY HEADER START, Put in any Private Page ******************************** -->
<!-- ********************************** SECURITY HEADER ENDS, Put in any Private Page ******************************** -->

Richard Noon

http://www.davidmasonconsultancy.co.uk

 

[FesterSXS]

what did you do that suddenly stopped your page from loading?

Tony
_______________________________________________________________

http://www.SpiraxSarco.com/

 

[rjn2001]

took out the response.write

I am trying from fresh, obviously something major as messed it all up!, so i will make it again, and get back to you all.

Thanks for the assistance so far.

Richard Noon

http://www.davidmasonconsultancy.co.uk

 

[rjn2001]

Hi, thanks to you all for your help, the fault was being caused by the VB script in the page, some of it was conflicting and causing the errors.

Thanks to you all.

Cheers

Richard Noon

http://www.davidmasonconsultancy.co.uk