RE: cfinsert multiple records into DB

2010-02-11 Thread Chad Gray
Whoops, I noticed a bug in my code. You should use FORM.player not FORM.contactid in the two CFQuery's since the name of the select is "player". -Original Message----- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Thursday, February 11, 2010 11:11 AM To: cf-t

RE: cfinsert multiple records into DB

2010-02-11 Thread Chad Gray
First the CFinsert should be avoided, it limits you. Writing your own SQL is easy. I would replace the value of the option in the player select with the ID not the First and Last name. You can delete your second select since the ID represents the First and Last name. #contacts.FirstName

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: cf-ta

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 A

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? Than

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 wrote: >

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: 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... var foo = "bar"; ? But yes, you still

var scoping cfscript in a CFC

2010-02-01 Thread Chad Gray
When putting cfscript in a CFC function do you need to use 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 Fusion mailing l

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

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 resource

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 CF8

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; ~

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 funct

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

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: 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#

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: FedEx web service

2010-01-20 Thread Chad Gray
ectiveNetDiscount to get 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 Fe

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
100 LB 50 2 USD 100 LB 25 -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Wednesday, January 20,

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. LIST 2 INDIVIDUAL_PACKAGES 1 USD 100 LB 50 2

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: cf-

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 do

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 fa

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...

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. >

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-t

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, 2

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. > -Original Message- > From: Chad Gray [mailto:cg...@careyweb.com] > Sent: Tuesday, January 12, 2010 1:35 PM > To: cf-talk > Subject: RE: reorder a query > > > While I

RE: reorder a query

2010-01-12 Thread Chad Gray
. SELECT ColorName FROM getColors ORDER BY reOrder > -Original Message- > From: Chad Gray [mailto:cg...@careyweb.com] > Sent: Tuesday, January 12, 2010 12:55 PM > To: cf-talk > Subject: reorder a query > > > I am thinking there has to be an easier wa

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 2

RE: form.FieldNames

2010-01-07 Thread Chad Gray
orm > > submission in an arbitrary way. > > > > cheers, > > barneyb > > > > On Thu, Jan 7, 2010 at 8:17 AM, Chad Gray wrote: > > > > > > How is the order of the elements in #FORM.fieldNames# determined? > Could > > it be different and

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

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. #dollarFormat(productData.Price)# ~| Want to reach the ColdFusion community with something they want? Let them know on

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 >

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 t

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 lis

RE: deadlocks

2009-12-17 Thread Chad Gray
ursday, December 17, 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 pa

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 a

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 tabl

RE: copy from table to table

2009-12-15 Thread Chad Gray
Hmmm there is something funky going on. Even if I do this CF say "Element JOBTICKETID is undefined in GETJOBTICKETID." SELECT MAX(JobTicketID) FROM JobTicket #getJobTicketID.JobTicketID# I will poke around and see what is going on. > -Original Message- >

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. INSERT INTO JobTicket (JobNum, DateCreated) SELECT JobNum, #NOW()#

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 ~

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: h

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. Bu

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: There is a good blog post on using the WSDL locally instead of using CFInvoke that got me going in the right direction: htt

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? > -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, > > I h

RE: application.cfc

2009-11-23 Thread Chad Gray
pplication.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 > > Is there any good way to have a function like this included in all pages? > I can't put

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. function MyDecimalFormat(some_value) { // call DecimalFormat to handle rounding, then strip out commas return Replace(DecimalFormat(some_value),",","","ALL"); } ~

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

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: 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 > >

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
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: 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

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 and

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 to my CFStoredProc tag. I get the error "Procedure or function I_Orders has too many arguments specified." Did I not edit the st

RE: kill cookie on browser close

2009-11-12 Thread Chad Gray
kill cookie 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 wrote: > > >

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 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. ~~~

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 objec

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

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

RE: ssl

2009-10-02 Thread Chad Gray
I tried this code and it takes me to http://www.www.beeculture.com/ www. Should not be part of CGI.ServerName right? > -Original Message- > From: Dave Phillips [mailto:experiencedcfdevelo...@gmail.com] > Sent: Friday, October 02, 2009 3:16 PM > To: cf-talk > Subject: RE: ssl > > > Ho

RE: ssl

2009-10-02 Thread Chad Gray
u > probably need to do is turn off the SSL 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- >

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. http://www.#CGI.SERVER_NAME##CGI.PATH_INFO#?#CGI.QUERY_STRING#"; addtoken="no"> http://www.#CGI.SERVER_NAME##CGI.PATH_INFO#"; addtoke

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: http://www.houseoffusion.com/groups/cf-talk/message.cfm/m

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. DELETE

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

RE: OT javascript

2009-07-30 Thread Chad Gray
t; > Steve "Cutter" Blades > Adobe Certified Professional > Advanced Macromedia ColdFusion MX 7 Developer > > Co-Author of "Learning Ext JS" > http://www.packtpub.com/learning-ext-js/book > _____ > http://blog.cutterscrossin

OT javascript

2009-07-30 Thread Chad Gray
Say I have two select inputs on one page and they are named the same. Please Select 1 Please Select 1 I want to write javascript to check that both of these are not left blank or in their default stage of "Please Select". Can I do this in javascript ID[0] to get the value of the first one?

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 H

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

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: 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 i

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 statically

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 w

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? > -Original Message- > From: Casey Dougall [mailto:ca...@uberwebsitesolutions.com] > Sent: Friday, June 26, 2009 3:11 PM > To: cf-talk > Subj

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 ... how do I get the word "SUCCESS"? So far what I have tried does not like t

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: http://www.hou

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 service

RE: email and encrypt

2009-06-16 Thread Chad Gray
Now the email is in HTML format and I putting a hyperlink in it. Click to Validate 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,

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? Woul

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: I am getting some errors where som

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: Should I write out my variables like this when I out the query object? #variables.foo.goo# Or is this sufficient? #foo.goo# ~| Want

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 ter

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,

RE: mysql and order by datetime

2009-06-10 Thread Chad Gray
FROM profiles GROUP BY ProfileID ORDER BY DateAdded DESC 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 > > > This is strange. I

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 PP

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. I

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

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 want

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 > Su

RE: reducing a query result

2009-06-04 Thread Chad Gray
a query result > > > Query 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 > > &

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 so

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 blan

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 the

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 wrote: > > I have two tables th

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 onl

<    1   2   3   4   5   6   7   8   9   >