tonight. My wife and I bought our first house today...
Thanks (and thanks to Joe too),
Ray
At 05:44 PM 8/18/04, you wrote:
>Thank Joe Rinehart -- he created the code.
>
>As to executing a query within cfscript
>
>Know you can't --- but you can fudge it
>
>create a function (or CFC that issues the query based on a string
>passed to it. The string contains the SQL statements).
>
>within the script tag invoke the function which returns the record set
>
>Howie Hamlin had a thread on this earlier today.
>
>
>BTW, It is generally thought to be a good idea to generalize this
>approach and put all your db calls into CFCs ( code reusability). I
>have even seen recommendations that you write these CFCs like like OOP
>objects with getters and setters for each field in the db. I don't
>know if that level of implementation is warranted on most projects.
>
>But I do find it useful to gather all my queries into a CFC (or CFCs)
>where a function has a default columnlist and action that can be
>overridden when the function is called.
>
>Dick
>
>
>On Aug 18, 2004, at 2:03 PM, Ray Champagne wrote:
>
> > So, I have a question after playing around with this (wow is it much
> > faster
> > than the easycfm way!):
> >
> > I read up a little on cfscript, is it really true that there is no
> > way to
> > use SQL queries inside a cfscript block? I am VERY new to cfscript,
> > but I
> > thought that there was a way that has been mentioned in here
> > before. This
> > method is not going to do me much good if I can't parse out and put
> > vals in
> > the DB...
> >
> > Thanks Dick, this is pretty cool...
> >
> > Ray
> >
> > At 03:50 PM 8/18/2004, you wrote:
> > >Ray, here's the line reader that Joe Rinehart suggested (with a
> > slight
> > >mod).
> > >
> > >Enjoy!
> > >
> > >Dick
> > >
> > > Hey Joe
> > >
> > > Your No Class Reader Works Great!
> > >
> > > much faster than the other! (almost as fast as a cffile read of
> > > the
> > > entire file).
> > >
> > > I simplified the EOF test so I could use a While loop.
> > >
> > > Thanks
> > >
> > > Dick
> > >
> > > Here's the revised code:
> > >
> > > <cfsetting enableCFOutputOnly="yes" />
> > > <cfset lineCount = 0 />
> > >
> > > <cfset timer = GetTickCount() />
> > >
> > > <cfscript>
> > > filename = "/Users/Richard/Music/iTunes/iTunes Music
> > Library.xml";
> > > fileReader = createObject("java", "java.io.FileReader");
> > > fileReader = fileReader.init(filename);
> > > lineReader = createObject("java","java.io.LineNumberReader");
> > > lineReader = lineReader.init(fileReader);
> > >
> > > thisLine = true;
> > > while (isDefined("thisLine")) {
> > > thisLine = lineReader.readLine();
> > > lineCount = LineCount + 1; // do any processing of the line
> > here
> > > }
> > >
> > > </cfscript>
> > >
> > > <cfoutput>
> > > <br>count = #lineCount# | #GetTickCount() - timer#
> > > </cfoutput>
> > > <cfsetting enableCFOutputOnly="no" />
> > >
> > > I always forget to kill blank lines on this sort of thing --
> > > very
> > > important
> > >
> > > On Jun 16, 2004, at 6:28 AM, Joe Rinehart wrote:
> > >
> > > > Hey Dick,
> > > >
> > > > I've done a similar thing, but didn't create the external
> > > > CFBufferedReader class. Do you see any reason why the
> > > following
> > > > wouldn't
> > > > provide the same?
> > > >
> > > > <cfscript>
> > > > filename = "c:\cfusionmx\wwwroot\lineNumberReader.cfm";
> > > > fileReader = createObject("java", "java.io.FileReader");
> > > > fileReader = fileReader.init(filename);
> > > > lineReader = createObject("java","java.io.LineNumberReader");
> > > > lineReader = lineReader.init(fileReader);
> > > > </cfscript>
> > > >
> > > > <cfset eof = false>
> > > > <cfloop condition="not eof">
> > > > <cfset thisLine = lineReader.readLine()>
> > > > <cfif not isDefined("thisLine")>
> > > > <cfset eof = true>
> > > > <cfelse>
> > > > <cfoutput>#htmlEditFormat(thisLine)#<br></cfoutput>
> > > > </cfif>
> > > > </cfloop>
> > > >
> > > > (when lineReader instance hits the end of the file,
> > > readLine()
> > > > returns
> > > > a result that causes thisLine to become undefined in the eyes
> > > of CF)
> > > >
> > > > -joe
> > > >
> > > _____
> > >
> > >
> > >
> >
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
