If I am not mistaking you do not need the paran's in SQL. Pete Lundrigan Media Resources Center Academic Web Support 316.978.7759 http://www.mrc.twsu.edu/ [EMAIL PROTECTED]
-----Original Message----- From: Josh G [mailto:josh@;gfunk007.com] Sent: Sunday, October 20, 2002 9:53 PM To: ActiveServerPages Subject: weird sql server error Hi, I know this is slightly OT, but I have a query that functioned fine in access, but in sql server gives me an error: select sum(cost) as cost_total from (select fixedhours * costperhour as cost from quoteprocesses where quoteid=6 and departmentid = 4) This gives me the error "Incorrect syntax near ')'." referring to the last parenthesis.... Anyone have an idea what's going on? -Josh Who can it be knocking at my door? Go away, don't come round here no more. Can't you see that it's late at night? I'm very tired, and I'm not feeling right. --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
