Forum Moderators: coopster & phranque

Message Too Old, No Replies

SQL help please what is this error msg

         

midi25

7:24 pm on May 23, 2002 (gmt 0)

10+ Year Member



Hi i am working on a mock site and am getting this error message on one of my pages.

Microsoft JScript runtime error '800a138f'
Object expected

/AllOrders.asp, line 68

my search page is www.asptestpilots.co.uk/search1.asp

if you type in the name joseph pearlman you should get a address return and 2 of his ordering details. Instead i am getting his address but an ms jscript error where his ordering details should be. If i run live data view in Ultra Dev its fine i get all the details. Just when it viewed on my site. Am stuck my SQL statement is :

SELECT *
FROM Customers, Orders
WHERE (Customers.CustomerID = Orders.CustomerID) AND (CustName = 'CN')

variable CN Joseph Pearlman Request("Customer")

any ideas please help

jatar_k

8:09 pm on May 23, 2002 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



I checked that page with those search params and it worked for me in a couple different browsers.

what is on line 68 in AllOrders.asp?

midi25

8:51 pm on May 23, 2002 (gmt 0)

10+ Year Member



thanks for checking. I changed from Asp java script in Ultra Dev to Asp VbScript it seemed to work fine then. Dont know check it again and it should work. Anyway thanks