UserFriendly Strip Comments


	The Daily Static UF Archives Register UF Membership Ad Free Site Postcards Community Geekfinder UFie Gear Advertise on UF Forum Rules & FAQ Username Password Create a New Account

Back to UserFriendly Strip Comments Index

Again, Query Gurus:	by oedlan	2009-10-26 07:55:44
With the "?" in there, is it prompting you for a	by merlin	2009-10-26 07:59:32
Than you!	by oedlan	2009-10-26 08:03:15
Change it to this:	by merlin	2009-10-26 08:08:22
Again thank you	by oedlan	2009-10-26 08:31:24
You only have one table listed in the FROM clause	by merlin	2009-10-26 08:37:12
(Ordfakthuvud), but two tables listed in the column list (Ordfakthuvud and Ordfaktrad). Ordfaktrad needs to be listed in the FROM clause, and the relation between Ordfaktrad & Ordfakthuvud established either with a JOIN clause or in the WHERE clause. I imagine it's thinking that Ordfaktrad.Produktnr and Ordfaktrad.Summa are parameters because it's not a valid table, and they are not flagged with the "?" parameter value that tells it to prompt for the values. Oh, and the reason it's telling you "expected 3" is because you also have the "?" parameter already. So it prompts for that, which fills in one parameter, but then chokes on those last two fields. Make sense?
[ Reply ]
I think so.	by oedlan	2009-10-26 09:00:35

[Todays Cartoon Discussion] [News Index]

Come get yer ARS (Account Registration System) Source Code here!
All images, characters, content and text are copyrighted and trademarks of J.D. Frazer except where other ownership applies. Don't do bad things, we have lawyers.
UserFriendly.Org and its operators are not liable for comments or content posted by its visitors, and will cheerfully assist the lawful authorities in hunting down script-kiddies, spammers and other net scum. And if you're really bad, we'll call your mom. (We're not kidding, we've done it before.)