RE: Table help

2003-07-10 Thread Tony Walker
This might work... table cellspacing=0 cellpadding=0 border=0 tr td width=20%/td td width=80% table cellspacing=0 cellpadding=0 border=0 tr td/td td/td

RE: JavaScript var to Cold Fusion var

2003-07-01 Thread Tony Walker
You could create a text area and stick the string in it and have it as the last thing on the page in a span that you hide: function buildLongString(parms) { document.all. txaLongString.value = ''; . build the string here

RE: JavaScript var to Cold Fusion var

2003-07-01 Thread Tony Walker
it at all, except maybe for debugging purposes. --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com -Original Message- From: Tony Walker [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003

RE: JavaScript var to Cold Fusion var

2003-07-01 Thread Tony Walker
are for. no sense exposing it at all, except maybe for debugging purposes. --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com -Original Message- From: Tony Walker [mailto:[EMAIL

RE: JavaScript var to Cold Fusion var

2003-07-01 Thread Tony Walker
Can't remember - read it on a web page somewhere and assumed it was accurate - what is the max length if that is not right? ô¿ô Tony -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 3:27 PM To: CF-Talk Subject: RE: JavaScript var to Cold Fusion

RE: Correct way to match a record with a list in one field?

2003-07-01 Thread Tony Walker
cfset s=#FORM.SubjectID# cfset s1=, cfset s2=',' cfset p2=#Replace(s,s1,s2,All)# SELECT EmailAddr, RecipientID FROMSupportEmailRecipient WHERE SubjectID IN ('#p2#') ô¿ô Tony Tuesday, July 1, 2003, 2:58:55 PM, you wrote: LF Ok guys.. Thinking caps: ON LF Have an nvarchar field in the

RE: MS Access random records

2003-06-18 Thread Tony Walker
1. select distinctrow old_table.name into new_tableA 2. create new_TableB 3. change your random record selector to loop 25500 times, randomly selecting a record from new_tableA, inserting it into new_tableB and deleting it from new_tableA. ô¿ô Tony -Original Message- From: Sam Roach

RE: paired values in lists

2003-06-12 Thread Tony Walker
If you plop the following into Query Analyzer (assuming SqlServer200) I think you will get what you want: declare @cid int set @cid = 2 if object_id('tempdb..#tblAttributeType') is not null drop table #tblAttributeType if object_id('tempdb..#tblColor') is not null drop table #tblColor if

RE: SQL Question - Could CF make this easier?

2003-06-11 Thread Tony Walker
Or, if possible, add a field to the vct file for include/exclude... ô¿ô Tony -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 11:37 AM To: CF-Talk Subject: SOT: SQL Question - Could CF make this easier? I am creating a drop-down list of

RE: Newbyish Question (FORMS)

2003-06-10 Thread Tony Walker
Code like below will produce a form field variable of Accomidations=1,3 in the checkTheBoxes.cfm if Hotel and Bed and Breakfast are both checked. html head titleUntitled/title /head body form name=chkBoxes action=checkTheBoxes.cfm method=post table cellspacing=0 cellpadding=0

RE: Newbyish Question (FORMS)

2003-06-10 Thread Tony Walker
Sorry... Forgot the sql part: Code like below will produce a form field variable of Accomidations=1,3 in the checkTheBoxes.cfm if Hotel and Bed and Breakfast are both checked. html head titleSelect Multi Boxes/title /head body form name=chkBoxes action=checkTheBoxes.cfm method=post

RE: multiple select drop down from query

2003-06-10 Thread Tony Walker
If you are using MX put these two queries in a .CFC and invoke it with #pageid# as an argument. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

RE: Stored Proc Question Help Please

2003-06-06 Thread Tony Walker
SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO create PROCEDURE dbo.sp_getId AS BEGIN declare @intError int if object_id('tempdb..#myTempTable') is not null drop #myTemptable /* Create Table */

RE: ...But the pages are there!

2003-06-05 Thread Tony Walker
Try clearing your browser cache. ô¿ô Tony -Original Message- From: Richard Crawford [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 8:21 AM To: CF-Talk Subject: ...But the pages are there! Thanks to all who replied to my question about index 55, size 33. I deleted the .class

RE: SQL concat

2003-06-05 Thread Tony Walker
You might need to use #preserveSingleQuotes(form.txtFormField1)# ô¿ô Tony -Original Message- From: CF Dude [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 10:21 AM To: CF-Talk Subject: Re: SQL concat That should work assuming your datatypes work together. HEre's another