Cesar Mejia
Member since Sep 24, 2009
- Profile: /members/4370-cesar-mejia.htm
- Comments: 2
Recent Blog Comments By Cesar Mejia
-
Ask Ben: Testing The Existence Of A Query Column In CFScript
Posted on Dec 8, 2009 at 11:18 PM
Actually I'm back here because I have the right answer: BOTH , Ben's and Mine's are right just to keep in mind the following: what are you looking for a DB check before the query? Mine's good; don't know and don't care if you have to alter table, or don't want to alter the table, just want to know i... read more »
-
Ask Ben: Testing The Existence Of A Query Column In CFScript
Posted on Sep 24, 2009 at 4:25 AM
hi! Actually, if what you are looking for is to loop over a list of columns and, for example, if a column does not exist, alter the table, you could do it this way: <cfquery name="opciones_pp_venta" datasource="#request.app.dsn#">select * from opciones_pp_venta where empresa_id like '#elusua... read more »