iirc you do, and it gives another error if I try that anyway :( -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. ----- Original Message ----- From: "Pete Lundrigan" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Monday, October 21, 2002 2:33 PM Subject: RE: weird sql server error > 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.unsub%% > --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
