OK.. >Well there are two methods to make a SQL statement: > >1. Have all the statements hard coded as you mentioned >2. Pass the script in hyperlink form mode to another page which actually >executed the statement: >[Page 1 - The gathering page] >[Page 2 - the parsing page] ><META HTTP-EQUIV="Refresh" Content="0; URL= >www.me.com/page3.stm?sql=SELECT ><RCif RC$var1 ! NULL AND RC$var1 = this> >field1, ><RC$endif> ><RCif RC$var# ! NULL AND RC$var# = that> >field2, ><RCendif> >from ><RC$table> >where ><RCif RC$var1 ! NULL AND RC$var1 = this> >tag1 = <RC$var1> ><RCendif> ><RCif RC$var1 ! NULL AND RC$var# ! NULL> >AND ><RCendif> ><RCif RC$var1 ! NULL AND RC$var1 < this> >tag2 LIKE <RC$var#> > >
OK, I understand so far Matt, now we come to the hard bit. How is it executed with the RCQ tag without a syntax error or a SQL error? Cheers Ray ------------------------------------------------------- To unsubscribe please go to http://www.sambar.ch/list/
