Re: Error converting data type varchar to numeric

2008-09-26 Thread Sam Roach
I've had problems in the past passing to numeric fields. EX: cfprocparam type=In cfsqltype=CF_SQL_NUMERIC dbVarName=FIELD_GOAL value= null=YES try putting a value in as a test to see if this is where your error is. EX: cfprocparam type=In cfsqltype=CF_SQL_NUMERIC dbVarName=FIELD_GOAL value=0

Re: cfloop using to much memory

2008-06-26 Thread Sam Roach
Yes I am using CF8. On Wed, Jun 25, 2008 at 6:26 PM, Dan Vega [EMAIL PROTECTED] wrote: Are you using CF8 because they made many improvements to this very problem in 8. Dan On Wed, Jun 25, 2008 at 9:17 PM, Sam Roach [EMAIL PROTECTED] wrote: We are trying to create a CSV file with about

Re: cfloop using to much memory

2008-06-26 Thread Sam Roach
:17 PM, Sam Roach [EMAIL PROTECTED] wrote: We are trying to create a CSV file with about 250,000 rows with about 40 dynamic columns which we need to loop over so we can get the correct order. We see an issue coming from the nested loops on the large dataset and the server

Re: Replace comma in replace list

2008-06-26 Thread Sam Roach
I don't know if you can do it with the ReplaceList function at all... But you can wrap your var with a replace first.. Example: cfset new_var=#ReplaceList(trim(replace(my_var,,,_,all)), ##,,%,,/,\,*,?,,,|,:,$,.,',,@,#chr(44)#,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_)# hope this helps. -- Sam On

Re: cfloop using to much memory

2008-06-26 Thread Sam Roach
26, 2008 at 5:50 AM, Brian Kotek [EMAIL PROTECTED] wrote: Can you post the code? Because a loop tag itself woudn't be causing memory to spike. It has to be something inside the loop tag. On Thu, Jun 26, 2008 at 2:35 AM, Sam Roach [EMAIL PROTECTED] wrote: I'm using a java stringbuffer which

Re: cfloop using to much memory

2008-06-26 Thread Sam Roach
? And what exactly is the issue with the memory climbing until the GC runs...that's exactly what its supposed to do. On Thu, Jun 26, 2008 at 12:48 PM, Sam Roach [EMAIL PROTECTED] wrote: This empty loop as posted here will cause the same memory spikes. You can create just a simple .cfm

cfloop using to much memory

2008-06-25 Thread Sam Roach
We are trying to create a CSV file with about 250,000 rows with about 40 dynamic columns which we need to loop over so we can get the correct order. We see an issue coming from the nested loops on the large dataset and the server is running out of memory. We took a step back on even doing a

Re: ScottishCFUG : Connect Meeting with Rob Gonda on AJAX

2006-12-07 Thread Sam Roach
Has anyone setup a Coldfusion EDI VAN system? I'm Looking for some information on translations for 850 POs, or any other docs. It would be nice not to have to start from scratch. Any code samples can be zipped and emailed to me directly. Also does anyone have an infomation about becoming a VAN.

EDI X12 COLDFUSION

2006-12-06 Thread Sam Roach
Has anyone setup a Coldfusion EDI VAN system? I'm Looking for some information on translations for 850 POs, or any other docs. It would be nice not to have to start from scratch. Any code samples can be zipped and emailed to me directly. Thanks, -- Sam

Table Rename

2006-09-20 Thread Sam Roach
Anyone know how to rename a table from within ColdFusion MX6.1 running MSSQL Server 2005. Here is what I am trying. CFQUERY NAME=ALTER_TABLE DATASOURCE=#database# sp_rename '#old_tablename#', '#new_tablename#' /CFQUERY I am receiving this error. Error Executing

RE: Table Rename

2006-09-20 Thread Sam Roach
: Table Rename That sounds like a connectivity issue rather than syntax. -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 1:36 PM To: CF-Talk Subject: Table Rename Anyone know how to rename a table from within ColdFusion MX6.1 running MSSQL

website merging error

2003-12-18 Thread Sam Roach
IIS / Coldfusion MX Has anyone ever come across an error with IIS or ColdFusion where multiple sites on the same server, seem to merge together... Each site has it's own IP address but when browsing certain pages, sometimes graphics will get pulled from the other website.You can hit the

RE: website merging error

2003-12-18 Thread Sam Roach
that did it... thanks to all -- Sam -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, December 18, 2003 9:43 AM To: CF-Talk Subject: RE: website merging error IIS / Coldfusion MX Has anyone ever come across an error with IIS or ColdFusion where

RE: Table help

2003-07-10 Thread Sam Roach
You are trying to make 120% width fit inside 100% wide table... Try putting 20% in each.. table width=100% tr td width=20%/td td width=20%Text1/td td width=20%Test2/td td width=20%Test234/td td width=20%/td /tr /table table width=100% tr td width=20%/td tdText1/td tdTest2/td

OT: MS Access random records

2003-06-18 Thread Sam Roach
I need to grab a random 25000 records from a database, no dups.. I found some code online and modified it, but it is to slow... Works great for just a few records.. The query.. SELECT DISTINCTROW old_table.Name INTO new_table FROM old_table WHERE (((InStr(1,rndSet(25500,'old_table'),(, [id]

RE: MS Access random records

2003-06-18 Thread Sam Roach
nevermind, I got it... -- Sam -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 1:22 PM To: CF-Talk Subject: OT: MS Access random records I need to grab a random 25000 records from a database, no dups.. I found some code online and modified

IIS hiding .cfm

2003-03-26 Thread Sam Roach
Has anyone had any luck with processing .html files to cold fusion? I've set up IIS to pass .HTML extensions to my jrun.dll, but when I try to view the page I get a Page cannot be displayed error. As an experiment I tried passing the page to the asp.dll which seemed to work fine. Looking online

RE: IIS hiding .cfm

2003-03-26 Thread Sam Roach
Coldfusion MX... Version 6 -- Sam -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 8:51 AM To: CF-Talk Subject: Re: IIS hiding .cfm Which version of CF? Jerry Johnson [EMAIL PROTECTED] 03/26/03 11:45AM Has anyone had any luck with

RE: IIS hiding .cfm

2003-03-26 Thread Sam Roach
have to add an entry to the C:\CFusionMX\wwwroot\WEB-INF\web.xml file such as servlet-mapping servlet-nameCfmServlet/servlet-name url-pattern*.htm/url-pattern /servlet-mapping HTH -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 16:45 To: CF

RE: Submitting form from img

2003-03-26 Thread Sam Roach
input type=image src=file.gif -- Sam -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 12:01 PM To: CF-Talk Subject: Submitting form from img Hi, I have a form that I want to submit using an image rather than a input type=submit button. How

RE: Access date issue

2003-02-27 Thread Sam Roach
you may need to put a # around the date if it is a date field in access.. ex.. #dateformat(bdate, m)# = ###Dateformat(searchdate, m)### -- Sam -Original Message- From: Rebecca Joy Sherman [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 11:54 AM To: CF-Talk Subject: Access

RE: link checking tool

2003-02-24 Thread Sam Roach
this tool may help. http://home.snafu.de/tilman/xenulink.html -- Sam -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 1:12 PM To: CF-Talk Subject: link checking tool I just had the great fortune of inheriting a gargantuan app that is

RE: (OT, kinda) Does anyone know a source for downloading IE wit hout auto-install?

2003-02-11 Thread Sam Roach
I saw this posted in on thetechguide.com. Another method that works is at this link: http://www.broomeman.com/support/wsiedown.html Summary: Download ie6setup.exe and save it to, for example, C:\Download and then go to start | run and type this: C:\download\ie6setup.exe /c:ie6wzd.exe /d

RE: Convert format

2003-02-05 Thread Sam Roach
val() command cfset SESSION.ecom.ordernumber = val(qLastOrderNo.newOrderNumber) + 1 -- Sam -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003 12:49 PM To: CF-Talk Subject: Convert format Hi All, I've got a query which retrieves the max

RE: stop/restart

2003-01-30 Thread Sam Roach
net stop IIS Admin Service net start IIS Admin Service -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 8:51 AM To: CF-Talk Subject: stop/restart I know this may be a bit OT but does anyone know the command line in a DOS prompt to stop

RE: stop/restart

2003-01-30 Thread Sam Roach
net stop IIS Admin Service net start IIS Admin Service you also must restart: net start World Wide Web Publishing Service net start FTP Publishing Service -- Sam -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 8:51 AM To: CF-Talk

RE: DateTimeFormat

2003-01-27 Thread Sam Roach
Not in one shot but you can do something like: CFSET MYDATETIME = #DateFormat(#Now()#, -mm-dd)# #TimeFormat(#Now()#, hh:mm:ss)# -- Sam -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: Monday, January 27, 2003 1:10 PM To: CF-Talk Subject: DateTimeFormat

session variables

2003-01-15 Thread Sam Roach
Is there a way to pass session variables across a domain? Ex. from www.mywebsite.com to www1.mywebsite.com? -- Sam ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

RE: session variables

2003-01-15 Thread Sam Roach
both domains serviced by the same CF App Server, both using the same Application name (specified in the Application.cfm file). -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Sam Roach

Spell Checker update.

2003-01-14 Thread Sam Roach
If anyone is interested I just posted an updated version of my free spell checker utility. http://www.samroach.com/downloads.html Also I'm looking for a free place to host a demo of this utility, please let me know if you have some space available. You can email me at [EMAIL PROTECTED] Thanks

RE: Spell Checker update.

2003-01-14 Thread Sam Roach
:26 AM To: CF-Talk Subject: RE: Spell Checker update. Sam, Your page doesn't display. Times out. Andy -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 12:04 PM To: CF-Talk Subject: Spell Checker update. If anyone is interested I just posted

RE: Access Memo Field

2003-01-14 Thread Sam Roach
This may help: ReplaceNoCase(#accessfield#, p, #CHR(10)#, ALL) -- Sam -Original Message- From: David Green [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 10:32 AM To: CF-Talk Subject: Access Memo Field I know this question has been answered many times before but I can't

RE: Spell Checker update.

2003-01-14 Thread Sam Roach
Found a couple of errors with some help. A new version now online. Sorry about the inconvenience to anyone who has already downloaded it. http://www.samroach.com/downloads.html -- Sam -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 10:33

RE: CFDIRECTORY FILTER MX

2002-11-27 Thread Sam Roach
Posting this again I still can't figure it out. thanks, -- Sam -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 26, 2002 9:50 AM To: CF-Talk Subject: CFDIRECTORY FILTER MX I need a little help with the CFDIRECTORY tag... This used to work fine

CFDIRECTORY FILTER MX

2002-11-26 Thread Sam Roach
I need a little help with the CFDIRECTORY tag... This used to work fine in cold fusion 5. But in MX it returns to many files. CFDIRECTORY DIRECTORY=d:\inetpub\wwwroot\tempdir\ NAME=myDirectory FILTER=*0?.html SORT=datelastmodified, name ASC This returns the same results

RE: isDefined() finesse

2002-11-26 Thread Sam Roach
Because the isdefined function doesn't care what the value of the variable you are passing you don't need to use the evaluate function. However if you wanted to output that value you would have to use something like: cfoutput#Evaluate(form.serNum#i#)#/cfoutput -Original

OT: Microsoft SQL, web, and mail server recommendations

2002-10-24 Thread Sam Roach
A friend of mine is getting a T1 line installed and is looking to build three new computer and was after recommendations, also trying to keep the price reasonable. He needs a SQL server (stores a lot of important information) for a custom web app which was built (mostly ASP files) for his

RE: Nice

2002-09-10 Thread Sam Roach
Set your Language preference to CFML in IE you can do this by going to Internet Properties - Languages - Add - User Defined CFML Then browse to Version Information link in ColdFusion MX Administrator. -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Tuesday,

RE: Looping depending on CFIF Statement

2002-08-29 Thread Sam Roach
Maybe: CFIF LoopYes EQ True cfloop index=count from=1 to=10 cfloop index=theindex from=1 to=2 The index Is CFOUTPUT#theindex# /CFOUTPUT /cfloop cfloop cfelse cfloop index=theindex from=1 to=2 The index Is

RE: Looping depending on CFIF Statement

2002-08-29 Thread Sam Roach
The index Is CFOUTPUT#theindex# /CFOUTPUT /cfloop /CFIF -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 8:59 AM To: CF-Talk Subject: RE: Looping depending on CFIF Statement Maybe: CFIF LoopYes EQ True cfloop index=count from

RE: access db

2002-08-15 Thread Sam Roach
With ldbview.exe you can see who is locking the database. http://www.samroach.com/ldbview.exe This may or may not help. -- Sam -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 7:40 AM To: CF-Talk Subject: RE: access db Yes, can

RE: access db

2002-08-15 Thread Sam Roach
Their is a compact / repair utility that comes with NT, that usually fixes a lot of problems. If you need a copy email off list. [EMAIL PROTECTED] -- Sam -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 8:04 AM To: CF-Talk Subject: RE:

RE: access db

2002-08-15 Thread Sam Roach
Have you tried making a copy of the database, booting with a boot disk and deleting the old version? -- Sam -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 8:04 AM To: CF-Talk Subject: RE: access db Yes everyone is out, I don't see

RE: access db

2002-08-14 Thread Sam Roach
Can you edit that table using only access? or is it locked their as well? -- Sam -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 12:14 PM To: CF-Talk Subject: access db I have a client today that is switching their CF site built

Spell Checker

2002-08-08 Thread Sam Roach
Ok I have a project for you Cold Fusion / JavaScript guru's. My spelling sucks and I'm cheep so I don't want to pay for a spell checker and couldn't find a good one for free on the net. So I created one, it seems works fine but it is kind of slow, and it doesn't do suggested words. It can be

Error message (ODBC)

2002-06-21 Thread Sam Roach
ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. I'm getting this error when trying to insert into a table that is linked from Access to a DBF file. From within Access I can insert data fine,

RE: A Tip (maybe new, maybe not)

2002-05-16 Thread Sam Roach
What usually I do is upload the database to a new name and change the ODBC connection to point to the new file. -- Sam -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:25 AM To: CF-Talk Subject: Re: A Tip (maybe new, maybe not)

Computer Professionals / Cold Fusion Programmer

2002-05-14 Thread Sam Roach
Does anyone know how the law works for salaried employees, regarding Computer Professionals? Is there a minimum salary? Computer Professionals - A new law provides for increased hourly minimum pay for exempt computer professionals. The minimum salary requirement for exempt computer

RE: output cf to html

2002-05-02 Thread Sam Roach
Try something with temp variable and see if they change, you should only have to loop though the query once: ex: query SELECT state, city, firstName, lastName FROM myTable ORDER BY state, city, firstName, lastName /query Cfset statetemp = cfset citytemp = cfset firstnametemp =

RE: states - counties - zip codes database?

2002-05-01 Thread Sam Roach
For just city and state: http://www.usps.com/ncsc/lookups/lookup_ctystzip.html -- sam -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 8:11 AM To: CF-Talk Subject: RE: states - counties - zip codes database? Bump, can anyone help me out

RE: states - counties - zip codes database?

2002-05-01 Thread Sam Roach
http://www.speedkeys.com/download.htm There is a text file on this site with zip, city, and area code. This may be helpful. -- Sam -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 8:15 AM To: CF-Talk Subject: RE: states - counties - zip

RE: output cf to html

2002-05-01 Thread Sam Roach
As another option you could cache the queries for 24hours. cfquery name=my_query datasource=my_datasource CachedWithin=#CreateTimeSpan(1,0,0,0)# -- Sam -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 2:35 PM To: CF-Talk Subject:

RE: MX demo

2002-05-01 Thread Sam Roach
works fine for me (IE 5.5 , nt2000 pro) -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 4:05 PM To: CF-Talk Subject: MX demo Does this work for anyone? http://examples.macromedia.com/flash/homemortgage/app_index2.html

RE: masking URLs and cflocation

2002-05-01 Thread Sam Roach
Try cf_download http://devex.macromedia.com/developer/gallery/info.cfm?ID=CA347854-2830-11D4 -AA9700508B94F380method=Full -- Sam -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 4:00 PM To: CF-Talk Subject: RE: masking URLs and cflocation

RE: masking URLs and cflocation

2002-05-01 Thread Sam Roach
oops http://devex.macromedia.com/developer/gallery/SearchResults.cfm?keywords=cf_ download -- Sam -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 4:07 PM To: CF-Talk Subject: RE: masking URLs and cflocation Try cf_download http

RE: SQL Question

2002-04-29 Thread Sam Roach
Not sure if this is exactly what you are looking for, but it will display your table in the format you requested. Hope this helps. This should be pretty fast. -- Sam cfquery name=test datasource=#mydatsource# select * from my_table order by foreign_id, value /cfquery cfset

RE: Oh, that damn Numberformat!!

2002-04-29 Thread Sam Roach
maybe: .00 #numberformat(#number#,00)# -- Sam -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 1:55 PM To: CF-Talk Subject: Oh, that damn Numberformat!! I hate NumberFormat(). Can someone please help? I want my

RE: IE 6.0 Bug

2002-04-18 Thread Sam Roach
works with IE 5.5 too. -craig -Original Message- From: Trusz, Andrew [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 6:56 AM To: CF-Talk Subject: RE: IE 6.0 Bug Its the long way to get to Minesweeper, but it works. andy -Original Message- From: Sam Roach [mailto

RE: using != in a filed with a null value

2002-04-18 Thread Sam Roach
You can also use neq ContactCnt neq 'Do Not Contact' -- Sam - -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:13 AM To: CF-Talk Subject: RE: using != in a filed with a null value I have always

RE: SQL DISTINCT Question

2002-04-18 Thread Sam Roach
try: SELECT email, first(firstname), first(lastname) FROM people GROUP BY email; -- Sam -Original Message- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 4:15 PM To: CF-Talk Subject: SQL DISTINCT Question SELECT DISTINCT Email FROM LinkedEmails returns a

RE: SQL DISTINCT Question

2002-04-18 Thread Sam Roach
ID IN (SELECT Min(ID) FROM Users GROUP BY email) -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 4:33 PM To: CF-Talk Subject: RE: SQL DISTINCT Question try: SELECT email, first(firstname), first(lastname) FROM people GROUP BY email; -- Sam

IE 6.0 Bug

2002-04-17 Thread Sam Roach
http://online.securityfocus.com/archive/1/267561 has anyone tried this? -- Sam __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ:

RE: Make last line of query available

2002-04-15 Thread Sam Roach
Will something with startrow and recordcount work? ex.. cfoutput query=revquery MAXROWS=1 STARTROW=#revquery.recordcount# cfset last_value=#triptrav_seq# /cfoutput -- Sam -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Monday,

RE: Make last line of query available

2002-04-15 Thread Sam Roach
it may be recordcount - 1 -- Sam -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 2:38 PM To: CF-Talk Subject: RE: Make last line of query available Will something with startrow and recordcount work? ex.. cfoutput query=revquery MAXROWS=1

RE: CF VS ASP

2002-04-03 Thread Sam Roach
http://www.houseoffusion.com/hof/body/asp.cfm http://www.swynk.com/friends/murphy/ironic_isnt_it.asp -Original Message- From: Robert Bailey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 11:03 AM To: CF-Talk Subject: CF VS ASP OK, I have been looking for some things on

Mac help needed.

2002-04-01 Thread Sam Roach
This is a site just launched. I've gotten a couple of complaints from Mac users that JavaScript errors coming up using IE. http://www.litewheels.com/index.cfm I would appreciate it if someone could take a look and let me know if they see the error. -- Sam

RE: Mac help needed.

2002-04-01 Thread Sam Roach
a reference to a the function openCookie() in the onUnload event of the body tag. I searched your page and there is not opencookie function being defined. Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent

RE: CF/Database Help

2002-03-29 Thread Sam Roach
In this example is there any reason not to make RC_NAME and IG_NAME primary keys. I guess I just don't like auto numbers. So table 3 would look more like: RC_NAME IG_NAME -- Chocolate Cookies Flour Chocolate Cookies

RE: dynamic select boxes with dynamic names

2002-03-27 Thread Sam Roach
Try the Evaluate command: cfloop INDEX=loopcount FROM=1 TO=#FORM.NUMOFQUESTIONS# STEP=1 #Evaluate(Answer#loopcount#)# /cfloop -- Sam -Original Message- From: Metzy Martinez [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 9:22 AM To: CF-Talk Subject: dynamic select

RE: Screen width, Height, Color Depth

2002-03-25 Thread Sam Roach
can you use: #screen_height# #screen_width# #screen_colors# -Original Message- From: BEN MORRIS [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 12:49 PM To: CF-Talk Subject: Re: Screen width, Height, Color Depth You will have to have one form page that

RE: Screen width, Height, Color Depth

2002-03-25 Thread Sam Roach
- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 12:58 PM To: CF-Talk Subject: RE: Screen width, Height, Color Depth can you use: #screen_height# #screen_width# #screen_colors# -Original Message- From: BEN MORRIS [mailto:[EMAIL PROTECTED

RE: Time Issue

2002-03-25 Thread Sam Roach
Also make sure you have the correct time zone selected. -- Sam -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 1:52 PM To: CF-Talk Subject: Re: Time Issue checked smtp server time and it is right as well. - Original Message -

RE: asc() to identify line break characters

2002-03-22 Thread Sam Roach
TRY #replace(string,chr(13),p,all)# -- Sam -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 11:46 AM To: CF-Talk Subject: asc() to identify line break characters I have a bunch of articles stored in a DB that need to be presented

RE: Tall Table

2002-03-21 Thread Sam Roach
you can use a transparent gif. tabletrtd img src=trans.gif align=right width=1 height=250 /td/tr/table -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 8:20 AM To: CF-Talk Subject: Tall Table I would like to have a specified height in a table

RE: Tall Table

2002-03-21 Thread Sam Roach
I guess I didn't understand the initial request completely. -- Sam -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 8:42 AM To: CF-Talk Subject: Re: Tall Table What is that going to do? Neil - Original Message - From: Sam Roach

RE: Tall Table

2002-03-21 Thread Sam Roach
Here is an example: http://www.siteexperts.com/tips/html/ts04/page1.asp -- Sam -Original Message- From: Kirk Boecker [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 9:09 AM To: CF-Talk Subject: Re: Tall Table you can do this with style sheets - using the overflow

RE: Inserting CFIF into CFINPUT

2002-03-21 Thread Sam Roach
cfif #GEC.Sex# eq Male cfinput type=Radio name=sex value=Male CHECKED = TRUE cfelse cfinput type=Radio name=sex value=Male /cfif -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 11:07 AM To: CF-Talk Subject: Inserting CFIF

RE: HTML Email

2002-03-20 Thread Sam Roach
You can use the standard CFMAIL just set type=html ex: CFMAIL To=#mailaddress# From=#fromaddress# Subject=#subj# server=#server# port=25 type=html HTMLhead/head body bgcolor=##FF link=##FF vlink=##FF

RE: two SUBMIT buttons on a form?

2002-03-20 Thread Sam Roach
you could set a name for you submit buttons. On you process page do a include based on which button was clicked. EX: form action=go.cfm input type=submit value=x1 name=click_x1 input type=submit value=x2 name=click_x2 /form -- go.cfm cfif isdefined(click_x1) cfinclude

RE: two SUBMIT buttons on a form?

2002-03-20 Thread Sam Roach
Yes -- Sam -Original Message- From: Scott Van Vliet [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 5:04 PM To: CF-Talk Subject: RE: two SUBMIT buttons on a form? Does that work in Netscape? -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent