Re: How to insert a sql command into a sql command

2007-09-17 Thread Jochem van Dieten
Richard Colman wrote: > > > > > insert into ChangeLog(actor, ChangeText, UpdateDate) > Values('#actor#','#sqltext#','#datenow#') > Try cfqueryparam. Jochem ~| Get the answers you are looking for on the ColdFusion Labs Foru

Re: Help with File Upload: AJAX and CFFILE

2007-09-17 Thread Andrew Grosset
Here is a neat ajax upload script that uses javascript to create the iframe required for the upload: http://www.ajax-tutorials.com/tutorial-list/resource/AJAX_file_upload/view.php Andrew. > > You're right, I'm just passing a string and not > > actually submitting a form. But why can't I > > a

Re: How to insert a sql command into a sql command

2007-09-17 Thread Charlie Griefer
according to the error message, you're missing a closing quote after 'changeProduct' and '17-Sep-07'. are you sure those quotes are in your code? On 9/17/07, Richard Colman <[EMAIL PROTECTED]> wrote: > I want to log the sql text of various queries into a log table. > > When I try: > > > > > ins

How to insert a sql command into a sql command

2007-09-17 Thread Richard Colman
I want to log the sql text of various queries into a log table. When I try: insert into ChangeLog(actor, ChangeText, UpdateDate) Values('#actor#','#sqltext#','#datenow#') I get errors like: Incorrect syntax near the keyword 'Update'. insert into ChangeLog(actor, ChangeText, UpdateDate) V

Re: IP Address to Country API

2007-09-17 Thread Paul Hastings
Chad McCue wrote: > I am looking for a free API/Script that will take the IP address from > each visitor and find out which country they are coming from. you probably also want seth duffey's cool flash map to display your visitors ala google analytics. www.leaveThatThingAlone.com (appears down j

Re: IP Address to Country API

2007-09-17 Thread Paul Hastings
Chad McCue wrote: > I am looking for a free API/Script that will take the IP address from > each visitor and find out which country they are coming from. http://www.sustainablegis.com/projects/geoLocator/ ~| Check out the new fea

Re: CFGrid does not appear...

2007-09-17 Thread Mike Chabot
When I wrote "empty grid," I was referring to the symptom you described. A grid that isn't visible because there are no cells, leaving you with just a collapsed outline of a table. Make sure you view the rendered HTML to see what the code looks like. -Mike Chabot On 9/17/07, Eron Cohen <[EMAIL P

Re: Pivot table confusion

2007-09-17 Thread Richard Dillman
OK maybe I need to take a step back and give you some more detail. Or maybe I'm just not going to comprehend what you guys are telling me. I have a single table called assessment with these fields. [assessment_id] [int] IDENTITY(1,1) NOT NULL [youth_id] [varchar](26) NOT NULL [org_id] [varchar](

RE: Sharing violation (Dreamweaver, Illustrator, Photoshop & CF8)

2007-09-17 Thread Eric Roberts
That's been a Dreamweaver issue for a long time. It doesn't seem to like to give up control of a file. I have had to close out DW and reopen it before so I could modify a file on the server. Eric -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Monday, September 1

Re: Sharing violation (Dreamweaver, Illustrator, Photoshop & CF8)

2007-09-17 Thread Will Tomlinson
Yep, I've been grapplin with the same issue the last few days. DW8/Vista It's so ridiculous, I just ended up saving the files as another name. lol! I dunno any other way around it when it decides to screwup like that. Will ~|

Re: CFGrid does not appear...

2007-09-17 Thread Eron Cohen
Unfortunately, my issue is that the grid doesn't appear at all. Just a gray line. In doing more troubleshooting, I have found that it doesn't matter if it is in an i-frame or not, just making it part of the page on my site where the iframe was still shows the same issue. If I just refresh the

Re: Sharing violation (Dreamweaver, Illustrator, Photoshop & CF8)

2007-09-17 Thread Les Mizzell
Jason Durham wrote: > Ever since I installed CF8, I have had several ongoing problems that have > become *more* that just annoying. It appears that CF8 is caching files > because I'm getting sharing violations in several different programs. I had this problem with CSS files a version of Dreamwe

Re: CF scheduler log - does it show errors?

2007-09-17 Thread Wil Genovese
Not that I have seen in cf7.0.x. It used to record if the scheduled event failed to complete in cf5 as best as I can remember. -- Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. Scott Weikert wrote: > Me

RE: Cffeed - creating RSS Feeds and guid

2007-09-17 Thread Jayesh Viradiya
Yes RayWhat you have mentioned is correct. For Query, ID=GUID. And While creating a feed via struct, we use the literal values as in the specs. For reading feeds into queries we wanted to provide a common predefined query format which stands for both RSS 2.0 and ATOM 1.0 , hence the query colu

RE: CF 8 Image resize help

2007-09-17 Thread Rick Sanders
Hello Jayesh, Thank you for your quick response! I'll try it out, and continue on with this program! Kind regards, Rick Sanders President Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: Jayesh Viradiya [mailt

Re: Sorting Query - SQL Injection

2007-09-17 Thread Casey Dougall
On 9/17/07, Dave Watts <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > > > >select * > > from > > Order By #Argument.qOrderField# > > > > > > > > How does that prevent SQL injection? > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ Good

Re: Sorting Query - SQL Injection

2007-09-17 Thread Brian Kotek
Most RDBMSs support something like this. But you'd want to cache the results so you only have to do it once. On 9/17/07, Greg Morphis <[EMAIL PROTECTED]> wrote: > > Not sure if your DB supports this but with Oracle I can select the > columns from the table.. > select column_name > from user_tab_co

Re: what's the magic version combination: eclipse/cfeclipse/cfunit

2007-09-17 Thread Janet MacKay
I installed eclipse 3.3, downloaded CFEclipse 1.3.1.5 and it works great. I just had to tweak my shortcut target so eclipse used jre 1.5 (not 1.4.2) eclipse -vm C:\jre1.5.0_11\bin\javaw.exe Thanks again Rich ~| ColdFusion is

Re: 2 NIC windows server with CF/JRUN

2007-09-17 Thread Eric Haskins
I think it has to do with having 2 different Default gateways. I believe you need to make sure you primary nic has default gateway and the secondary doesnt have anything in default gateway I ran into this once and I think that is how I fixed it Eric Haskins On 9/17/07, po poi <[EMAIL PROTECTED

Re: Cffeed - creating RSS Feeds and guid

2007-09-17 Thread Raymond Camden
I've confirmed that what you say is right Jayesh - guid works when you create the feed via struct. So can you confirm if the following statement is correct: When creating a feed via a query, you should name your columns based on what the PDF describes, ie, ID==GUID. When creating a feed via a st

Re: Sorting Query - SQL Injection

2007-09-17 Thread Casey Dougall
> > > Then in the cfswitch statement I have something like this > > > > order by table.user_name > > > order by table.lastlogin_date > > .. > .. I think this is how I would go about the new order by stuff . Instead of switch or if statements. run the query as on

Re: Cffeed - creating RSS Feeds and guid

2007-09-17 Thread Raymond Camden
Jayesh, I was able to create a NPE by not supplying isPermaLink: // Create the feed data structure and add the metadata. myStruct = StructNew(); mystruct.link = "http://www.cnn.com";; myStruct.title = "CNN"; mystruct.description = "This... is... CNN"; mystruct.pubDate = Now(); mystruct.version =

RE: Loop based on if statement

2007-09-17 Thread Scott Raley -ITC
The list pulls starts another query and pulls in two values to compare to the original query values. The intention is to verify if the values from both queries equal each other to run again until they don't equal each other. -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROT

Re: Cffeed - creating RSS Feeds and guid

2007-09-17 Thread Raymond Camden
Jayesh - what about my comment about using "ID" in query? It worked there. And the docs plainly say that ID means GUID in query data. If ID works for query, but GUID works for struct, then I'd consider that a bug - and confusing at that. On 9/17/07, Nathan C. Smith <[EMAIL PROTECTED]> wrote: > O

Re: RETS Real Estate &amp;amp; Coldfusion

2007-09-17 Thread Jeremy Rottman
> Hah, ok apparently you can't just reply to ancient threads... > > I'm trying to do a search with RETS. I am able to login and pull > metadata, just unable to search. Anyone have ANY experience with this > feed, coldfusion or otherwise? I posted a working proof of concept about 4 months ago

Re: PURE apache configuration question

2007-09-17 Thread Ian Skinner
This has been resolved. Yeah. Apparently our apache 1.3.26 server cared about the capitalization of the 'Redirect' directive in the .htaccess file. It fails if it does not see the initial capital "R". ~| ColdFusion is deliv

Re: CFGrid does not appear...

2007-09-17 Thread Mike Chabot
The grid would get populated from an Ajax call. Make sure the JavaScript in the Web page is correctly calling the CFC on the server. The ?cfdebug URL parameter helps identify what is going on. If the Ajax call fails, the result is an empty grid. Make sure you can access your CFC by entering the URL

RE: Cffeed - creating RSS Feeds and guid

2007-09-17 Thread Nathan C. Smith
OK, According to Jayesh Viradiya (Thanks Jayesh!) To use the guid value in cffeed it will look something like this: http://www.google.com";> /me goes to try it out. -Nate > -Original Message- > From: Jayesh Viradiya [mailto:[EMAIL PROTECTED] > Sent: Sunday, September 16, 2007 9:25 P

2 NIC windows server with CF/JRUN

2007-09-17 Thread po poi
I am setting up a cluster of windows 2k3 CF 7 boxes. Each server has 2 NICs, and one NIC on each machine is setup for NLB. I can't connect the CF instances together. The 'register remote server' fails. My hunch is that the traffic is going out on the NLB NIC and getting lost. Besides addin

Re: Sorting Query - SQL Injection

2007-09-17 Thread Greg Morphis
Not sure if your DB supports this but with Oracle I can select the columns from the table.. select column_name from user_tab_columns where table_name = 'MY_TABLE' Granted this would require 2 trips to the database, 1 to get the column names, then check to see if your sortby variable is in that list

what's the magic version combination: eclipse/cfeclipse/cfunit

2007-09-17 Thread Janet MacKay
Is anyone using CFEclipse 1.3.1.5 with Eclipse 3.2.0? I tried to install the plugin several times using Software Updates -> Find and Install option. But I get a ClassNotFoundException when opening the CFUnit perspective. Did I overlook a requirement or is there a better combination of versions?

RE: Sorting Query - SQL Injection

2007-09-17 Thread Dave Watts
> Actually, I was thinking I could just test for the existence > of a semicolon in the passed url variable, and if one exists, > ignore it and default the sort but I'm not a SQL expert. My > guess is that you can still do some ugly things after order > by that doesn't require a semicolon > >

RE: Sorting Query - SQL Injection

2007-09-17 Thread Dave Watts
> I think this is how I would go about the new order by stuff . > Instead of switch or if statements. run the query as one of > the methods in a component, then all you need to do is pass > an argumentcollection item over to handle the Order by portion. > > > > > > >select * >

RE: CF 8 Image resize help

2007-09-17 Thread Jayesh Viradiya
Hi Rick, Your code should be as below as below and it should work. Inside ImageResize() function, you should pass the image Object created through ImageNew() function...that is, "thumb" and not "oldthumb". "oldthumb" is a filename/path which is not accepted by ImageResize function. Thanks

Re: what's the magic version combination: eclipse/cfeclipse/cfunit

2007-09-17 Thread Janet MacKay
Thanks Rich. I'll try 3.3. What jvm/jre are you using? ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Ar

RE: Cffeed - creating RSS Feeds and guid

2007-09-17 Thread Jayesh Viradiya
Hi Nathan, In the repro case provided by you, I could notice that you were trying to use an Invalid attribute(linkhref) for the GUID element. GUID could have only one Optional element that is "isPermaLink". Check RSS 2.0 spec for more information. So modify your Code with the following lines at

RE: what's the magic version combination: eclipse/cfeclipse/cfunit

2007-09-17 Thread Rich
I am currently running eclipse 3.3 with CFE 1.3.1.5. I installed 3.3 and then used the internal update tools (help > software updates > find & install) to install CFE. I'm using the CFUnit view to run unit tests successfully. HTH, Rich Kroll

RE: Server hanging. Wierd problems. HELP!

2007-09-17 Thread Brad Wood
I have special powers... and I saw their blog about it ;) I E-mailed them and asked what version of CF the problem had been encountered on and never heard back. I have always been quite interested in knowing, and wanted to test CF8 for the same problem. For those who hadn't ever heard-- cfswit

Re: Sorting Query - SQL Injection

2007-09-17 Thread Brian Kotek
On 9/17/07, Vince Collins <[EMAIL PROTECTED]> wrote: > > > That suggestion works. However, in an example of a query with 10 > columns and assuming you want to allow desc and asc, does anyone have a > more conscience way other than 20 cfcase statements? You could specify a list of table names an

RE: Loop based on if statement

2007-09-17 Thread Michael E. Carluen
Scott, Please clarify what you are working with; do you have a query with 2 fields (field1: query.id1 and field2: query.id2), and single list with multiple values ('id1', 'id2')? Is you intention to verify the existence of the values contained in either fields to the values of contained in the li

Loop based on if statement

2007-09-17 Thread Scott Raley -ITC
I have a cfif that is run to verify results of a query vs list What happens is that I need whats inside of this cfif to keep running until its false. I tried to put a conditional cfloop around this This still isn't working.. if I output what myvalue is set to alot of the r

CF scheduler log - does it show errors?

2007-09-17 Thread Scott Weikert
Messing about with logging scheduler events. I'm seeing what I expect - "executing" and "rescheduling" entries - but I'm curious if errors in scheduled tasks get logged here as well as the normal application/exception logs? --Scott ~~

Re: Sorting Query - SQL Injection

2007-09-17 Thread Vince Collins
I figured :) Dave Watts wrote: >> Actually, I was thinking I could just test for the existence >> of a semicolon in the passed url variable, and if one exists, >> ignore it and default the sort but I'm not a SQL expert. My >> guess is that you can still do some ugly things after order >> by t

Re: Sorting Query - SQL Injection

2007-09-17 Thread Vince Collins
Actually, I was thinking I could just test for the existence of a semicolon in the passed url variable, and if one exists, ignore it and default the sort but I'm not a SQL expert. My guess is that you can still do some ugly things after order by that doesn't require a semicolon Is this true?

RE: Server hanging. Wierd problems. HELP!

2007-09-17 Thread John Mason
If it's an "old" tag then I would suspect there would be some ways to do this more quickly going directly through java. Before switching your tag, you might want to double check and see if the tag is slow or more simply the response back is slow (making your tag wait). If you are having to wait eac

Re: Sorting Query - SQL Injection

2007-09-17 Thread Vince Collins
I agree with you on this. Greg Morphis wrote: > I dont like using the order by 2 stuff simply because if the query has > 42 columns, and it's 27 I'm looking for, it's a bitch to find.. it's > easier to read "MONTHDATE" or whatever. > Plus if the query changes, whoops.. gotta recount the items (un

RE: IP Address to Country API

2007-09-17 Thread Michael E. Carluen
Hi Chad, I use http://api.hostip.info/?ip= anyIP Contact me offline if you need more. I have modified portions of Matt Robertson's ZipMonger code to create a simple custom UDF, that can calculate the mile proximity of a visitor's machine, to another geo valid coordinate/point. Michael > -

Sharing violation (Dreamweaver, Illustrator, Photoshop & CF8)

2007-09-17 Thread Jason Durham
Ever since I installed CF8, I have had several ongoing problems that have become *more* that just annoying. It appears that CF8 is caching files because I'm getting sharing violations in several different programs. The problem surfaced when editing CSS files in Dreamweaver and frequently refreshi

RE: CF 8 Image resize help

2007-09-17 Thread Jayesh Viradiya
Hi Rick, Your code should be as below as below and it should work. Inside ImageResize() function, you should pass the image Object created through ImageNew() function...that is, "thumb" and not "oldthumb". "oldthumb" is a filename/path which is not accepted by ImageResize function. Thanks

Re: Server hanging. Wierd problems. HELP!

2007-09-17 Thread J W
TCP socket connections to a middleware server that speaks to a database. I make a socket request, it sends me back data. The requests take forever, but it is the only way we can communicate. I use Jsocket a REALLY old tag for coldfusion to accomplish this. Is there a CFHTTP equivilent for TCP or so

Re: Sorting Query - SQL Injection

2007-09-17 Thread Greg Morphis
I dont like using the order by 2 stuff simply because if the query has 42 columns, and it's 27 I'm looking for, it's a bitch to find.. it's easier to read "MONTHDATE" or whatever. Plus if the query changes, whoops.. gotta recount the items (unless its a small change of course) On 9/17/07, Vince Co

RE: Server hanging. Wierd problems. HELP!

2007-09-17 Thread Rich
> Rich, was WebApper by chance the consultant you used? > > ~Brad It was quite a long time, but I do believe it was. Was that just a good guess or do you have special powers? Rich ~| Create robust enterprise, web RIAs. Upgrad

CFGrid does not appear...

2007-09-17 Thread Eron Cohen
I am using ColdFusion 8 and I am running into an odd issue that I can't figure out. I have an HTML cfgrid on an HTML CFFORM that is supposed to appear in an IFRAME. The thing is that the CFGRID doesn't appear as anything but a gray line until I refresh the IFRAME's contents. Then it is fine.

IP Address to Country API

2007-09-17 Thread Chad McCue
I am looking for a free API/Script that will take the IP address from each visitor and find out which country they are coming from. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles o

RE: Server hanging. Wierd problems. HELP!

2007-09-17 Thread Brad Wood
Rich, was WebApper by chance the consultant you used? ~Brad -Original Message- From: Rich [mailto:[EMAIL PROTECTED] Sent: Monday, September 17, 2007 2:15 PM To: CF-Talk Subject: RE: Server hanging. Wierd problems. HELP! If your server was performing well, and then suddenly began these s

RE: Server hanging. Wierd problems. HELP!

2007-09-17 Thread Rich
If your server was performing well, and then suddenly began these seemingly random slowdowns I would look at recently deployed code. When we experienced these types of problems, we brought in a 3rd party consultancy to help diagnose the problem. Our problem turned out to be code that was recently

Re: Server hanging. Wierd problems. HELP!

2007-09-17 Thread J W
I plan to purchase fusion reactor or Seefusion, but I wanted to evaluate both before I chose. Never have I had the need before for either product as everything was running just fine. Now I need it. I'll try your suggestions and see what happens. On 9/17/07, Brad Wood <[EMAIL PROTECTED]> wrote: >

Re: Sorting Query - SQL Injection

2007-09-17 Thread Wil Genovese
Yes, I did this in each case statement. DESC Also the expression for the cfswitch need to be modified to this then I add that to the url sort variable like this. sortby=categoryname,DESC It's that simple -- Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a

Re: Sorting Query - SQL Injection

2007-09-17 Thread Vince Collins
Jochem, good suggestion, then I can test for a numeric value. MS SQL Server does support this but then the application ends up being database specific and more cryptic to read. I could however live with that. Maybe I'm making this a bigger deal than it is. Just seems there should be a more e

Re: Sorting Query - SQL Injection

2007-09-17 Thread Greg Morphis
You could also pass the order by via URL, and that would cut the cfcases by half. On 9/17/07, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > Vince Collins wrote: > > > > That suggestion works. However, in an example of a query with 10 > > columns and assuming you want to allow desc and asc, do

RE: Server hanging. Wierd problems. HELP!

2007-09-17 Thread Brad Wood
I would: * Up the number of simultaneous requests. * Check how much Ram does your server has. Is it a dedicated CF server? You can probably increase your heap size. * Fork over the 300 bucks for SeeFusion Enterprise (Not that much, really) *... and enable the database logging. The counters tabl

RE: cf8 book by Ben Forta - release date?

2007-09-17 Thread David Morgan
Now selling copies on EBAY - $250 a copy if you want em now! just kidding of course - but still wanting to get a copy. Has anyone found a better means than waiting on Amazon or has there been a more accurate date of "on the shelves" release? Was hoping to have it last week but still not getting

Re: Sorting Query - SQL Injection

2007-09-17 Thread Jochem van Dieten
Vince Collins wrote: > > That suggestion works. However, in an example of a query with 10 > columns and assuming you want to allow desc and asc, does anyone have a > more conscience way other than 20 cfcase statements? Check if your database support ordering by the ordinal number of the colu

RE: Server hanging. Wierd problems. HELP!

2007-09-17 Thread John Mason
Sounds like those slow threads stack up at the wrong time for you. The first step here is to see if the CF coding can be fixed or sped up. Jumping into the JVM settings at this point isn't going to solve the core issue. As more traffic hits the box, this problem would only reappear. You need to w

Re: Server hanging. Wierd problems. HELP!

2007-09-17 Thread Wil Genovese
In response to this: In ColdFusion administrator, what is the maximum number of simultaneous requests set to? (default is 15 to 20 I think). The default is more like 3 or 4. If you have two or three hanging threads and your simultaneous requests are set this low then your cf server wil

Re: Server hanging. Wierd problems. HELP!

2007-09-17 Thread J W
I can't tell exactly what happened at the time of last crash to coincide since the trial of SeeFusion I downloaded had a 2hr time limit on it.. However I just installed fusion reactor trial on the system On this server 8 Max simultaneous requests 100mb max post data JVM Arguments 512 Max Heap s

Re: Sorting Query - SQL Injection

2007-09-17 Thread Vince Collins
Thanks Wil, That suggestion works. However, in an example of a query with 10 columns and assuming you want to allow desc and asc, does anyone have a more conscience way other than 20 cfcase statements? I thought about just checking for the existence of the semicolon in the sort variable bein

Re: Sorting Query - SQL Injection

2007-09-17 Thread Barney Boisvert
Yeah, I didn't mean to imply that you shouldn't be concerned about injection. Rather, you only have to worry about injection if 'columnname' is a tainted field. If it's untainted, then injection isn't a concern, so you can safely do the direct substitution. For example, if 'columnname' is coming

RE: Server hanging. Wierd problems. HELP!

2007-09-17 Thread John Mason
You need to use seefusion or fusionreactor to see what exactly is happening. Sounds like a hung cf page that is filling up your available CF threads. John Mason [EMAIL PROTECTED] 770.337.8363 www.FusionLink.com - ColdFusion and Flex hosting Now offering ColdFusion 8 Enterprise hosting FREE Subv

RE: Server hanging. Wierd problems. HELP!

2007-09-17 Thread Brad Wood
What was the memory heap size? In other words, was it 70% of 150 Megs, or 70% of 1,500 megs? In ColdFusion administrator, what is the maximum number of simultaneous requests set to? (default is 15 to 20 I think). How many requests were running at the time the error was encountered? ~Brad

Re: Server hanging. Wierd problems. HELP!

2007-09-17 Thread J W
I had Seefusion running. NOTHING looked out of the ordinary. I had some slow processes, but that expected for some of the third party calls that I have to do on those. Memory was like 70=80%, Is there anything specific I should be looking for using either SeeFusion or Fusion reactor? On 9/17/07,

RE: Pivot table confusion

2007-09-17 Thread Brad Wood
I guess to be fair, I should add that a similar result could be achieved in SQL by declaring a temp table with default column values of zero, pre-populating it with all possible dates etc., then going back and updating the actual values into that table. Then select everything from the temp table,

Re: Sorting Query - SQL Injection

2007-09-17 Thread Wil Genovese
This is all to common even among experienced programmers. I recently caught a major case of this where the entire order by was passed via URL including exposing the table name as well as the column name in the URL. (domain.com?sortby=table.columnname desc) I like to use a cfswitch if there ar

Re: Sorting Query - SQL Injection

2007-09-17 Thread Vince Collins
Thanks Barney, I have to say though that I am willing to bet there are programmers that think their SQL is safe from injection just by using the cfqueryparam and forgetting about the order by clause if they allow that to be passed... select * from tablename order by #columnname# index.cfm?colu

Re: Javascript Book

2007-09-17 Thread Charlie Griefer
i'll second the JavaScript Bible by Danny Goodman. Awesome book. You'll learn from it and you'll keep it for reference. On 9/17/07, Tom Chiverton <[EMAIL PROTECTED]> wrote: > On Monday 17 Sep 2007, [EMAIL PROTECTED] wrote: > > Hi does anyone know of a good javascript book > > The 'JavaScript bib

Re: Sorting Query - SQL Injection

2007-09-17 Thread Barney Boisvert
You can't use params to control the structure of the statement, only the values passed into the statement. If you're concerned about injection, you can attempt to clean the value before inlining it, or use a CF conditional to emit static stuff: nameage cheers, barneyb On 9/17/07, Vince Collins

RE: Pivot table confusion

2007-09-17 Thread Brad Wood
Do you have an example of what you mean? Maybe I've been staring at it too long but i just don't see how to populate non existent data. == Yeah, here's a VERY quick example. It doesn't involve a pivot table, but it shows what I mean by getting around missing v

RE: Server hanging. Wierd problems. HELP!

2007-09-17 Thread Brad Wood
I agree with using SeeFusion or Fusion Rector to see what is going on. In the mean time, cfstat can at least show you if you are getting backup up requests. ~Brad -Original Message- From: John Mason [mailto:[EMAIL PROTECTED] Sent: Monday, September 17, 2007 11:30 AM To: CF-Talk Subject:

Sorting Query - SQL Injection

2007-09-17 Thread Vince Collins
Am I not able to use cfqueryparam in the order by column. Select * from tablename order by The error I'm getting on a windows 2003 server running CF7 is: /[Macromedia][SQLServer JDBC Driver][SQLServer]The SELECT item identified by the ORDER BY number 1 contains a variable as part of the expres

RE: CF Scheduler Help

2007-09-17 Thread John Mason
Or you can simply load in those SSL certs that you need into the jvm cacerts file so they will be trusted. Of course, you will need to update this when those certs get renewed. The internal method Dave is speaking of is probably for less of a hassle. John Mason [EMAIL PROTECTED] 770.337.8363 ww

Re: Blue Dragon and CF Server on same box?

2007-09-17 Thread Jordan Michaels
Just remember to use BD's internal web server instead of linking it through IIS or whatever web server you're using CF Server with. You would then hit your BD pages on port 8080, and your CF pages on normal port 80. Hope this helps! Warm regards, Jordan Michaels Vivio Technologies http://www.vivi

CF 8 Image resize help

2007-09-17 Thread Rick Sanders
Hey list, I'm having a problem using the image resize with a variable with CF 8. The error I'm getting is: Unable to cast an object of type java.lang.String to Image. The error occurred in E:\Websites\ironwillsports\submitvideo3.cfm: line 19 17 :

Re: Pivot table confusion

2007-09-17 Thread Scott Weikert
I assume you're doing a or on the query results directly, as you said you don't know the year is 'til you output. One way might be to create a structure, loop over your query results and populate the structure as you go - then you can look at that structure and see where the gaps are (based o

Server hanging. Wierd problems. HELP!

2007-09-17 Thread J W
On one of our remote clients I am having a W2k3 Server hang on me. It can happen once every couple days or every 10 min. Their system. W2k3, IIS6, Coldfusion MX 7 (Standard) with whatever version of JRUN the intsaller installs. Stock CF settings. Memory usage is fine. nothing that seems out of the

RE: CF8 Docs: A backward step

2007-09-17 Thread Dave Watts
> Still, why remove a highly functional feature? Because the documentation is in PDF format rather than CHM format? I don't see this as removal of a feature, anyway - you can search PDFs just as well as CHMs; the interface is just a little different. Dave Watts, CTO, Fig Leaf Software http://www.

RE: CF Scheduler Help

2007-09-17 Thread Dave Watts
> > But rememberwe're dealing with the Federal Gov't.the motto > > around here is "Security Before Productivity" > > I've used this configuration at several US government > agencies, actually. It's just a matter of wording everything > appropriately for the auditors. I forgot to includ

Re: Shopping Cart Theory

2007-09-17 Thread Les Mizzell
> What would the rest of you consider the optimal way to store items > before checking out? One request that the client made was that you could have an account - but that it be possible to shot/checkout *without* and account as well. So, there's a "sign in to retrieve your data" before you chec

RE: CF Scheduler Help

2007-09-17 Thread Dave Watts
> But rememberwe're dealing with the Federal Gov't.the > motto around here is "Security Before Productivity" I've used this configuration at several US government agencies, actually. It's just a matter of wording everything appropriately for the auditors. Dave Watts, CTO, Fig Leaf Softwa

Re: Blue Dragon and CF Server on same box?

2007-09-17 Thread Tom Chiverton
On Monday 17 Sep 2007, [EMAIL PROTECTED] wrote: > I currently run the developer edition of CF Server on my local box. Am I > going to run into any problems if I install Blue Dragon Server on the same > box? No. -- Tom Chiverton Helping to heterogeneously drive cross-media relationships on: http:

Re: Pivot table confusion

2007-09-17 Thread Richard Dillman
Do you have an example of what you mean? Maybe I've been staring at it too long but i just don't see how to populate non existent data. On 9/17/07, Brad Wood <[EMAIL PROTECTED]> wrote: > > I've always solved that problem by looping over each year I want to > output, then use a query of queries to

Re: Integrating blog / gallery / imagecfc / shopping cart

2007-09-17 Thread Steve Good
>By "Gallery" do you mean like a photo gallery? BlogCFM actually does >photo galleries. > >Not saying I'm recommending it, but if you're willing to customize, >the functionality is already in there. > >rick > >-- >Rick Root >Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at >www.open

Re: CF Scheduler Help

2007-09-17 Thread Tom Chiverton
On Monday 17 Sep 2007, [EMAIL PROTECTED] wrote: > OK...what is wget? A command line GNU tool that will fetch an URL for you. > Here's what I need to do. I need to check our dB to see if an action is > required by a user (for what we'll call a "review"). If the user is > suppose to go perform a

RE: CF Scheduler Help

2007-09-17 Thread Howell, Craig H Civ WRALC/ITMS
OK...what is wget? Here's what I need to do. I need to check our dB to see if an action is required by a user (for what we'll call a "review"). If the user is suppose to go perform a "review" and the review is 9 days late, I need to send a email to their "PHB". I need to check nightly to see if

RE: Shopping Cart Theory

2007-09-17 Thread Billy Cox
I use CF Webstore which stores shopping cart data in a database table. I think this is more customer-friendly since average mortals don't want to be troubled by session expiration. -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Monday, September 17, 2007 9:41 AM T

RE: CF Scheduler Help

2007-09-17 Thread Howell, Craig H Civ WRALC/ITMS
But rememberwe're dealing with the Federal Gov't.the motto around here is "Security Before Productivity" -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, September 17, 2007 10:44 AM To: CF-Talk Subject: RE: CF Scheduler Help > I need help getting the sc

Re: CF Scheduler Help

2007-09-17 Thread Tom Chiverton
> I thought the problem was the certs. It appears that they are not the > problem, but SSL is. How do I get the scheduler to work with SSL? If I > turn SSL off (temporarily), the scheduler works fine. Why not use the operating systems task scheduler, and a non-CF downloader like wget ? -- Tom

Re: Shopping Cart Theory

2007-09-17 Thread Bruce Sorge
I have done both. It really depends on what the client wants and the hosting environment. I did one where the items were held in a temporary database table with a UUID simply because the client wanted to make sure that the customer could come back to their items if they either changed their minds l

RE: Pivot table confusion

2007-09-17 Thread Brad Wood
I've always solved that problem by looping over each year I want to output, then use a query of queries to extract the data for that year (if it even exists) and output it. Then you don't have any gaps. There's probably a better way though. That's just my quick and dirty method. :) ~Brad

Re: Javascript Book

2007-09-17 Thread Tom Chiverton
On Monday 17 Sep 2007, [EMAIL PROTECTED] wrote: > Hi does anyone know of a good javascript book The 'JavaScript bible' is very good, and comes with handy print-out-and-keep DOM cards. -- Tom Chiverton Helping to seamlessly grow enterprise-class e-markets on: http://thefalken.livejournal.com **

Re: Shopping Cart Theory

2007-09-17 Thread Christopher Jordan
I'm for storing them in a table. I suppose that if you wanted to allow "guest" shopping, you could assign a temporary user id (some UUID) and store it on their machine as a cookie, and then use that as a key in the "cart" table. That's just a thought off the top of my head, so there could be some i

  1   2   >