Alright guys, time to share. But before I attach them to the email I need to ask if this is a no no? is it okay to attach four files to this email and send it out to the list? If not ill zip them up and stick them on my website...
There are four files, you will just download them and stick them in a directory, mine is named qbrowser. and then just browse to index. the first time you hit it, its going to hit the coldfusion service factory to get the datasources, so be patient. It will save them in the application scope though so it wont be a problem after that. I have also put some logic in that will not let you do any inserts, updates or deletes from this form. Even still, this is a potentially dangerous piece of software, so use it at your own risk, and keep it guarded. Ive added a couple bells and whistles to it, although for the most part its still pretty ugly. Ill pretty it up when i get time maybe. Please guys, let me know what you think. If you find any sql keywords that I missed let me know. Anything that you guys can think of to make it better let me know that too. Im thinking the next thing Ill work on is the ability to have a drop down box with your previous queries, like a history. If enough people like this ill see about packaging it up for everyone. thanks guys, On 9/20/05, Ryan Guill <[EMAIL PROTECTED]> wrote: > No, this isnt a problem. I am only storing the actual sql of the > query, the stuff that goes inside the cfquery tag, in the temporary > text file. So its not a problem. > > Im going to clean this up some and then ill post what ive got to the > group so everyone can have it. Its already proven to be quite useful. > > On 9/20/05, Ian Skinner <[EMAIL PROTECTED]> wrote: > > >><cfquery name="variables.q" datasource="#form.ds#"> > > #form.sqlQuery# > > </cfquery> > > > > >>It works beautifully. My problem and question is... > > > > I can see another issue: single quotes. > > > > That is why, if you look at my example code, I reversed the quotes. > > > > "<cfquery name='variables.q' > > datasource='#form.ds#'>#form.sqlQuery#</cfquery>" > > > > This will allow single quotes inside the string with no problem, and since > > queries seldom contain double quotes all should be well, albeit if it did, > > something would have to be done about the interior double quotes. > > > > > > -------------- > > Ian Skinner > > Web Programmer > > BloodSource > > www.BloodSource.org > > Sacramento, CA > > > > "C code. C code run. Run code run. Please!" > > - Cynthia Dunning > > > > Confidentiality Notice: This message including any > > attachments is for the sole use of the intended > > recipient(s) and may contain confidential and privileged > > information. Any unauthorized review, use, disclosure or > > distribution is prohibited. If you are not the > > intended recipient, please contact the sender and > > delete any copies of this message. > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218798 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
