I'm having trouble getting a rate to multiply on my quantity in UD. Here's my select statement:
Select quantity from items * 35

I've also tried
Select sum(quantity) from items * 35

to compute the total amounts, but it doesn't work.

It seems pretty simple, but it won't compute. Any suggestions? I'm using a Mac/DreamweaverUltraDev and a Mysql db on a Solaris server.

Thanks,
Tedra Harring

SELECT *, (sum(quantity) * 35) AS SumOfQuantity FROM items

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I'm having trouble getting a rate to multiply on my quantity in UD. Here's my select statement:
Select quantity from items * 35

I've also tried
Select sum(quantity) from items * 35

to compute the total amounts, but it doesn't work.

It seems pretty simple, but it won't compute. Any suggestions? I'm using a Mac/DreamweaverUltraDev and a Mysql db on a Solaris server.

Thanks,
Tedra Harring
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic

TalkZone Manager

Edited by - vfarcic on 22 May 2002 13:41:28

Thanks so much for your helpful advice. I have the book The Complete Reference, Dreamweaver UltraDev 4, and they don't show nesting any calculations like you did. It works beautifully, of course, and you've been a big help. Can you also recommend a better book for my use?

Thanks again,
Tedra Harring