RE: DB design suggestion

I'm no expert on this. Nonetheless, here is my non-expert thinking: I'd keep all of the user information in one table. I would then create separate tables for payment, questions, text, image, sound, and video. This way, any single can have as many or as few payments/questions/etc., as they

RE: Alternating table row colors producing duplicated output

Mike, First, I'd make absolutely sure that the bgcolor setting is what's hurting you. Clip out the whole bgcolor=... parameter, then take another look. If you still see a problem, I'd cut out all the formatting: see whether the data is coming out duplicated. If the problem suddenly leaves, I'd

CFStudio/UltraDev Development Setup

Hi, everyone. I am trying to set up a development environment with ColdFusion Studio and Dreamweaver UltraDev. Would someone mind telling me whether my setup is crazy? I have an NT 4.0 Server running IIS with a static IP address so that any machine on our Intranet can see it. In the

RE: Excel problem

Sandi, I don't know if I understand exactly what you are trying to do, but I can give you some information that might help. At some point in what you are doing you are populating an Excel file, right? If this is a static Excel file that is dynamically populated, you can change the formatting

RE: Is it possible to write to the header in an html page

This probably isn't what you want, but what about an intermediate page that holds a form full of hidden fields and automatically posts itself once displaying? It still is post WITH a form, but not from the user's perspective. But you must be doing something more than just passing variables,

RE: Weird Problem - Additional Info

Mary, If I understand correctly, your code looks roughly like this: CFQUERY NAME="MyQuery" blah blah blah SELECT VarCharField FROM blah blah blah /CFQUERY FORM blah blah blah CFOUTPUT INPUT TYPE="text" NAME="MyInput" VALUE="#MyQuery.VarCharField#" blah blah blah

RE: Application.cfm Problem

Martin, It strikes me as very strange that you would be getting a 404 error based on whether or not you ask for a variable value. (I'm sure it strikes you as strange, too!) It seems to me that it ought to be throwing a "variable not defined" sort of error. How could the CFOUTPUT statement

RE: Allaire and Macromedia Announce Plans to Merge

Michael, I don't know what a "bad email header" is. (And I may not be the only ignorant one!) I want to make sure that I am not sending these little gremlins into the list. Is it something over which the sender has control? If so, how do we fix it on our end? Thanks, Matthieu -Original

RE: Javascript

Robert, How about this: When you point to this popup window from your site, append a variable in the query string (e.g., ?ProperlyLaunched=True). Then the popup window checks for this variable. If it doesn't exist, use JavaScript to go back one page. If you are worried that users would hack

RE: CF and FrontPage

Haven't had a problem yet, am running CF4.5, Frontpage and Flash 4 all on the same machine. Bob Lehman New Horizon Mgmt and Consulting 440-542-0992 [EMAIL PROTECTED] Website: www.nhmac.com Client website: www.nhmac-user.com - Original Message - From: "Cornillon, Mat

RE: string to number

Steve, As long as you keep your ranges as you have them in your If statements, the following formula should yield the correct result. I know this doesn't address the question that you asked, but others have responded to that, and I just couldn't help fiddling. Hope you don't mind. CFSET

RE: any ideas?

Jay, How about the following nested Iif statement? tr bgcolor="#IIf(DirList.CurrentRow Mod 2, DE('E7'), Iif(ElseIfCondition, DE('FAFAFA'), DE('OtherColorCode'))#" I don't exactly understand what your conditions/results are, but I use this sort of 3-way If statement all the time in Excel.

CF and FrontPage

Hi. I have a development machine with ColdFusion Studio/Server (single license) on it. For a couple of reasons, I'd like to install FrontPage on the same machine to do some simple visual HTML editing that can be a drag in CFStudio. Someone suggested to me that FrontPage might foul things up

RE: setting multi line strings

Ruslan, I'm not sure what you're aiming for here. How will you use myhtml later? If you plan to use it to include bits of HTML within other pages, I would put the HTML in a separate file and do a CFINCLUDE wherever you want to insert it. Does that do what you want? Hope this helps, Matthieu

RE: HELP!!

Jay, I see a problem in the first INSERT statement. I went through the column names and the inserted values. They all match up through column name Type, which matches to value '#form.RealName#'. From then on, they are off by one, and you end up with one less value than you have columns. I

RE: What Does OT Stand For?

off topic, in this context. elsewhere, it might stand for overtime or ocelot tapdancing. :) matthieu -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 10:32 AM To: CF-Talk Subject: What Does OT Stand For?

RE: Forms, Submit and maybe JavaScript

I was thinking something along these lines, although I don't know the specific syntax for the events. I remember doing this years ago in a different context. I had to set the equivalent of the onKeyPress() event to fire a macro. The macro would evaluate the character code of the key pressed

RE: SQL Syntax Error

Erika, Hmmm. I assume that your development and production databases are not one and the same? If so, I think that you might have a problem with your data types being differently defined. I would look at the data structure for the two different versions to see if all the types are the same.

site navigation templates

Hi. On the site that I maintain, each page has a series of links along the side and bottom of the page. I want to set up header (side links) and footer (bottom links) documents that I can CFINCLUDE from all over the site. Links on the bottom are constant across the site. Easy. But links on

RE: RequestTimeout

Maybe this is set in the CF Server settings? HTH, Matthieu -Original Message- From: Raley, Scott M (MIL) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 9:13 AM To: CF-Talk Subject: RequestTimeout I have a query that takes a while to produce results. It takes

RE: checking multiple boxes w/single button?

Dave, Here is a page of HTML that uses JavaScript to loop through all of the elements of a form and set the checked value to true or false. I am not sure how to specify that it only look at checkboxes, but since checked is only a property of checkboxes (I think), the browser would just ignore

RE: Syntax error (missing operator) or blank screen

Guy, Perhaps I'm misunderstanding, but I think I know what's wrong. I am assuming that AssociatedHTMDoc is your column name in the database. Shouldn't it go first in the line, like this: WHERE AssociatedHTMDoc = 'http://www.ofah.org/#url.URL#' If you leave the quotes off the way that you

RE: dynamic form controls

All, Thanks for your help on this. Aaron and Mike, you are both right--Nate's tag is the perfect solution. Thank you, Nate. Matthieu -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 02, 2001 8:52 PM To: CF-Talk Subject: RE: dynamic form

dynamic form controls

Happy new year, everyone. I have a form with a couple of drop down controls. I'll call them dd_country and dd_city. I would like the contents of dd_city to be based on the contents of dd_country. If the user selects France, the dd_city should hold Paris, Marseilles, Nice. If the user selects

SQL Dropdown List

Hi. I have a dropdown list that lets users pick a country from a list of company locations stored in a database. Possible entries are France (Paris), England (London), etc. It all works fine. However, my supervisor wants the USA (Cityname) entries to appear at the top of the list, since they

RE: SQL Dropdown List

that. a UNION "stacks" the queries on top of one another. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message----- From: Cornillon, Matthieu [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 28, 2000 1:20 PM To: CF-Tal

RE: SQL Dropdown List

Sean, Thanks for the suggestion. Unfortunately, since I will be modifying this list over time, it may start to become a headache to maintain. It is already dreadfully long (not my choice), which means that determining and entering the appropriate new sortby number (e.g., 3.5 or some other

RE: SQL Dropdown List

I see. That is a darned good idea. I will take it into consideration. Thanks to everyone for helping on this! Matthieu -Original Message- From: Sean Daniels [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 28, 2000 3:29 PM To: CF-Talk Subject: RE: SQL Dropdown List

RE: Multiple submits

Add this to the input tag: onclick="return confirm('You better not dare click that button a second time, OK?')" ;-) I'm interested in an answer to this question as well. Matthieu -Original Message- From: Jon Gage [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 19, 2000 9:57 AM

RE: creating an url return string

Greg, I'm a newbie, so please don't expect this answer to be elegant! ;-) Is the problem that you do not know for sure which "sub-"variables will appear within returnURL? If so, the first (ugly) solution that pops to mind is writing a quick routine to loop through the returnURL string,

RE: Trying to get price in Dollar format from Access db

I'm not sure if I've misunderstood, but you might want to take a look at the DollarFormat function in CF. Hope that helps, Matthieu -Original Message- From: Paul Sinclair [mailto:[EMAIL PROTECTED]] Sent: Friday, December 15, 2000 8:53 AM To: CF-Talk Subject: Trying to get price in

RE: radio buttons and passing variable question

a side question, can anyone tell me what #form.variable name# is supposed to do?...i mean what does the # sign signify and what does "form" tell the computer? The # signs tell the CF server to interpret what's inside them as a variable name or function, and not just as a text

RE: Inserting line breaks

Hi. I don't know exactly how this works, but I had a similar need yesterday. I set up the e-mail in the CFM file with breaks where I wanted them. It seems to me that the text between the CFMAIL tags is treated almost as if it is a separate text file, and the format is preserved. If anyone has

RE: division

Rick, The division operator in your first line of code is the wrong slash. I'm not sure why, but CF apparently turns that whole thing into "1". Strange. I reproduced the same problem on my end. Flipping that slash fixes it. Matthieu -Original Message- From: [EMAIL PROTECTED]

<    1   2   3