[thelist] Tip - ColdFusion and Datasources

rudy rudy937 at rogers.com
Sun Aug 17 07:21:40 CDT 2003


> Should work in most any SQL-89 compliant database, if I'm not
> mistaken...
> 
>    insert into orderitem
>      (orderno,orderitemno,qty,price)
>    select
> 27,342,5,5.98
>    union all select
>         27,613,1,7.98
>    union all select
>         27,42,2,12.00
>    ... etc ..

paul, paul, paul

sorry paul, you are mistaken -- that's cute but it's not standard

<tip type="sql">
wondering if the sql that your oddball dbms supports is actually standard?
try it out here --
http://developer.mimer.se/validator/index.htm
</tip>


rudy


More information about the thelist mailing list