RE: cfinsert multiple records into DB

2010-02-11 Thread Chad Gray
Just keep adding them to the form then on your action page you get their value like this: #FORM.carpool_location# -Original Message- From: Barry Mcconaghey [mailto:bmcconag...@gmail.com] Sent: Thursday, February 11, 2010 2:07 PM To: cf-talk Subject: Re: cfinsert multiple records into

RE: cfinsert multiple records into DB

2010-02-11 Thread Chad Gray
Carpool_location is probably a string data type in the database? Strings need to be surrounded by single quotes. I would do like Leigh suggested. It is best practice to use cfqueryparam. You may need to adjust the cfsqltype to what you database fields are. I guessed numeric and varchar.

PDF forms submitting to URL

2010-02-10 Thread Chad Gray
I am experimenting with a form in a PDF. It submits the FDFX data to a ColdFusion page http://foo.com/takeInFDF.cfm How do I parse the data on the CF page? I CFDumped the FORM and URL scope and they are empty. Anyone know how the FDFX xml data is passed to the URL so I can parse it?

RE: PDF forms submitting to URL

2010-02-10 Thread Chad Gray
Thanks Leigh! It is binary data, lovely. I think I will switch to HTML instead of FDF in the PDF form. Looks like using HTML the data is sent as a FORM object. Thanks again! Chad -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Wednesday, February 10, 2010 11:45

dev licensing

2010-02-10 Thread Chad Gray
I will start a new thread. I have not had time to look into the dev licensing. Do you just use your production license key on your dev server? Thanks, Chad -Original Message- From: Adrocknaphobia [mailto:adrocknapho...@gmail.com] Sent: Wednesday, February 10, 2010 1:24 PM To:

best function

2010-02-05 Thread Chad Gray
I there, or what is the best function to use to make sure text being placed in JS is JS safe? I have for example some text that contains a single quote and when I CFoutput it into the JS the JS breaks. URLEncodedFormat? Thanks! Chad

RE: best function

2010-02-05 Thread Chad Gray
CF has a function for everything. Thanks! Chad -Original Message- From: Gerald Guido [mailto:gerald.gu...@gmail.com] Sent: Friday, February 05, 2010 12:50 PM To: cf-talk Subject: Re: best function jsStringFormat(String) On Fri, Feb 5, 2010 at 12:44 PM, Chad Gray cg...@careyweb.com

var scoping cfscript in a CFC

2010-02-01 Thread Chad Gray
When putting cfscript in a CFC function do you need to use cfset var foo = on variables created in the cfscript? Thanks, Chad ~| Want to reach the ColdFusion community with something they want? Let them know on the House of

RE: var scoping cfscript in a CFC

2010-02-01 Thread Chad Gray
Sure, that would read better. Thanks! -Original Message- From: Matt Quackenbush [mailto:quackfu...@gmail.com] Sent: Monday, February 01, 2010 11:54 AM To: cf-talk Subject: Re: var scoping cfscript in a CFC Why wouldn't you simply do... cfscript var foo = bar; /cfscript ? But

cfscript's cfabort

2010-01-29 Thread Chad Gray
I have some CFScript running and each time I set a variable I run a function to check if there is an error. If there is an error I would like to “CFAbort” the scripting so it does not continue. Can you abort the rest of the script if the error function is called? I tried break; in the

RE: cfscript's cfabort

2010-01-29 Thread Chad Gray
Nope CF8. I will put this on the list of reasons to upgrade though. -Original Message- From: Raymond Camden [mailto:rcam...@gmail.com] Sent: Friday, January 29, 2010 10:30 AM To: cf-talk Subject: Re: cfscript's cfabort CF9? If so, use abort;

RE: cfscript's cfabort

2010-01-29 Thread Chad Gray
Interesting idea... I could just take my function and put the entire thing in it. Then call it. I will try it out. Thanks Chad -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Friday, January 29, 2010 10:44 AM To: cf-talk Subject: RE: cfscript's cfabort Nope

createObject COM and ReleaseComObject

2010-01-29 Thread Chad Gray
If anyone has been following my posts I am working with a COM object to create PDFs. I place images, text etc on the PDF at exact places (x/y coordinates) using ActivePDF. Now I am reading up on using COM objects and there is the releaseComObject function that I can call to dump the

RE: Clients Can't Login - IE8 Caching?

2010-01-29 Thread Chad Gray
I have seen some problems with jQuery and IE8 caching. IE8 sees the same URL variables and decides to use the cached page rather than loading the page again. I added a time stamp variable (foo=hhmmss) to my URLs and IE sees the different URL variables and loads the page rather than using the

CF8 .net and ActivePDF

2010-01-28 Thread Chad Gray
We have a .net program that uses ActivePDF Toolkit to dynamically create PDFs. We place images, text, etc on the PDFs in exact places. I thought I would experiment with using CF8’s .net capabilities, but I am not getting very far. If I use COM I get an object back, but I would like to use

RE: CF8 .net and ActivePDF

2010-01-28 Thread Chad Gray
Nevermind, found out it is a COM object with a .net wrapper. So COM is the right way to go. -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Thursday, January 28, 2010 12:23 PM To: cf-talk Subject: CF8 .net and ActivePDF We have a .net program that uses

structFindValue

2010-01-21 Thread Chad Gray
Ok... so structFindValue returns and array with a structure in it. How do I output a value in that structure? I CFDump it and it has this in it, hopefully you understand what I mean. Array 1 Struct 1 Key - Type Owner Struct Cost - 50

RE: structFindValue

2010-01-21 Thread Chad Gray
Thanks Jason! That worked. I would putting the [] in the wrong place. -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Thursday, January 21, 2010 12:52 PM To: cf-talk Subject: re: structFindValue I think you just want #myVar[1].Owner.Cost#

RE: FedEx web service

2010-01-20 Thread Chad Gray
I am switching to CFFedExRates like you recommended. http://code.google.com/p/cffedexrates/ Seems more stable to FedEx's changes. I just need to tweak it to do multiple boxes. -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Tuesday, January 19, 2010 7:17 PM To:

RE: FedEx web service

2010-01-20 Thread Chad Gray
Leigh, have you ever tried to do multiple boxes in this CFFedExRates CFC? I structured the package data like this. ns:RateRequestTypesLIST/ns:RateRequestTypes ns:PackageCount2/ns:PackageCount ns:PackageDetailINDIVIDUAL_PACKAGES/ns:PackageDetail ns:RequestedPackageLineItems

RE: FedEx web service

2010-01-20 Thread Chad Gray
ns:UnitsLB/ns:Units ns:Value25/ns:Value /ns:Weight /ns:RequestedPackageLineItems -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Wednesday, January 20, 2010 11:33 AM To: cf-talk Subject: RE: FedEx web service Leigh, have you ever tried

RE: FedEx web service

2010-01-20 Thread Chad Gray
Leigh, I have a customer that gets a discount on their FedEx shipping because of the quantity they ship. If a FedEx account that does not get a discount have this same structure that I am getting? I don’t want to put code up on the code.google.com if it is not accurate for all account types.

RE: FedEx web service

2010-01-20 Thread Chad Gray
the Standard Rate and not the client discounted rate. -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Wednesday, January 20, 2010 3:37 PM To: cf-talk Subject: RE: FedEx web service Leigh, I have a customer that gets a discount on their FedEx shipping because

FedEx web service

2010-01-19 Thread Chad Gray
Anyone else running into problems with the FedEx Rate service? Looks like it started yesterday. I am using code similar to this post: http://cfsearching.blogspot.com/2007/12/how-heck-do-you-use-fedex-rate-web.html I get this error back: Cannot perform web service invocation getRates. The

RE: FedEx web service

2010-01-19 Thread Chad Gray
Ha! Good one! -Original Message- From: Phillip Vector [mailto:vec...@mostdeadlygame.com] Sent: Tuesday, January 19, 2010 3:16 PM To: cf-talk Subject: Re: FedEx web service Haven't tried it. But if they did change it, it gives me a nice warm feeling that the person who hired me to

RE: Recent SQL Injection attacks

2010-01-13 Thread Chad Gray
How do you guys monitor these attacks? The webserver logs? -Original Message- From: Al Musella, DPM [mailto:muse...@virtualtrials.com] Sent: Wednesday, January 13, 2010 12:34 PM To: cf-talk Subject: Re: Recent SQL Injection attacks I have been getting a lot lately... and had

reorder a query

2010-01-12 Thread Chad Gray
I am thinking there has to be an easier way to do this then what I currently have. I need to move a row in a Query object up or down. Like imagine a page with little arrows on each record and you want record 2 to move to the position of record 1 and move record one to the position of record

RE: reorder a query

2010-01-12 Thread Chad Gray
. cfset QueryAddColumn(getColors, reOrder, integer, reOrderArray) cfquery dbtype=query name=newOrder SELECT ColorName FROM getColors ORDER BY reOrder /cfquery -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Tuesday, January 12, 2010 12:55 PM To: cf-talk Subject

RE: reorder a query

2010-01-12 Thread Chad Gray
Never mind... figured it out. I needed javaCast when setting the values of the Array. cfset reOrderArray[getColors.currentRow] = javaCast(int, variables.counter) -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Tuesday, January 12, 2010 1:35 PM To: cf-talk

RE: reorder a query

2010-01-12 Thread Chad Gray
You gave me some good ideas, but I don't have a column to write the sort order. I need to use the Auto increment primary key I should have mentioned that. Thanks though! Chad -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Tuesday, January 12,

RE: 500 Internal Server Error

2010-01-12 Thread Chad Gray
Sometimes when I use IE the robust exception message does not appear you just get a default IE 500 page. Switch to Firefox or dig into the CF logs to view the error. -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: Tuesday, January 12, 2010 3:44 PM To: cf-talk

RE: Problem deleting structure in an array

2010-01-12 Thread Chad Gray
My best guess is if you remove one item it changes the structure of the array and when it goes to remove the next one it cannot be found? Use CFDump to display the array as you are looping over it to help debug. This way you can see the way the array is changing as you are removing items.

form.FieldNames

2010-01-07 Thread Chad Gray
How is the order of the elements in #FORM.fieldNames# determined? Could it be different and not well structured? Like if I have a form with text inputs named foo1, foo2, foo3. Will #FORM.fieldNames# always be: Foo1,foo2,foo3? Or could it be ordered different? Thanks, Chad

RE: form.FieldNames

2010-01-07 Thread Chad Gray
on the server. This is especially true if you have some sort of non-HTML (or impure-HTML) interface, since any sort of dynamic scripting (e.g. JavaScript) can potentially mutate the actual form submission in an arbitrary way. cheers, barneyb On Thu, Jan 7, 2010 at 8:17 AM, Chad Gray cg

line-through in select tag

2010-01-04 Thread Chad Gray
Anyone know of a way to get a CSS line-through in an HTML select tag? I tried this but it does not work. select optionspan style=text-decoration:line-through;#dollarFormat(productData.Price)#/span/option /select ~| Want to

model glue xml file

2009-12-18 Thread Chad Gray
What keeps someone from loading up the model-glue XML file through their browser? How should you protect it? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing

Mach-II

2009-12-18 Thread Chad Gray
I am studying Model-Glue and MachII by reading the docs and presentations. Where are the controllers in MachII? Model-Glue has distinct controllers that tap into the models, I don't see where that happens in MachII. ~| Want

RE: Export to Excel Asian locale

2009-12-18 Thread Chad Gray
Does your OS that opens the excel file have the support for double byte characters? In windows I think it is under regions and languages. You should google support for double byte characters on your OS. I found this real quick: http://mandarin.about.com/od/characters/ss/display_chars.htm

deadlocks

2009-12-17 Thread Chad Gray
Hello, I have one page that loops over form variables analyzes the variables and with cfif statements makes decisions on whether to do a SQL update, delete or insert and I occasionally get SQL deadlocks. Transaction (Process ID 51) was deadlocked on lock | communication buffer resources with

RE: deadlocks

2009-12-17 Thread Chad Gray
, 2009 10:17 AM To: cf-talk Subject: Re: deadlocks On Thursday 17 Dec 2009, Chad Gray wrote: I have a feeling in need to optimize my data and not the CF code. Making it run faster will not stop you getting deadlocks (entangled pairs of conflicting transactions). It might reduce

copy from table to table

2009-12-15 Thread Chad Gray
Is there any easy way to take a row of data from one table and copy it to another? The tables have the exact same columns, they just have different table names. The tables have many columns so typing out each column in an insert query will be tedious. Any ideas would be appreciated! Chad

RE: copy from table to table

2009-12-15 Thread Chad Gray
That works great! How would I format a SCOPE_IDENTITY() around this type of query? I tried this and I don't get the ID back out. The SQL does not error but when I output #insertTicket.JobTicketID# CF says it is not defined. cfquery datasource=#application.dsn# name=insertTicket INSERT INTO

RE: copy from table to table

2009-12-15 Thread Chad Gray
and see what is going on. -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Tuesday, December 15, 2009 2:50 PM To: cf-talk Subject: RE: copy from table to table That works great! How would I format a SCOPE_IDENTITY() around this type of query? I tried

RE: copy from table to table

2009-12-15 Thread Chad Gray
Cool... that worked. I will read up on this NOCOUNT and output clause so I understand what is going on. Thanks again! Chad -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Tuesday, December 15, 2009 3:15 PM To: cf-talk Subject: RE: copy from table to table

scoping and speed

2009-12-10 Thread Chad Gray
If you don't scope your local variables does the page run slower? IE. #variables.foo# vs. #foo# ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive:

RE: Error consuming Fedex webservices

2009-12-03 Thread Chad Gray
Are there any integers that you need to use javacast() or objNonNegInteger()? Like on my code to get shipping rates I needed javacast and objNonNegInteger on this line: cfset data.requestedShipment.packageCount = objNonNegInteger.init(#JavaCast(string, listLen(attributes.PkgWeights))#) There

RE: Error consuming Fedex webservices

2009-12-03 Thread Chad Gray
Have you tried Float instead of string with javaCast() on those dates? -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Thursday, December 03, 2009 1:38 PM To: cf-talk Subject: Re: Error consuming Fedex webservices I have tried a number of things. But no

RE: CFStoredProc.StatusCode makes stored proc public

2009-11-24 Thread Chad Gray
Just a guess, but do you have to declare the stored procedure and result? cfset var foo = -Original Message- From: Dave Phelan [mailto:dphe...@lifepoint.com] Sent: Tuesday, November 24, 2009 12:57 PM To: cf-talk Subject: CFStoredProc.StatusCode makes stored proc public All,

application.cfc

2009-11-23 Thread Chad Gray
Is there any good way to have a function like this included in all pages? I can't put it in application.cfc. cfscript function MyDecimalFormat(some_value) { // call DecimalFormat to handle rounding, then strip out commas return Replace(DecimalFormat(some_value)ALL); }

RE: application.cfc

2009-11-23 Thread Chad Gray
it: #application.udfs.MyDecimalFormat(myNum)# You could also do something like 'variables.udfs = application.udfs;' in OnRequestStart() to make things less verbose when using your udfs, i.e. you could then do: #udfs.MyDecimalFormat(myNum)# HTH Dominic 2009/11/23 Chad Gray cg...@careyweb.com Is there any

cfc output=yes

2009-11-20 Thread Chad Gray
Are there any dangers I need to be aware of when setting a function in a CFC (it is stored in the application scope) to output=yes? I want the function to output some HTML when run. I can't think of any, but just wanted to check. Thanks, Chad

RE: cfc output=yes

2009-11-20 Thread Chad Gray
That's true I could use cfsavecontent. Would be cleaner to just return a variable. Thanks guys! -Original Message- From: b...@bradwood.com [mailto:b...@bradwood.com] Sent: Friday, November 20, 2009 10:47 AM To: cf-talk Subject: RE: cfc output=yes And I would suggest against

RE: CF8, Vista, SQL 2005

2009-11-19 Thread Chad Gray
SQL Express or full installation of SQL server? If I remember right with Vista, SQL Express and CF you have to change some setting in SQL server to allow a connection. The port is different and there is a TCP setting you have to change. You may want to look at your firewall also. Chad

RE: CF8, Vista, SQL 2005

2009-11-19 Thread Chad Gray
Just a guess, but maybe do some maintenance on the database. Try a shrink. Rebuild the indexs. Is the database from SQL 2005 or an earlier version? Sound like it is more on the CF end than the database through. Check the DSN setting in CFadministrator also. Remove it and add it back using

RE: CF8, Vista, SQL 2005

2009-11-19 Thread Chad Gray
Also try restarting the CF ODBC services. There are two of them in the services control panel. -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Thursday, November 19, 2009 5:04 PM To: cf-talk Subject: RE: CF8, Vista, SQL 2005 Just a guess, but maybe do

stored procedures

2009-11-18 Thread Chad Gray
I am trying to add a field to a stored procedure. I modified the stored proc in SQL Studio and executed it. It appears to have saved the changes. Now I added cfprocparam dbvarname=@PromoCode value=#session.promocode# cfsqltype=cf_sql_varchar to my CFStoredProc tag. I get the error Procedure

RE: stored procedures

2009-11-18 Thread Chad Gray
Never mind.. I was editing the wrong stored procedure. There was one on another table that was accessing the table I was working on. So basically there were two stored procs. One on table1 that was accessing table2. And one on table2 that was accessing table2. I changed both stored procs

RE: stored procedures

2009-11-18 Thread Chad Gray
By table1 and table2 I actually meant database1 and database2. Im on a roll today... -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Wednesday, November 18, 2009 12:36 PM To: cf-talk Subject: RE: stored procedures Never mind.. I was editing the wrong

kill cookie on browser close

2009-11-12 Thread Chad Gray
Anyone notice that in IE this codes does not appear to work anymore? Firefox it works just fine. I don't think it is just my browser... I have tried another computer with IE8 and it does not kill the session cookie. !--- if the user closes their browser, make sure all session variables get

RE: kill cookie on browser close

2009-11-12 Thread Chad Gray
Must be something on my end. The production server this code does not work in IE and the dev server it does work in IE. Strange. -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Thursday, November 12, 2009 11:40 AM To: cf-talk Subject: kill cookie on browser

RE: kill cookie on browser close

2009-11-12 Thread Chad Gray
on browser close Chad, Make sure you don't have any instances of IE open--including things that might use the IE underneath (like an RSS reader, etc.) -Dan On Thu, Nov 12, 2009 at 11:39 AM, Chad Gray cg...@careyweb.com wrote: Anyone notice that in IE this codes does not appear to work

modifying a query object

2009-10-07 Thread Chad Gray
So I am doing a query on a database and passing the query object to CFIndex to refresh a Verity collection. I need to remove some characters (HTML tags in the query result) from the query object before passing it to CFIndex. What is the best way to find/replace the HTML tags in the query

ssl

2009-10-02 Thread Chad Gray
I have some code in application.cfm that is supposed to re-direct the user to a non-ssl version of the page. !--- redirect to non-SSL --- cfif CGI.HTTPS eq on cfif Len(CGI.QUERY_STRING) cflocation url=http://www.#CGI.SERVER_NAME##CGI.PATH_INFO#?#CGI.QUERY_STRING#;

RE: ssl

2009-10-02 Thread Chad Gray
on that site if you don't want people going to it. If you want to accomplish the redirect below without a warning, you'll have to install a valid certificate. Dave -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Friday, October 02, 2009 1:43 PM To: cf-talk

RE: ssl

2009-10-02 Thread Chad Gray
= 'cfoutputhttp://www.#CGI.SERVER_NAME##CGI.PATH_INFO#/cfoutput';/scrip t cfabort /cfif /cfif Maybe Firefox is trying to protect a user from hitting an SSL page that has been hijacked somehow Dave -Original Message- From: Chad Gray [mailto:cg...@careyweb.com

RE: ssl

2009-10-02 Thread Chad Gray
OH.. hang on it only errors in firefox. I tried IE and the certificate and my original code work fine (after I remove the www.) CGI.ServerName does include www. (DUH!). Now I just have to figure out why the SSL cert does not work in FireFox. -Original Message- From: Chad Gray

RE: ssl

2009-10-02 Thread Chad Gray
Thanks Dave, it ends up FireFox is not compatible with this GoDaddy class 2 certificate for some reason. I guess firefox does not have the CA chain in it. Thanks for the help! -Original Message- From: Dave Phillips [mailto:experiencedcfdevelo...@gmail.com] Sent: Friday, October

white space

2009-09-21 Thread Chad Gray
Can white space in CFM pages hurt SEO? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive:

sql deadlock

2009-08-27 Thread Chad Gray
I occasionally see this error in an application I wrote. Transaction (Process ID 54) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. The code that is causing this is below. cfloop

cfhttp time limit

2009-08-24 Thread Chad Gray
I got this error back from an application. The request has exceeded the allowable time limit Tag: cfhttp Where do you set the time limit for CFHTTP? ~| Want to reach the ColdFusion community with something they want? Let them

OT javascript

2009-07-30 Thread Chad Gray
Say I have two select inputs on one page and they are named the same. select name=ID option value=Please Select/option option value=11/option /select select name=ID option value=Please Select/option option value=11/option /select I want to write javascript to check that both of these are not

RE: OT javascript

2009-07-30 Thread Chad Gray
Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com On 7/30/2009 10:19 AM, Chad Gray wrote: Say I have two select inputs on one page

verity search

2009-07-22 Thread Chad Gray
Is verity case sensitive on a search? I type in Test and test and get different results. Is there a way to make it not case sensitive? ~| Want to reach the ColdFusion community with something they want? Let them know on the

cfmodule

2009-07-15 Thread Chad Gray
Inside of a CFM file that is called via CFModule. How do you scope the variables in the CFM files that is passed in via CFModule? I tried attributes.foo and it did not like that. Thanks! Chad ~| Want to reach the ColdFusion

RE: cfmodule

2009-07-15 Thread Chad Gray
Nevermind.. I had a typo! It is attributes. DOH! -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Wednesday, July 15, 2009 2:01 PM To: cf-talk Subject: cfmodule Inside of a CFM file that is called via CFModule. How do you scope the variables in the CFM

fedex rates

2009-06-30 Thread Chad Gray
I am using some code I got from this web site (not sure who the author is) to tap into FedEx's rate API. http://cfsearching.blogspot.com/2007/12/how-heck-do-you-use-fedex-rate-web.html If I try to put a CF variable in the second line below it errors out. If I put a 1 or 2 in there

RE: fedex rates

2009-06-30 Thread Chad Gray
DOH... needed JavaCast(). Nevermind. -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Tuesday, June 30, 2009 4:40 PM To: cf-talk Subject: fedex rates I am using some code I got from this web site (not sure who the author is) to tap into FedEx's rate API

webservice

2009-06-26 Thread Chad Gray
When you hook up a web service in CF Admin how do you access it in your CFM pages? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive:

fedex web service

2009-06-26 Thread Chad Gray
Well the only way I have found to communicate with the FedEx rate service is to HTTP post XML to it. It returns the following XML below. How do I grab the data I need out of it? Say I want to grab the XmlText of v6:Severity... how do I get the word SUCCESS? So far what I have tried does

RE: fedex web service

2009-06-26 Thread Chad Gray
Thanks! Here is final code that worked. I have never seen it formatted like that [][][]... Is this to kind of 'escape' the colons? cfset IsSuccess = reply[soapenv:Envelope][soapenv:Body][v6:RateReply][v6:Notifications][v6:Severity][XMLText] -Original Message- From: Casey

RE: fedex web service

2009-06-26 Thread Chad Gray
If you hit their web service there is no WSDL... they give you a static WSDL file with the development docs, but the web service itself does not publish a WSDL. So I can't hit is straight up with CFInvoke. I have to pass it a chunk of XML and go the SOAP route. At least I have not found a

FedEx Rates

2009-06-25 Thread Chad Gray
I am having a hard time finding example code for FedEx rate web service. They have example code on their web site for everything but CF. I checked RIAForge and could not find a project. Anyone have example code? I am reading through the docs and I cant even find the URL to hit the web

email and encrypt

2009-06-16 Thread Chad Gray
I have a program that emails a user a link to verify their email. So I thought I would take their email and use encrypt to mask it. Then decrypt it to verify the email against the database. So I wrote this and put it in the email so they could click on it: a

RE: email and encrypt

2009-06-16 Thread Chad Gray
Well yes, but I wanted a long complex variable that someone would not be able to just guess an ID and validate the account. Someone could put ID=5 in there and validate someone else's account. Maybe I should use CreateUUID() store that in the database and send it in the URL in the email?

RE: email and encrypt

2009-06-16 Thread Chad Gray
Now the email is in HTML format and I putting a hyperlink in it. a href=long urlClick to Validate/a Shouldn't this work? I still don't get why this would get chopped if they clicked on the link. -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Tuesday, June

scoping

2009-06-15 Thread Chad Gray
Say you defined a local variable like this on a CFM page and it returns a query object: cfset foo = application.foo.moo() Should I write out my variables like this when I out the query object? #variables.foo.goo# Or is this sufficient? #foo.goo#

RE: mysql and order by datetime

2009-06-11 Thread Chad Gray
Here you go Alan. DROP TABLE IF EXISTS `profilepicts`; CREATE TABLE `profilepicts` ( `ProfilePictsID` int(10) NOT NULL auto_increment, `ProfileID` int(10) default NULL, `ProfileScrapbookID` int(10) default NULL, `ImageName` varchar(255) default NULL, `Title` varchar(255) default NULL,

OT legal stuff

2009-06-11 Thread Chad Gray
Does anyone know how it is best legally to record that a user clicked the check box I agree to the terms and privacy policy of this web site? Is it sufficient to just mark a field in a database and record the date time? Or is there a more official way of recording that they agreed to the

mysql and order by datetime

2009-06-10 Thread Chad Gray
This is strange. I run this query and I get proper results (DateAdded is a DateTime data type): SELECT PP.ProfileID FROM profilepicts PP WHERE PP.Live = 1 ORDER BY PP.DateAdded DESC RESULTS: 3 2 2 2 1 5 3 6 I add a distinct and I get SELECT DISTINCT(PP.ProfileID) FROM profilepicts PP WHERE

RE: mysql and order by datetime

2009-06-10 Thread Chad Gray
name=profiles SELECT ProfileID FROM profiles GROUP BY ProfileID ORDER BY DateAdded DESC /cfquery RESULT: 3 2 1 5 6 -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Wednesday, June 10, 2009 5:13 PM To: cf-talk Subject: mysql and order by datetime

pagination of record

2009-06-09 Thread Chad Gray
Ok this is kind of a different pagination they have tried before. I have a page that displays an image. I need to paginate from image 1 - 3 in a dataset. So say I go get all the images and I have a query that comes back with PhotoID 2,14,15. Currently the image being viewed it PhotoID 14.

cffile and illegal names

2009-06-08 Thread Chad Gray
Is there any way to rename files that are uploaded with CFFile? A person with a mac uploaded a file with a colon in it and the Windows CF server can write it. ~| Want to reach the ColdFusion community with something they

RE: cffile and illegal names

2009-06-08 Thread Chad Gray
Nevermind... I didn't realize you could put your own file name in the destination attribute. I thought it would only take the path to save the image. So I used createUUID() to make the file name at the end of the folder path. -Original Message- From: Chad Gray [mailto:cg

reducing a query result

2009-06-04 Thread Chad Gray
Say I have a query returned with 500 records. Is there a way in CF (not SQL) to reduce the query to only rows 1-50, 51-100 etc? I talking physically reducing the query object. ~| Want to reach the ColdFusion community with

RE: reducing a query result

2009-06-04 Thread Chad Gray
the query using the same query variable name. Adrian -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: 04 June 2009 16:07 To: cf-talk Subject: reducing a query result Say I have a query returned with 500 records. Is there a way in CF (not SQL

RE: reducing a query result

2009-06-04 Thread Chad Gray
Ya it was a pagination thing, but I thought of a better solution using CSS and a better query. I posted before I thoroughly thought it out. Thanks though! -Original Message- From: Alan Rother [mailto:alan.rot...@gmail.com] Sent: Thursday, June 04, 2009 11:17 AM To: cf-talk

captcha

2009-06-02 Thread Chad Gray
Anyone have recommendations for CAPTCHA? I know about CFImage's captcha, but what other programming can be used to figure out if the submission was done by a human? I thought about timing the form page load and time to submission. If it took a user less than 5 seconds to fill out the form

CFformprotect

2009-06-02 Thread Chad Gray
Not sure if the developer of CFFormProtect monitors this list, I could not find an email. Maybe someone else can answer my question. Can CFFormProtect use the mail server setup in CFAdmin instead of having to specify mail server settings in the cffp.ini.cfm? I tried leaving emailServer

query question

2009-05-29 Thread Chad Gray
I have two tables that are joined one to many. I would like to write a query to get the one from the first table and only one from the many table. TABLE1 AlbumID, AlbumTitle 1, MyPictures TABLE2 PictureID, AlbumID, PictureName 1, 1, test.jpg 2, 1, test2.jpg How do I write the query to

RE: query question

2009-05-29 Thread Chad Gray
Sorry should have mentioned that MySQL -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Friday, May 29, 2009 10:48 AM To: cf-talk Subject: Re: query question what db -- Ryan On Fri, May 29, 2009 at 9:41 AM, Chad Gray cg...@careyweb.com wrote: I have two

<    1   2   3   4   5   6   7   8   9   >