[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