RE: White Space Eliminator

2008-01-21 Thread Dave Watts
> I also seem to recall the saving over HTTP 1.1 is negligible > as it compresses on the fly. However, saying that, I might > be telling complete lies ;) HTTP 1.1 doesn't automatically provide compression. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides t

Multiple RTF to one PDF on the Fly

2008-01-21 Thread Ralph B Littleleaf
We have a little department that have a lot of our records stored in a SQL db as RTF. We have created a search form that can display the results of the search as links to the individual RTF files. What we would like to do is have a button that would concatenate all the RTF into one PDF file for

Re: CFThread Example On LiveDocs.

2008-01-21 Thread s. isaac dealey
> Yes, definite failure of imagination on my part ;) > Good catch at any rate. No worries. I frequently find myself banging my head over something that turns out was fairly simple when I talk to the right person. I think everybody does it. Glad I could help. :) -- s. isaac dealey ^ new epoch

Re: date problem

2008-01-21 Thread Azadi Saryev
yes, obviously. --- Azadi Saryev Sabai-dee.com http://www.sabai-dee.com Tom Chiverton wrote: > On Monday 21 Jan 2008, Azadi Saryev wrote: > >> if it is same for dateformat() and lsdateformat(), why would they return >> different results then? >> > > Because those functions do different

Re: poll - How many MS should it take to load a site's home page?

2008-01-21 Thread Nate Willard
Thanks for everyone's thoughts on around this topic. I enjoyed reading your comments. Incase anyone's interested I highly recommend Yahoo!'s yslow: http://developer.yahoo.com/yslow/ its a great tool for performance issues around this topic. Right now my goal is to always have the site I'm buildi

Re: White Space Eliminator

2008-01-21 Thread Sonny Savage
Yeah, I didn't actually try the regex... thanks for the correction. On Jan 21, 2008 3:49 PM, Ben Doom <[EMAIL PROTECTED]> wrote: > \s* is probably not what you want. * means "0 or more" so it would > insert a space between every character. I would use \s+ or \s{2,} > instead. > > --Ben Doom > >

Re: Read large binary file, MX7?

2008-01-21 Thread Sonny Savage
The byteArray is a Java array object, so CF's arrayLen() function would not work on it. You'd need to use the array's length method like this: response.setContentLength(byteArray.length()); Java's file class also has a length() method that returns the file size in bytes. I'm not a Java programme

Re: White Space Eliminator

2008-01-21 Thread Neil Middleton
There loads of custom tags dotted around the net (I seem to recall one called cf_stripWhitespace or similar) that do this, and give you a load of options on how aggressive they are. I also seem to recall the saving over HTTP 1.1 is negligible as it compresses on the fly. However, saying tha

Re: poll - How many MS should it take to load a site's home page?

2008-01-21 Thread Neil Middleton
Normally I work to a rule of around 2 seconds perceived time before stuff starts appearing on the page with everything else appearing in the next two. The thing with page loads aren't anything to do with ms duration in CF, but the perception by the user. The user does give a t*ss what the

Re: Output to Excel Problem

2008-01-21 Thread Les Mizzell
> I have an export CFC that I use to take care of all the formatting for > me. Maybe I should release it. In its simplest form it takes a query > and exports to xls, csv, txt, etc in about 3 lines of code. Would it be > useful to anyone? Yes it would! ~

RE: Read large binary file, MX7?

2008-01-21 Thread Dave Watts
> CFCONTENT was being used previously, but when a bunch of > users start downloading large files, the server starts crashing... > Most of the files range between 200-500 MB, some up to 1GB > and larger... I strongly suggest you consider my second suggestion, which was to take CF out of the file

Re: Read large binary file, MX7?

2008-01-21 Thread Sarah Geren
CFCONTENT was being used previously, but when a bunch of users start downloading large files, the server starts crashing... Most of the files range between 200-500 MB, some up to 1GB and larger... - Original Message - From: "Craigsell" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday,

Re: Read large binary file, MX7?

2008-01-21 Thread Craigsell
Dave is right --- when in CF use CF! Here's a code snippet fron June 19,2003 entry is Chris Cantrell's blog (he's an Adobe expert) http://weblogs.macromedia.com/cantrell/archives/coldfusion/index.cfm writeOutput(toString(pic)); Just change the content type to what you need! - Ori

Re: White Space Eliminator

2008-01-21 Thread Ben Doom
\s* is probably not what you want. * means "0 or more" so it would insert a space between every character. I would use \s+ or \s{2,} instead. --Ben Doom Sonny Savage wrote: > How about this? > "ALL")> > > On Jan 21, 2008 3:13 PM, Nate Willard <[EMAIL PROTECTED]> wrote: > >> hello, >> >> I l

Re: Read large binary file, MX7?

2008-01-21 Thread Sarah Geren
thanks, I was actually originally trying to use this piece of code that I found using java to read through the object, but I am so not a Java person and got stuck when I needed to add the following parameter: response.setContentLength(arrayLen(byte_arry_here)); into the script so that the browse

Re: White Space Eliminator

2008-01-21 Thread Ben Doom
If you are going to use regular expressions to reduce whitespace, I'd probably use something like rereplace(text, "\s+", " ", "all"); However, I would look carefully at whether this actually speeds up delivery. Full-fledged regex engines are slow, and there are several faster replacement engi

RE: Read large binary file, MX7?

2008-01-21 Thread Dave Watts
> I have an application which uses CFFILE to read a binary file > into a variable, and that variable is used to write out the > video to the brower so someone can download it... Why are you doing this? You can use CFCONTENT to return a file directly. Alternatively (and generally even better), yo

Re: White Space Eliminator

2008-01-21 Thread Charlie Griefer
why wouldn't you replace instances of 2 or more spaces with a single space? seems you're just removing them? On Jan 21, 2008 12:13 PM, Nate Willard <[EMAIL PROTECTED]> wrote: > hello, > > I learned of of an issue with my whitespace reduction > method that is almost funny. > > I do the following t

RE: White Space Eliminator

2008-01-21 Thread Dave Watts
> I learned of of an issue with my whitespace reduction method > that is almost funny. > > I do the following to remove whitespace > > PAGE CONTENTS... > > =REReplace(pageholder_tboutputed, > "[[:space:]]{2,}","","ALL")> > #pageholder_tboutputed# > > What ended up happening today is that

RE: Output to Excel Problem

2008-01-21 Thread FROEHLING, ROBERT (ATTSI)
Yep, just like that. There are many Excel format options that you can apply simply by changing the style, or adding other attributes. Another one that's very handy is adding filters. ... (Those may have to be TDs instead of THs. I can't remember at the moment.) I have an export CFC that I use

Re: poll - How many MS should it take to load a site's home page?

2008-01-21 Thread Sonny Savage
Seems like 4.2 seconds should have been the answer... On Jan 21, 2008 2:58 PM, James Wolfe <[EMAIL PROTECTED]> wrote: > 4 seconds > > http://news.bbc.co.uk/1/hi/technology/6131668.stm > > > >Looking forward to hearing everyone's thoughts. > > > >How many milliseconds should it take for a site's h

Re: White Space Eliminator

2008-01-21 Thread Sonny Savage
How about this? On Jan 21, 2008 3:13 PM, Nate Willard <[EMAIL PROTECTED]> wrote: > hello, > > I learned of of an issue with my whitespace reduction > method that is almost funny. > > I do the following to remove whitespace > > > PAGE CONTENTS... > > =REReplace(pageholder_tboutputed, > "[[

White Space Eliminator

2008-01-21 Thread Nate Willard
hello, I learned of of an issue with my whitespace reduction method that is almost funny. I do the following to remove whitespace PAGE CONTENTS... #pageholder_tboutputed# What ended up happening today is that one of the sources I pull in information from had double spaced between words.

Re: Read large binary file, MX7?

2008-01-21 Thread Sonny Savage
Any time I find a bottleneck with CF tags, I generally go looking for a Java solution. These pages may have useful snippets... http://www.coldfusionmuse.com/index.cfm/2006/10/26/Java.directory.list http://java.sun.com/j2se/1.4.2/docs/api/java/io/File.html http://www.scripts.com/coldfusion-scripts/

RE: listGetAt comma problem

2008-01-21 Thread Mark Proper
Thanks for the suggestion. That was a simplified example that I was testing with to resolve this problem, and the actual production string has roughly 20 fields I need to get at. -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Monday, January 21, 2008 2:52 PM To:

Re: poll - How many MS should it take to load a site's home page?

2008-01-21 Thread James Wolfe
4 seconds http://news.bbc.co.uk/1/hi/technology/6131668.stm >Looking forward to hearing everyone's thoughts. > >How many milliseconds should it take for a site's home >page to load? ~| Adobe® ColdFusion® 8 software 8 is the mo

Re: Read large binary file, MX7?

2008-01-21 Thread Craigsell
>From http://www.tri-phase.com/data/pdf/coldfusioncookbook41.pdf Does CFFILE have a file size limit? There is no specific limit on file size for CFFILE. However, CFFILE loads the file into the server's memory, so you will get an error if the file size exceeds the amount of free RAM. Also note,

Re: This evaluate thing always stumps me...

2008-01-21 Thread Sonny Savage
On a more "personal style" note, I generally do a cfparam on all my form variables and then loop over the form structure and trim() all the values. I then do not have to check for existence or trim when checking length. On Jan 21, 2008 2:32 PM, Charlie Griefer <[EMAIL PROTECTED]> wrote: > On Jan

Re: This evaluate thing always stumps me...

2008-01-21 Thread Brian Kotek
Again, these really should be using StructKeyExists: On Jan 21, 2008 1:48 PM, Les Mizzell <[EMAIL PROTECTED]> wrote: > This one works: > >AND Form['grp_sort_#myIDX#'] NEQ ""> > > > Jezz, thanks... > > ~| Adobe® Cold

RE: listGetAt comma problem

2008-01-21 Thread Mark Proper
That did it! It's so simple I can't believe I didn't try it. Thank you so much. I think you just saved my job (or at the very least, a missed deadline and a chewing out by the boss) -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Monday, January 21, 2008 2:46

Re: listGetAt comma problem

2008-01-21 Thread Charlie Griefer
btw... strictly a matter of preference here, but *if* you know you're only going to have 2 list elements, i generally go with listFirst() and listLast() in place of the listGetAt() function. One less argument to type in :) On Jan 21, 2008 11:46 AM, Sonny Savage <[EMAIL PROTECTED]> wrote: > This w

Re: listGetAt comma problem

2008-01-21 Thread Sonny Savage
This works: Company = #listGetAt(custom, 1, '*')# Location = #listGetAt(custom, 2, '*')# #currentValue# On Jan 21, 2008 2:22 PM, Mark Proper <[EMAIL PROTECTED]> wrote: > My apologies if you get this twice...first time using this resource and > I did not see the post show up. Trying it a

RE: listGetAt comma problem

2008-01-21 Thread Bobby Hartsfield
Remove the cfloop tags Company = #listGetAt(custom, 1, '*')# Location = #listGetAt(custom, 2, '*')# ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Mark Proper [mailto:[EMAIL PROTECTED] Sent: Monday, January 21, 2008 2:22 PM To: CF-Talk Sub

Re: This evaluate thing always stumps me...

2008-01-21 Thread Charlie Griefer
On Jan 21, 2008 11:18 AM, Sonny Savage <[EMAIL PROTECTED]> wrote: > You really should use this: > & myIDX]) GT 0 )> if you're going to validate against the len(), you really should throw a trim() in there for good measure :) -- "Scientists tell us that the fastest animal on earth, with a top s

Re: listGetAt comma problem

2008-01-21 Thread Charlie Griefer
On Jan 21, 2008 11:22 AM, Mark Proper <[EMAIL PROTECTED]> wrote: > I have a string that I knew was going to have commas in it (such as > company names or address) so I made the delimiter in the string an > asterisk. > Here is small example code I've been trying to get working: > > > > > >

Read large binary file, MX7?

2008-01-21 Thread Sarah Geren
Hello, I have an application which uses CFFILE to read a binary file into a variable, and that variable is used to write out the video to the brower so someone can download it... This code is working great, until the file sizes become too large. It seems to stop working (and returns a null null

RE: CF LIST User Manager

2008-01-21 Thread Bobby Hartsfield
I got the same but it has been at least a week ago and only the one time. ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: Monday, January 21, 2008 2:04 PM To: CF-Talk Subject: CF LIST User Manager

Re: This evaluate thing always stumps me...

2008-01-21 Thread Claude Schneegans
>> -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8

listGetAt comma problem

2008-01-21 Thread Mark Proper
My apologies if you get this twice...first time using this resource and I did not see the post show up. Trying it again: I have a string that I knew was going to have commas in it (such as company names or address) so I made the delimiter in the string an asterisk. Here is small example co

Re: This evaluate thing always stumps me...

2008-01-21 Thread Sonny Savage
You really should use this: On Jan 21, 2008 1:40 PM, Les Mizzell <[EMAIL PROTECTED]> wrote: > Andy Matthews wrote: > > Get rid of the Evaluate statement. > > > > This: evaluate("form.grp_sort_#myIDX#") > > > > Becomes this: FORM["grp_sort_#myIDX#"] > > or this: FORM["grp_sort_" & myIDX] > > >

Re: writing insert query sql in coldfusion

2008-01-21 Thread Craigsell
A lot depends on what level of access you have to the database. I have full control over all of mine so it never impacted me. I find I can really up the data validation, type checking, and speed by taking advantage of the oracle or sql server proc capability. I find my CF code is cleaner since

CF LIST User Manager

2008-01-21 Thread Robert Harrison
Is anyone else getting emails from the CF List Manager. It's keeps sending me my log-in ID and password. Anyone else getting this? Are we supposed to do something? Robert B. Harrison Director of Interactive services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231

Re: CFThread Example On LiveDocs.

2008-01-21 Thread C S
>Welcome. Yeah QoQ doesn't set the variable until after it creates the >resultset, same way you can say myVar = listToArray(myVar), you're declaring >the name of the var you want to set before you're telling it to fetch its >value from the same var name. :P Yes, definite failure of imagination on

Re: This evaluate thing always stumps me...

2008-01-21 Thread Les Mizzell
Andy Matthews wrote: > Get rid of the Evaluate statement. > > This: evaluate("form.grp_sort_#myIDX#") > > Becomes this: FORM["grp_sort_#myIDX#"] > or this: FORM["grp_sort_" & myIDX] Invalid CFML construct found on line 115 at column 24. ColdFusion was looking at the following text: grp_sort

Re: This evaluate thing always stumps me...

2008-01-21 Thread Les Mizzell
This one works: Jezz, thanks... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.c

Re: This evaluate thing always stumps me...

2008-01-21 Thread Sonny Savage
Adding to Charlie's advice... structKeyExists() is faster than isDefined() and I have not found a case where it couldn't be used instead. It can be used on local values by checking the variables scope: structKeyExists(variables, "localVarName") On Jan 21, 2008 1:29 PM, Andy Matthews <[EMAIL PROT

RE: This evaluate thing always stumps me...

2008-01-21 Thread Dave Francis
If you're on CF5 or previous, this will have to be 2 statements: -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Monday, January 21, 2008 1:24 PM To: CF-Talk Subject: This evaluate thing always stumps me... This evaluate thing, which doesn

RE: This evaluate thing always stumps me...

2008-01-21 Thread Dave Watts
> If you're on CF5 or previous, this will have to be 2 statements: > > > I'm pretty certain that short-circuit evaluation was introduced in CF 4.0.1. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized

Re: This evaluate thing always stumps me...

2008-01-21 Thread Crow T. Robot
This is a great little reference to bookmark, just in case you forget in the future. http://cfprimer.blogspot.com/2005/03/avoid-evaluate.html On Jan 21, 2008 12:29 PM, Andy Matthews <[EMAIL PROTECTED]> wrote: > Get rid of the Evaluate statement. > > This: evaluate("form.grp_sort_#myIDX#") > > Be

RE: This evaluate thing always stumps me...

2008-01-21 Thread Dave Watts
Sorry, I meant to type this: Square brackets, not parentheses. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on

Re: This evaluate thing always stumps me...

2008-01-21 Thread Brian Kotek
Or better, use StructKeyExists to avoid any potential ambiguity: http://corfield.org/blog/index.cfm/do/blog.entry/entry/isDefined_vs_structKeyExists On Jan 21, 2008 1:28 PM, Jonathon Stierman <[EMAIL PROTECTED]> wrote: > You don't need to use Evaluate() to perform that isDefined check. > > Simpl

RE: This evaluate thing always stumps me...

2008-01-21 Thread Bobby Hartsfield
form['grp_sort_' & myIDX] to make sure what you are looking for is even there. ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Monday, January 21, 2008 1:24 PM To: CF-Talk Subject: This evaluate th

RE: This evaluate thing always stumps me...

2008-01-21 Thread Jonathon Stierman
You don't need to use Evaluate() to perform that isDefined check. Simply use: If you need to get the reference to that variable, use array notation on your Form struct: Form['grp_sort_#myIDX#'] Jonathon ~| Adobe® ColdFusi

Re: This evaluate thing always stumps me...

2008-01-21 Thread Josh Nathanson
That should do it, and without the need for Evaluate. -- Josh - Original Message - From: "Les Mizzell" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, January 21, 2008 10:23 AM Subject: This evaluate thing always stumps me... > This evaluate thing, which doesn't work below, alway

Re: This evaluate thing always stumps me...

2008-01-21 Thread Charlie Griefer
also, could you elaborate on "doesn't work"? On Jan 21, 2008 10:23 AM, Les Mizzell <[EMAIL PROTECTED]> wrote: > This evaluate thing, which doesn't work below, always stumps me.. > > > > >AND #evaluate("form.grp_sort_#myIDX#")# NEQ ""> > > > > > > > which, for myIDX = "115", gets you "

RE: This evaluate thing always stumps me...

2008-01-21 Thread Andy Matthews
Get rid of the Evaluate statement. This: evaluate("form.grp_sort_#myIDX#") Becomes this: FORM["grp_sort_#myIDX#"] or this: FORM["grp_sort_" & myIDX] -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Monday, January 21, 2008 12:24 PM To: CF-Talk Subject: This evaluat

RE: This evaluate thing always stumps me...

2008-01-21 Thread Dave Watts
>AND #evaluate("form.grp_sort_#myIDX#")# NEQ ""> Since CF 4, you don't really need to do this much work. And beside that, IsDefined automatically evaluates its argument. Here's all you need: Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest

Re: poll - How many MS should it take to load a site's home page?

2008-01-21 Thread Don L
This is a great thread with very interesting inputs and I want to thank everyone for that. Here's my take (not research result but more on 'gut' instinct), different demographics may have a slightly different tolerant level for page loading speed. The younger could be less tolerant of speed wh

Re: writing insert query sql in coldfusion

2008-01-21 Thread Crow T. Robot
To play Devil's advocate here...you lose a lot of portability & code readability with SP's. I personally only use them when it makes sense (speed or DB-only functionality - DTS comes to mind here) to do so. On Jan 21, 2008 12:16 PM, Craigsell <[EMAIL PROTECTED]> wrote: > And to further emphasize

This evaluate thing always stumps me...

2008-01-21 Thread Les Mizzell
This evaluate thing, which doesn't work below, always stumps me.. which, for myIDX = "115", gets you "Variable form.grp_sort_115 is undefined". What's the best way to rewrite this so it works.. TIA ~| Ad

Re: cfwindow again

2008-01-21 Thread Don L
This is definitely a helpful idea/take. I ran a search for all occurances of js for the app, and manually encapsulated them inside head tag to no avail. Thanks for being there though ... >Sorry, > >I knew it wouldn't be, but the cfwindow DOES not need to be in a >table, even if there is another n

Re: writing insert query sql in coldfusion

2008-01-21 Thread Craigsell
And to further emphasize that -- I would encourage the use of stored procedures whenever possible. I've been using Oracle stored procdures with CF for years with great success. You all the benefits of the CFQUERYPARAM and you let the database do what it does best -- process data. Warren Koch

RE: poll - How many MS should it take to load a site's home page?

2008-01-21 Thread Dave Watts
> It's a pet peeve of mine (I'm not really talking about what > you said) but developer's really have to stop assuming that > people are as sophisticated as they are. More specifically > (and less arrogantly) they have to stop assuming that people > actually give a rat's ass about the stuff th

RE: writing insert query sql in coldfusion

2008-01-21 Thread Dave Watts
> > out of interest what is the difference in using the > > cfqueryparam and not? > > Well, the biggest reason is that it provides significant > protection against SQL injection attacks. It basically does > in-line data validation. Ben (and everyone else who's posted) is right that you should u

Re: allowable characters

2008-01-21 Thread Claude Schneegans
Also beware of quotes and double quotes that may interfere with CF, SQL or HTML statements. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~

Re: allowable characters

2008-01-21 Thread Charlie Griefer
On Jan 21, 2008 9:26 AM, Richard White <[EMAIL PROTECTED]> wrote: > just wondering if anyone has done a review on what characters i can allow the > user to input into form fields that wont cause problems in javascript and > coldfusion. > > for example, if we allow them to enter a carriage return

Re: allowable characters

2008-01-21 Thread Todd
In my opinion, everything is allowed and shouldn't cause an issue, but there are some scenarios where you don't expect them or don't want them and you have to strip them out either on the insert or on the data retrieval. This is part of data validation. It's up to you to determine what *your *rul

allowable characters

2008-01-21 Thread Richard White
Hi just wondering if anyone has done a review on what characters i can allow the user to input into form fields that wont cause problems in javascript and coldfusion. for example, if we allow them to enter a carriage return then when we get data out of the database, if we use that value in a j

RE: poll - How many MS should it take to load a site's home page?

2008-01-21 Thread Jim Davis
> -Original Message- > From: Tom Chiverton [mailto:[EMAIL PROTECTED] > Sent: Monday, January 21, 2008 5:21 AM > To: CF-Talk > Subject: Re: poll - How many MS should it take to load a site's home > page? > > On Sunday 20 Jan 2008, Dave Francis wrote: > > Slightly different scenario, but bac

Re: writing insert query sql in coldfusion

2008-01-21 Thread Ben Doom
Well, the biggest reason is that it provides significant protection against SQL injection attacks. It basically does in-line data validation. There have been several discussions here on the list of the various benefits, so a quick search at the HoF site should give you a good idea about it.

Re: writing insert query sql in coldfusion

2008-01-21 Thread Charlie Griefer
On Jan 21, 2008 7:58 AM, Richard White <[EMAIL PROTECTED]> wrote: > >Also, alot of people will advise you to use cfqueryparam (me included), so > >the code would look like: > > out of interest what is the difference in using the cfqueryparam and not? http://www.adobe.com/devnet/coldfusion/articles

Re: writing insert query sql in coldfusion

2008-01-21 Thread Richard White
>Also, alot of people will advise you to use cfqueryparam (me included), so >the code would look like: out of interest what is the difference in using the cfqueryparam and not? thanks ~| Adobe® ColdFusion® 8 software 8 is the m

Re: writing insert query sql in coldfusion

2008-01-21 Thread Richard White
> password="#dbPassword#"> > insert into testTable(testID,data1,data2) > values ( , > , > ) > oh i see, no there isnt a good reason except i wasnt aware of it this way :) thanks ~| Adobe® ColdFusion® 8 software 8 is the most i

Re: writing insert query sql in coldfusion

2008-01-21 Thread Richard White
thanks very much for all your help, i didnt even realise i could use the has signs inside a string like that so your right i can cut out alot of the concatenation and also thanks for the preservesinglequotes() it works fine thanks again for your help. i can now change alot of my code to take out

Re: writing insert query sql in coldfusion

2008-01-21 Thread Claude Schneegans
>>I'm pretty sure you don't need to use all that concatention. But he still needs preserveSingleQuotes. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED])

Re: writing insert query sql in coldfusion

2008-01-21 Thread Dominic Watson
> > I'm pretty sure you don't need to use all that concatention. Try: > > > > Warren Koch Also, is there a very good reason why you don't build the query string inside your cfquery tags? i.e. insert into testTable(testID,data1,data2) values (#testIDValue#,'#data1Value#','#data2Value#')

RE: CFThread Example On LiveDocs.

2008-01-21 Thread Che Vilnonis
Thanks Isaac & C S. That worked great! Adobe should add this code to the Live docs! -Original Message- From: s. isaac dealey [mailto:[EMAIL PROTECTED] Sent: Saturday, January 19, 2008 5:28 PM To: CF-Talk Subject: Re: CFThread Example On LiveDocs. > Nice. That is much cleaner. I forgot y

Re: writing insert query sql in coldfusion

2008-01-21 Thread Craigsell
I'm pretty sure you don't need to use all that concatention. Try: Warren Koch - Original Message - From: "Richard White" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Monday, January 21, 2008 4:42 AM Subject: writing insert query sql in coldfusion > Hi, i have a very strange error occuri

Re: cfwindow again

2008-01-21 Thread Andrew Scott
Sorry, I knew it wouldn't be, but the cfwindow DOES not need to be in a table, even if there is another next to it. I still believe you have JS that is being called that is not in the head tag. On 1/21/08, Don L <[EMAIL PROTECTED]> wrote: > Sorry, because there's another cfwindow next to it, H

RE: writing insert query sql in coldfusion

2008-01-21 Thread Adrian Lynch
Take a look at PreserveSingleQuotes(). That should fix things. Adrian http://www.adrianlynch.co.uk/ -Original Message- From: Richard White Sent: 21 January 2008 10:43 To: CF-Talk Subject: writing insert query sql in coldfusion Hi, i have a very strange error occuring when trying to buil

Re: cfwindow again

2008-01-21 Thread Don L
Sorry, because there's another cfwindow next to it, HTML table seems to be a way to do it. I just disabled the table, with the same outcome, so, the HTML table does not seem to be the culprit. Another thing, the "view source code" for the "cfdebug" portion revealed the following: (see my comme

Re: From Java to ColdFusion, a newbie

2008-01-21 Thread Abigail Coker
> Abigail try the set of code below, it deals with the last 2 line of > the Java code, you needed to create an object for imageIO, let us know > if it works: > Whao! Fantastic Jide that worked, absolute magic, I've spent hours and hours on this with absolutely no luck, I really appreciate it.

Re: From Java to ColdFusion, a newbie

2008-01-21 Thread Jide Aliu
Abigail try the set of code below, it deals with the last 2 line of the Java code, you needed to create an object for imageIO, let us know if it works: ~| Adobe® ColdFusion® 8 software 8 is the most important and dra

writing insert query sql in coldfusion

2008-01-21 Thread Richard White
Hi, i have a very strange error occuring when trying to build an insert query in coldfusion then trying to run it in a query i have an app that manipulates alot of sql code. it builds tables and inserts values into them. i have got it building tables fine except when i try to run an insert code

Re: date problem

2008-01-21 Thread Richard White
thanks very much for your replies and discussions i will try this and see if it works thanks again ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.

Re: date problem

2008-01-21 Thread Tom Chiverton
On Monday 21 Jan 2008, Azadi Saryev wrote: > if it is same for dateformat() and lsdateformat(), why would they return > different results then? Because those functions do different things. -- Tom Chiverton Helping to seamlessly mesh real-time mindshares on: http://thefalken.livejournal.com

Re: poll - How many MS should it take to load a site's home page?

2008-01-21 Thread Tom Chiverton
On Sunday 20 Jan 2008, Dave Francis wrote: > Slightly different scenario, but back in the days of big iron (CICS and > 3270? terminals), IBM came up with a study that stated that anything over a > 2sec response time "caused anxiety in the user". Different era. Users are more used to waiting for th

Re: Strange Characters Appearing in Browser

2008-01-21 Thread Tom Chiverton
On Friday 18 Jan 2008, Steve LaBadie wrote: > appears in the browser. The software company feels that ColdFusion is > causing this issue, but I am not convinced of this. Obvious test: Save the editor page as static HTML and see if it goes wrong. -- Tom Chiverton Helping to revolutionarily drive