cfsqltype for date and time

2009-05-28 Thread Chad Gray
Hello, What cfsqltype in a cfqueryparam should I use to insert now() into a mySql database (datetime data type) so it keeps the date and time? cf_sql_timestamp and cf_sql_date only seem to hold the date, not the time when I insert.

billing

2009-05-04 Thread Chad Gray
Does anyone give price breaks for quantity of hours in a project? Usually I quote jobs, but this latest one they just said go do it and we have racked up 400+ hours and I think they are going to freak out when they see the bill. We have worked with the company many times in the past so I feel

RE: billing

2009-05-04 Thread Chad Gray
Thanks for all the feedback. The original site was a $20k project in 2002. Now this redesign which is more complex is hitting the $40k range. I went back and looked closer at all the billing we have done in the past ( I was not in charge at that time of billing ) and I feel this new price

letting a graphic artist change pages

2009-04-27 Thread Chad Gray
What is the best way of going about letting a graphic artist (who does not know CF) edit the pages so they render the way they want them too. I have done the core programming on a web site and they want to tweak the graphics that surround the CF programming so it looks better.

RE: letting a graphic artist change pages

2009-04-27 Thread Chad Gray
it. This approach perhaps involves a little extra work but does keep things clean (and keeps non-coders out of the code). Dominic 2009/4/27 Chad Gray cg...@careyweb.com: What is the best way of going about letting a graphic artist (who does not know CF) edit the pages so they render the way

RE: letting a graphic artist change pages

2009-04-27 Thread Chad Gray
a graphic artist change pages Are stylesheets being used for the site? Rick On Mon, Apr 27, 2009 at 4:02 PM, Chad Gray cg...@careyweb.com wrote: What is the best way of going about letting a graphic artist (who does not know CF) edit the pages so they render the way they want them too

mail log

2009-04-20 Thread Chad Gray
Is there any log in CF8 that will tell me if CFMail sent an email? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f

RE: mail log

2009-04-20 Thread Chad Gray
:P I only see failures in there. Does it log attempts? Or trys? -Original Message- From: Tom Chiverton [mailto:tom.chiver...@halliwells.com] Sent: Monday, April 20, 2009 8:38 AM To: cf-talk Subject: Re: mail log On Monday 20 Apr 2009, Chad Gray wrote: Is there any log

application.cfc

2009-04-20 Thread Chad Gray
Is it safe to put this code in the onError function? FORM Variablesbr / cfif isdefined(FORM.FieldNames)cfdump var=#FORM#/cfif SESSION Variablesbr cfif isdefined(session)cfdump var=#session#/cfif ~| Adobe® ColdFusion® 8

decrypt

2009-04-18 Thread Chad Gray
Hello, I need to decrypt a hash. Can I do this in CF? I am trying to get a PHP application that stores some information as an MD5 hash to work with a CF application. So want to decrypt it and use it in my CF application. This web site can decrypt it, but the CF decrypt() function needs a

dynamic form and converting list of form variables

2009-04-17 Thread Chad Gray
I have a form that has a bunch of checkbox fields that are dynamically created from a database. I need to take the fields selected and evaluate them and convert them to a list that I can use in a SQL query. Here is what is coming in to the action page:

RE: dynamic form and converting list of form variables

2009-04-17 Thread Chad Gray
-talk Subject: Re: dynamic form and converting list of form variables On Fri, Apr 17, 2009 at 9:57 AM, Chad Gray cg...@careyweb.com wrote: I have a form that has a bunch of checkbox fields that are dynamically created from a database. I need to take the fields selected and evaluate them

multiple cfapplications

2009-04-17 Thread Chad Gray
If I have many cfapplication.cfm files on a web site in different folders how do they work together? Say I have application.cfm on the root of the web site with an application name foo. Then in a user folder I have an application.cfm page and it's application name is also foo. How do they

RE: multiple cfapplications

2009-04-17 Thread Chad Gray
Ok.. makes sense. What happens if someone has a bookmark to a sub folder users that has its application.cfm page with the same application name as the Root application.cfm file. Does the root application.cfm fire at all? Like if I have session.foo or application.foo defined in the Root

RE: multiple cfapplications

2009-04-17 Thread Chad Gray
Some sections (folders) of the web site we use an application.cfm and store user login logic in it. So the application.cfm file fires first and if the user is not logged in then displays a login page. -Original Message- From: Ben Nadel [mailto:b...@bennadel.com] Sent: Friday,

RE: Question about hack

2009-04-10 Thread Chad Gray
One thing I will add is if you are using CFFile to do the upload use it's accept attribute to only except the mime types you want to upload. If it errors capture it and output a nice error message. It is not full proof, but another layer in making file upload more safe.

how to handle in-appropriate image uploads

2009-04-09 Thread Chad Gray
Hello, How do big web sites like myspace police image uploads? It seems like they let users report abuse then take action. Is there any other way? I really don't want an approval system where an admin user has to approve an image before it is displayed.

RE:_Simple_text_to_image?

2009-04-02 Thread Chad Gray
This is not CF8, but we love using Efflare's gFont CFX. Works great for things like barcodes if you have the font. Efflare.com -Original Message- From: Don L [mailto:do...@yahoo.com] Sent: Thursday, April 02, 2009 12:25 PM To: cf-talk Subject: Simple text to image? Sorry

captcha

2009-03-29 Thread Chad Gray
I loaded up the example code on the live docs web site and I sometimes get the below error. http://livedocs.adobe.com/coldfusion/8/htmldocs/Images_21.html What is the best way to make sure the image is big enough for the text? An invalid argument has caused this error. Verify your inputs.

html in database

2009-03-25 Thread Chad Gray
I am doing a CMS type system and letting users edit pages with FCKeditor then storing the page HTML into a database field. I would like to make the menu system database drive and not statically created in FCKeditor. The menu system is inside of the area that FCKeditor is making. How do I

RE: html in database

2009-03-25 Thread Chad Gray
So save it as a file with cffile then cfinclude it? -Original Message- From: Tom Chiverton [mailto:tom.chiver...@halliwells.com] Sent: Wednesday, March 25, 2009 11:33 AM To: cf-talk Subject: Re: html in database On Wednesday 25 Mar 2009, Chad Gray wrote: How do I insert

MySQL and CF LAST_INSERT_ID()

2009-03-17 Thread Chad Gray
I am trying to use the MySQL function LAST_INSERT_ID() in a CFquery tag and get this error. Error Executing Database Query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; SELECT LAST_INSERT_ID() AS

RE: MySQL and CF LAST_INSERT_ID()

2009-03-17 Thread Chad Gray
Sabai-dee.com http://www.sabai-dee.com/ Chad Gray wrote: I am trying to use the MySQL function LAST_INSERT_ID() in a CFquery tag and get this error. Error Executing Database Query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version

verify form submission

2009-03-17 Thread Chad Gray
What is the best way to verify that data coming into an action page is from your form? I have a form that uses javascript to make sure they filled out the form right. Email, user name, password etc. How do I prevent someone from using their own form to submit to my action page and

true false

2009-03-08 Thread Chad Gray
Isnt there a CF function that takes a 1 or 0 and converts it to display True or False? Or am I dreaming? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial

RE: true false

2009-03-08 Thread Chad Gray
in for true and false. cheers, barneyb On 3/8/09, Chad Gray cg...@careyweb.com wrote: Isnt there a CF function that takes a 1 or 0 and converts it to display True or False? Or am I dreaming? ~| Adobe

cffile in a CFC

2009-03-07 Thread Chad Gray
I have a user submitting an image via a form. I would like to make a function in my cfc to upload the file. What do I put in the fileField attribute of CFFile? Arguments.TitleImage or Form.TitleImage? What type do I set for the cfargument? String? Binary? cffunction

RE: displaying a tree structure

2009-03-04 Thread Chad Gray
- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Tuesday, March 03, 2009 8:05 PM To: cf-talk Subject: displaying a tree structure I have data in a table like this: IDParentIDName 1 0 Top 2 1 Level1 3 1 Level2 4

RE: displaying a tree structure

2009-03-04 Thread Chad Gray
Oh... interesting. Would be nice to do it in SQL. I will study this. Thanks Donnie! -Original Message- From: Donnie Carvajal [mailto:donnie.carva...@transformyx.com] Sent: Wednesday, March 04, 2009 9:52 AM To: cf-talk Subject: Re: displaying a tree structure I have data in

order query object

2009-03-03 Thread Chad Gray
Say I have a CFC that returns a query object. When I go to output the data can I sort the query object on the display page? This way I don't have to have an ORDER BY in the SQL in the CFC. I could do the order by or sort when I go to display the query results instead. Thanks, Chad

RE: order query object

2009-03-03 Thread Chad Gray
[mailto:charlie.grie...@gmail.com] Sent: Tuesday, March 03, 2009 4:19 PM To: cf-talk Subject: Re: order query object On Tue, Mar 3, 2009 at 1:10 PM, Chad Gray cg...@careyweb.com wrote: Say I have a CFC that returns a query object. When I go to output the data can I sort the query

displaying a tree structure

2009-03-03 Thread Chad Gray
I have data in a table like this: ID ParentIDName 1 0 Top 2 1 Level1 3 1 Level2 4 2 Child1 Of Level2 5 2 Child2 Of Level2 6 3 Child1 Of Level2 So the tree would

cf tags in query

2009-03-02 Thread Chad Gray
Is it possible to have CF tags in a database record and have them run on the page? For example, I enter cfmodule into a database record. When I output that database record on the CF page can I get cfmodule to run on the page? My goal is to have someone upload HTML/CFM code into a database

stock market indexs

2009-01-30 Thread Chad Gray
Anyone know of a CF based app that pulls the current stock market indexes? I can't seem to find anything on cflib or riaforge. Thanks! Chad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to

join two databases

2009-01-16 Thread Chad Gray
What is the best way to join tables across two databases servers? Say I have one MS SQL server that has a database that stores ERP product data. I have our website MS SQL server that stores extra data about the product records in the ERP database. Is it possible to hook each datasource up in

RE: join two databases

2009-01-16 Thread Chad Gray
Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Friday, January 16, 2009 10:05 AM To: cf-talk Subject: join two databases What is the best way to join tables across two databases servers? Say I have one MS SQL server that has a database that stores ERP product data. I have our

RE: join two databases

2009-01-16 Thread Chad Gray
, if needed. With the server linked in SQL, you can create cross-server queries in the Query Analyzer/New Query editor. mike -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Friday, January 16, 2009 8:05 AM To: cf-talk Subject: join two databases What

cf and asterisk voip

2009-01-12 Thread Chad Gray
Has anyone tried tapping into Asterisk with CF? I would like to look at building a manager interface or a page that at least displays what phone lines are being used or not used. Any code tips or examples would be appreciated. Thanks!

RE: cf and asterisk voip

2009-01-12 Thread Chad Gray
to asterisk. I think AGI works all through pipes, so that will be hard to do with CF. I think you'll need to reach down into Java to do it. -Ryan Chad Gray wrote: Has anyone tried tapping into Asterisk with CF? I would like to look at building a manager interface or a page that at least

verity

2008-12-23 Thread Chad Gray
I have run into problems with a verity collection that use to work fine and now it does not. I have tried repairing and optimizing it, but get this error: CFSearchTagException: Error # -40 Error # -40 Error E1-0114 (Query Builder): Error parsing query: PREtest/PRE.. I googled this error, but

RE: verity

2008-12-23 Thread Chad Gray
does now work. -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Tuesday, December 23, 2008 3:48 PM To: cf-talk Subject: verity I have run into problems with a verity collection that use to work fine and now it does not. I have tried repairing and optimizing

Site-wide Error Handler

2008-11-19 Thread Chad Gray
In the CFAdmin it says to put the relative path to the template. Where do I put the file and how to I format the path? I have tried many combinations and it keeps saying it cannot find the file. We use IIS if this helps. Chad

RE: Site-wide Error Handler

2008-11-19 Thread Chad Gray
even if I do http://localhost/errors/404.cfm i get IIS's 404 page. Shouldn't the mapping deliver the 404.cfm page? -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2008 3:06 PM To: cf-talk Subject: Re: Site-wide Error Handler Chad Gray

RE: Site-wide Error Handler

2008-11-19 Thread Chad Gray
Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2008 3:55 PM To: cf-talk Subject: RE: Site-wide Error Handler Hmm ya I made a mapping to a folder called errors and put my 404 page and error page in it. Then I used /errors/404.cfm in the cfadmin and it says

application.cfc error

2008-11-17 Thread Chad Gray
I don't understand what is happening. Anyone see something in my application.cfc that would cause this error? I can get rid of the error by reinitialing the application. I get this error every once in a while. It is like the application is not re-initialzing right and my application

RE: application.cfc error

2008-11-17 Thread Chad Gray
Are you sure your not clearing the cart outside of your application.cfc? -e On Mon, Nov 17, 2008 at 12:19 PM, Chad Gray [EMAIL PROTECTED] wrote: I don't understand what is happening. Anyone see something in my application.cfc that would cause this error? I can get rid

RE: application.cfc error

2008-11-17 Thread Chad Gray
-talk Subject: RE: application.cfc error Could it be that the application is timing out? What sort of traffic does the site get? What is your application timeout set to? -- Josh -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2008 9:20 AM

RE: application.cfc error

2008-11-17 Thread Chad Gray
Seems like kind of a hack eh'? It probably would work though. -Original Message- From: Alan Rother [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2008 1:20 PM To: cf-talk Subject: Re: application.cfc error Off hand I'm not sure what is causing it, but this may help

RE: application.cfc error

2008-11-17 Thread Chad Gray
Hmmm you know I did realize that there was another web site using the same application name. Could this cause my problems? -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2008 1:41 PM To: cf-talk Subject: RE: application.cfc error

RE: application.cfc error

2008-11-17 Thread Chad Gray
, but not all of my applications variables are defined for testSite2. This is where I am getting my error! -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2008 1:42 PM To: cf-talk Subject: RE: application.cfc error Hmmm you know I did realize

RE: strip alpha char

2008-11-07 Thread Chad Gray
Ah... REReplace... I only knew of REFind... THANKS! -Original Message- From: Matt Quackenbush [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2008 11:50 AM To: cf-talk Subject: Re: strip alpha char Ops, I did that backwards... reReplace(myString, [\D], , all) On

strip alpha char

2008-11-07 Thread Chad Gray
I have a list of file names and I only want the numbers in the file names. I don't want any alpha characters. I can use RE to find the numbers, but it get complicated to find the starting position of the number and the ending of the numbers then using the mid function to get the number. Is

insert error

2008-11-01 Thread Chad Gray
What is up with this? How can an insert fail with this error? [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot insert the value NULL into column 'PageID', table 'SocialCards4You.dbo.Pages'; column does not allow nulls. INSERT fails. PageID is an autoincrementing column in my MS SQL

RE: insert error

2008-11-01 Thread Chad Gray
Follow up... updates works, selects work. I don’t know why the insert is failing. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Saturday, November 01, 2008 11:42 AM To: cf-talk Subject: insert error What is up with this? How can an insert fail

RE: insert error

2008-11-01 Thread Chad Gray
AH I exported the table and re-imported it and the identity switch got changed to No. Now it works. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Saturday, November 01, 2008 11:50 AM To: cf-talk Subject: RE: insert error Follow up... updates works

RE: detecting mobiles

2008-10-31 Thread Chad Gray
Alistapart.com is nice! I never knew about it. Thanks Tom! -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Friday, October 31, 2008 5:44 AM To: cf-talk Subject: Re: detecting mobiles On Thursday 30 Oct 2008, Dawson, Michael wrote: One solution is to

detecting mobiles

2008-10-30 Thread Chad Gray
Hello, What is the best way to detect mobile phones so I can send them to a version of the web site that is more compatible with the mobile device browsers? #CGI.HTTP_USER_AGENT# Does display blackberry when I test with my phone, but is this reliable? I wonder what the iPhone and other

application.cfc and session structure

2008-10-23 Thread Chad Gray
What is the safest way to dump the session variables in the onError function of Application.cfc? Thanks Chad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial

RE: application.cfc and session structure

2008-10-23 Thread Chad Gray
On Thu, Oct 23, 2008 at 9:27 AM, Chad Gray [EMAIL PROTECTED] wrote: What is the safest way to dump the session variables in the onError function of Application.cfc? Thanks Chad ~| Adobe® ColdFusion® 8

help with webservice

2008-10-06 Thread Chad Gray
I would like to experiment with communicating with this SOAP web service. I have never done this before and need some help understanding how to communicate with it. http://acs.tikitag.com/tikitag-soap/applicationManagement?WSDL I don't understand how the web service works. I added it to my

mail

2008-09-08 Thread Chad Gray
Hello, I am using CFMail to send an email and if one of the email addresses in the TO attribute does not exists then no one in the TO attribute gets the email. It sits in the undelivered folder. Error,scheduler-5,09/08/08,10:17:32,,Invalid Addresses; nested exception is: class

form collection

2008-09-05 Thread Chad Gray
Hello, I am using argumentCollection=form to dump all of the form fields into a CFC. I would like to add to the form collection one more variable called Alias. I tried this but the variable FORM.Alias does not appear to actually be in the collection. cfset FORM.Alias =

RE: form collection

2008-09-05 Thread Chad Gray
- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2008 2:33 PM To: CF-Talk Subject: Re: form collection On Fri, Sep 5, 2008 at 11:20 AM, Chad Gray [EMAIL PROTECTED] wrote: Hello, I am using argumentCollection=form to dump all of the form fields into a CFC

RE: form collection

2008-09-05 Thread Chad Gray
Hmm never mind. I had an error in my code that made me think Alias was not being added to the collection. It appears to work now that I found my real bug. Chad -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2008 2:37 PM To: CF-Talk

ses and application.cfc

2008-09-04 Thread Chad Gray
I found this script on Ray Camden's blog for doing SES but it wont work if placed in Application.cfc. How should I use this script when using Application.cfc? I really don't want to put it on the top of each page. I would prefer to use it in the Application.cfc file. cfscript function

RE: ses and application.cfc

2008-09-04 Thread Chad Gray
- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2008 10:00 AM To: CF-Talk Subject: Re: ses and application.cfc On Thursday 04 Sep 2008, Chad Gray wrote: How should I use this script when using Application.cfc? onRequestStart() -- Tom Chiverton

datasource funkyness

2008-09-04 Thread Chad Gray
This was a weird one. I setup a MS SQL database and forgot to fill in database under the CF admin. I submitted it and it said it was OK. I thought, OK my database is hooked up, but in my code I kept getting these strange errors basically saying the table you are trying to query is not a

list and ListContainsNoCase

2008-08-06 Thread Chad Gray
Why is this happening? I don't want to display the variable ColorName if it has a value of something in my list dontShowList. If colorname is BLACK, 4, Process etc it does not show them. It should show because BLACK is not in my list. BLACK/WHITE is in my list, but not BLACK. It is like

RE: list and ListContainsNoCase

2008-08-06 Thread Chad Gray
will check for an exact match on list items, ListContains checks if the string exists at all in any list element (thus, Black matches Black/White). On Wed, Aug 6, 2008 at 1:24 PM, Chad Gray [EMAIL PROTECTED] wrote: Why is this happening? I don't want to display the variable ColorName

RE: list and ListContainsNoCase

2008-08-06 Thread Chad Gray
of the first list element that contains a specified substring. ListFind: Determines the index of the first list element in which a specified value occurs. On Wed, Aug 6, 2008 at 11:36 AM, Chad Gray [EMAIL PROTECTED] wrote: Thanks everyone! I did not know this. That should be added

paypal cart

2008-07-29 Thread Chad Gray
Hello, I have run into a situation where PayPals add to cart buttons are not going to work for me. So I am looking for ideas on how to accomplish this. The item I am trying to sell is a business card. So I want the user to fill out Name, Email, Phone etc then add the item to their cart.

RE: paypal cart

2008-07-29 Thread Chad Gray
and passed it in the the string to get around limitations but I think your problem is the buttons do not post any data back to your cart that is why you should use PayPal IPN Eric On Tue, Jul 29, 2008 at 10:19 AM, Chad Gray [EMAIL PROTECTED] wrote: Hello, I have run into a situation where

RE: paypal cart

2008-07-29 Thread Chad Gray
-Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2008 12:02 PM To: CF-Talk Subject: RE: paypal cart IPN seems to just pass back the final order info so you can see what they ordered. By base64 encoding your array are you making it smaller

RE: paypal cart

2008-07-29 Thread Chad Gray
Well it works in IE at least. In firefox I get an error missing } in XML expression [Break on this error] document.form1.action = PayPalTest.cfm;\n -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2008 12:27 PM To: CF-Talk Subject: RE: paypal

RE: paypal cart

2008-07-29 Thread Chad Gray
Ok last post, it does work in Firefox and IE. I just had a big typo on my script declaration. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2008 12:39 PM To: CF-Talk Subject: RE: paypal cart Well it works in IE at least. In firefox I get

RE: paypal cart

2008-07-29 Thread Chad Gray
I thought of that, but they also only allow like 80 characters per option. So there is a chance that information could get truncated. I think the form submitting to two action pages is going to work. I have not found a problem with it yet. Of course if one action page fails then I loose the

RE: paypal cart

2008-07-29 Thread Chad Gray
On Tue, Jul 29, 2008 at 2:13 PM, Chad Gray [EMAIL PROTECTED] wrote: I thought of that, but they also only allow like 80 characters per option. So there is a chance that information could get truncated. I think the form submitting to two action pages is going to work. I have

query optimization

2008-07-10 Thread Chad Gray
Is there any way to speed up a query that uses DISTINCT on a large table. SELECT DISTINCT(COLORCLASS) FROM JobTicket WHERE COLORCLASS IS NOT NULL ORDER BY COLORCLASS This query takes about 4 seconds because the table is very large.

RE: query optimization

2008-07-10 Thread Chad Gray
server (Oracle vs. MSSQL). Have to experiment and see. cheers, barneyb On Thu, Jul 10, 2008 at 9:11 AM, Chad Gray [EMAIL PROTECTED] wrote: Is there any way to speed up a query that uses DISTINCT on a large table. SELECT DISTINCT(COLORCLASS) FROM JobTicket WHERE COLORCLASS

Exception Thrown and Not Caught in IE

2008-06-12 Thread Chad Gray
I am experimenting with CFLayout and I am running into a strange error that only happens in IE: Exception Thrown and Not Caught It works fine in Firefox. What I want to do is display a tab in CFLayout if that tab is in my Query result. If that tab is not in my query results I hide it. So I

RE: Exception Thrown and Not Caught in IE

2008-06-12 Thread Chad Gray
Ya if I execute my code with a button using onClick the code works fine. It is like the code is running before the page is done processing. How do I execute the javascript as the LAST thing the page does? -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Thursday

RE: Exception Thrown and Not Caught in IE

2008-06-12 Thread Chad Gray
Thanks James that does do the trick. Is this a hack or a good way of handling this? What if the page takes a long time to load? Or the browser takes a long time to process the content? Will half a second suffice? Chad -Original Message- From: James Wolfe [mailto:[EMAIL

(ot) javascript help

2008-06-11 Thread Chad Gray
Can any javascript gurus tell me why this does not work? I want the br tag to display on the page so I get a carriage return between the two pieces of text Foo and Moo. I get this error in Firbug: document.tabbedTicket.FTDTYPEe has no properties script function makeNewEntry() {

RE: (ot) javascript help

2008-06-11 Thread Chad Gray
getElementById On Wed, Jun 11, 2008 at 12:34 PM, Chad Gray [EMAIL PROTECTED] wrote: Can any javascript gurus tell me why this does not work? I want the br tag to display on the page so I get a carriage return between the two pieces of text Foo and Moo. I get this error in Firbug

ext-all.css

2008-06-11 Thread Chad Gray
I am experimenting with CFLayout and I noticed in Firebug's console there are a ton of warnings for this file: ext-all.css Looks like CFLayout is what is calling in the CSS file. link rel=stylesheet type=text/css href=/CFIDE/scripts/ajax/resources/ext/css/ext-all.css / Is this normal?

cfoutput

2008-06-10 Thread Chad Gray
If I use cfoutput with query=foo and the queries record count is 0. The CFoutput is not stepped into. Has this always been true? I have some code like this and noticed that I never returned the NOT FOUND statement because if the recordcount is zero the cfoutput is skipped over. cfoutput

windows performance monitor

2008-06-04 Thread Chad Gray
Since I have CF8 Standard I don't get the built in performance monitoring in CFAdmin. So I thought I would fire up Window's performance monitor and load up some CF8 counters. I selected the CF8 Server Performance object and I cant add any counters. The add button is grayed out. I know in

RE: windows performance monitor

2008-06-04 Thread Chad Gray
Ah! Thanks! I clicked it on, but the setting does not seem to hold. If I navigate back to the Debug page in the CFAdmin it is un-checked. Do I have to re-start the service? Thanks! Chad -Original Message- From: Alan Rother [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2008

RE: windows performance monitor

2008-06-04 Thread Chad Gray
Ya I restarted the CF8 service and the option does not stay turned on. I click submit and it shows it checked. I nagigate away from the page and back and it is not checked anymore. I re-start the service and it still is un-checked. Strange. -Original Message- From: Chad Gray

cfoutput in a cfouput

2008-05-28 Thread Chad Gray
Since when have we been able to nest cfoutputs? I have always thought that you could not do this. Maybe it was a CF4.5/5.0 thing and in never learned it was possible in MX? I just tried this and it works in my CF8 installation: cfoutput query=foo group=id #foo.id#br cfoutput#foo.b#br/cfoutput

cfldap

2008-05-27 Thread Chad Gray
If I have the users old password can I change the password to something new using CFLDAP? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial

ms sql's enum

2008-05-21 Thread Chad Gray
MySQL has the enum datatype that you can set to Yes/No, True/False etc. What is MS SQL's version of this datatype? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial

RE:_What_relationship_am_I_missing_in_this_query ?

2008-05-21 Thread Chad Gray
I think you need to move your second query out of the select statement and into the join section of the query. This chunk of SQL goes and gets the most recent ElementStatusHistoryID by using a GROUP BY and uses it to join in the table at that one row that it finds with the GROUP BY. Hope it

RE: MSSQL Query help - Finding an exact word in a field

2008-05-21 Thread Chad Gray
I know you can use square brackets and the carrot symbol to exclude characters. LIKE 'CAP[^T]%' Will give you everything that does not begin with CAPT So I _think_ you can do this. Try it and let me know. LIKE '%[^abcdefghijklmnopqrstuvwxyz]CAP[^abcdefghijklmnopqrstuvwxyz]%' You are probably

RE: MSSQL Query help - Finding an exact word in a field

2008-05-21 Thread Chad Gray
, but won't return records with CAPTAIN or CAPITAL. At least I think it will. Try it out. I am not in front of a MS SQL server. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 2:17 PM To: CF-Talk Subject: RE: MSSQL Query help - Finding

RE: MSSQL Query help - Finding an exact word in a field

2008-05-21 Thread Chad Gray
I am full of incomplete thoughts. I _think_ you can abbreviate with a-z and 1-9 instead of typing out the characters. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 2:27 PM To: CF-Talk Subject: RE: MSSQL Query help - Finding an exact

cfchart

2008-05-19 Thread Chad Gray
I have two series of data. One is on a scale of 0-10 and the other is 0-1000. Is there a way to set the left Y axis to show the scale 0-10 and the right Y axis 0-1000? Thanks, Chad ~| Adobe® ColdFusion® 8 software 8 is the

paragraphformat()

2008-05-16 Thread Chad Gray
I take text in with a standard textarea tag and I try using paragraphFormat() to display on on my display page I don't get the carriage returns. I type into text area: Black Cyan Magenta Yellow And paragraphFormat outputs this in the HTML. Black Cyan Magenta Yellow P Why didn't it use br

CF8 CFDump of query

2008-05-14 Thread Chad Gray
I recently upgraded to CF8 and I noticed when I dump a Query there is something called SQLPARAMETERS and it display an Array. What is this? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to

any ideas

2008-05-14 Thread Chad Gray
I would like to leave my Query open to take in any number of where statements. IE: cfset arguments.clause = JobID = 1 cfquery name=getJobs datasource=#application.dsn# SELECT * FROM Jobs WHERE 1=1 cfif len(arguments.clause)AND #arguments.clause#/cfif /cfquery Of course the problem with

<    1   2   3   4   5   6   7   8   9   >