chars not accepted in SQL?

2004-06-11 Thread Robert Orlini
"INSERT INTO itemsordered Is there a code/way to make SQL accept these characters. The ITEM column is setup as a CHAR field. Should it be VARCHAR? Thanks as always. Robert Orlini [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: get one record from array

2004-06-08 Thread Robert Orlini
, and then get rid of . You can also replace i by url.edit inside the cfloop and then get rid of . Notice I used url.edit instead of edit. It is always best to scope your variables. Pascal > -Original Message- > From: Robert Orlini [mailto:[EMAIL PROTECTED] > Sent: dinsdag 8 j

RE: get one record from array

2004-06-08 Thread Robert Orlini
]# is a struct. What do you get if you cfdump it? You will probably need something like #session.item[url.edit].qty# Pascal > -Original Message- > From: Robert Orlini [mailto:[EMAIL PROTECTED] > Sent: dinsdag 8 juni 2004 20:00 > To: CF-Talk > Subject: RE: get one record fr

RE: get one record from array

2004-06-08 Thread Robert Orlini
age- > From: Robert Orlini [mailto:[EMAIL PROTECTED] > Sent: dinsdag 8 juni 2004 19:37 > To: CF-Talk > Subject: get one record from array > > I have a URL as: > > border="0" src=""> > > The #i# is in an Array. My question is how do I search fo

get one record from array

2004-06-08 Thread Robert Orlini
I have a URL as: The #i# is in an Array. My question is how do I search for that specific record on the popup page? Right now I have a CFLOOP () which of course goes thru and displays all the records. I just want the popup to display that particular record. I'm new to arrays sorry. Roberto H

popup from image

2004-06-08 Thread Robert Orlini
I have an image named "edit" and I would like to have it generate a popup when its clicked. I would like to pass a parameter with it as well. I've grabbed and edited a previous script I had (see below) but before I continue I was wondering if there were any good ideas out there please? Its all cont

RE: JS Page break

2004-06-04 Thread Robert Orlini
; From: Robert Orlini [mailto:[EMAIL PROTECTED] > Sent: Friday, June 04, 2004 2:06 PM > To: CF-Talk > Subject: OT: JS Page break > > Is there a _javascript_ code that I can use to insert a page > break? I want to print something but section it into 4 or 5 pag

OT: JS Page break

2004-06-04 Thread Robert Orlini
Is there a _javascript_ code that I can use to insert a page break? I want to print something but section it into 4 or 5 pages. Robert O. ô¿ô [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: prevent refresh w/session

2004-06-04 Thread Robert Orlini
Yes. Except when I use the "not" after the CFIF it doesn't display the page at all. When I leave the "not" in it displays it, but when I refresh it adds data to the page and that's what I'm trying to avoid. Am I still missing something? -Original Message- From: [EMAIL PROTECTED] [mailto:[

prevent refresh w/session

2004-06-04 Thread Robert Orlini
I'm using this code to prevent a refresh from re-entering data: Run code It still runs the code after the up on top. What am I doing wrong here? Any ideas please? Robert O. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

update an array

2004-06-03 Thread Robert Orlini
I have a form that displays information from an array into input text fields. I want the user to be able to change values in these boxes and submit the form and update the values. How do I update info in an array? Robert O. Wilson [Todays Threads] [This Message] [Subscription] [Fast Unsu

RE: Array error

2004-06-02 Thread Robert Orlini
  _   From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 3:11 PM To: CF-Talk Subject: Array error Why do I get this error?: An error occurred while evaluating the _expression_: session.item[variables.arrayLength+1][1]=form.qty Error resolving parameter

RE: Error on Array

2004-06-02 Thread Robert Orlini
-Talk Subject: RE: Error on Array Because ArrayDeleteAt doesn't return an array but a boolean! If you run the code twice, the array has disappeared. Just do > -Original Message- > From: Robert Orlini [mailto:[EMAIL PROTECTED] > Sent: woensdag 2 juni 2004 16:52 > To:

Error on Array

2004-06-02 Thread Robert Orlini
Why am I getting this error? What does it mean please? An error occurred while evaluating the _expression_: session.item=#ArrayDeleteAt(session.item,1)# Parameter 1 of function ArrayDeleteAt which is now "YES" must be an array. The error occurred while processing an element with a general identifi

Array error

2004-06-02 Thread Robert Orlini
Why do I get this error?: An error occurred while evaluating the _expression_: session.item[variables.arrayLength+1][1]=form.qty Error resolving parameter VARIABLES.ARRAYLENGTH. The specified variable name cannot be found. for the bold line below. I'n new to arrays so any insight would be great!

OT: Javascript validation

2004-05-27 Thread Robert Orlini
I have a function to make sure a user enters a number. How can I include a number and a comma and period if a user wants to enter a price such as: 9.90? The line: if(charVal < "0" || charVal > "9" && charVal != "." && charVal != ",") still prevents a comma and period. function isNumber2(inputStr

Preventing a REFRESH

2004-05-26 Thread Robert Orlini
I know this was touched on before and I re-read the thread but did not find my answer. I need a way to prevent the browser's refresh from re-submitting info. Is there a way via CF or _javascript_? anyone have something already please? Thanks. Robert HWW [Todays Threads] [This Message] [Subs

cflocation question

2004-05-25 Thread Robert Orlini
Can CFLocation point to a file and open it in a new window? I'm using frames. Are there other options if this is not possible? Roberto O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: simple form field question

2004-05-25 Thread Robert Orlini
question You don't name a form field as "form.ponumber" You just name is "ponumber" and it will automatically be in the form scope. Will come through on the next page as #form.ponumber# John -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent:

RE: simple form field question

2004-05-25 Thread Robert Orlini
-Talk Subject: RE: simple form field question form.vendor (this is the name of your input) > -Original Message- > From: Robert Orlini [mailto:[EMAIL PROTECTED] > Sent: dinsdag 25 mei 2004 17:12 > To: CF-Talk > Subject: simple form field question > > This may be a

simple form field question

2004-05-25 Thread Robert Orlini
This may be a simple one, but I'm a bit slow this morning...and stumped. I have a form that is populated with a cfquery so a field looks like this: How is this then set to another form where an update (cfquery with the SET command) can be done? I try it with the code below but get an error of c

RE: Comma in price

2004-05-21 Thread Robert Orlini
Thanks Rick and Claude. It worked. RO -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 11:44 AM To: CF-Talk Subject: Re: Comma in price Just remove any comma from the string first: -- ___ See some cool

Comma in price

2004-05-21 Thread Robert Orlini
I'm using dollarformat to convert prices. However, if I user inputs a large price with a comma, such as 1,200.00 it generates a "cannot convert number" error. To save time, what is the best way to allow a user to enter a comma and still be able to calculate the price against a quantity. Robert O.

SOT: SQL Error converting data type

2004-05-20 Thread Robert Orlini
Why would I get this SQL error : Error converting data type varchar to numeric on one filed and not another when I do a submit from a form even though they are setup the same. Both are numeric in the SQL table. I'm entering them this way: INSERT INTO purchaseorders ( ponumber, cnumber )

RE: passing a form field

2004-05-19 Thread Robert Orlini
essage- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 10:56 AM To: CF-Talk Subject: RE: passing a form field #trim(form["qty#count#"])# -----Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 10:37 AM To: CF-

passing a form field

2004-05-19 Thread Robert Orlini
How do I pass a form field which is dynamic. I have qty#count# as the qunatity field. How do I pass this in a hidden field to another form when the user clicks submit. I have it in a hidden field but of course this does not work: Tried: #Evaluate(count)# How would that fit in? Thx. Robert O.

Array problems

2004-05-18 Thread Robert Orlini
This array works but it keeps incrementing values in each row. Using CFDUMP values for the first row appear with a comma in the second row along with its values. Why doesn't it generate a new row? Please help... Tried moving to no avail. Robert O. [Todays Threads] [This

RE: Array question

2004-05-17 Thread Robert Orlini
Thank you. One more ?: How do I clear the array to start over? -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 3:50 PM To: CF-Talk Subject: Re: Array question Because arrayLen(session.item) is 0 and your looping from 1-arrayLen(session.item).

Array question

2004-05-17 Thread Robert Orlini
Why can't I get a display of the fields I'm entering with this array? When I cfoutput the #arraylen(session.item)#  its always 0 (zero). #arraylen(session.item)# #session.item[i][1]# #session.item[i][2]# #session.item[i][3]# Robert Orlini HW Wilson 718-588-8400 x2656 ô¿

New at Structures

2004-05-17 Thread Robert Orlini
I'm new at Structures...I wanted to add  variables to the "items" structure. The variables increment as they go thru a loop. The variable is called "qty" and as it goes thru the loop it would increment as "qty1", "qty2", etc thru a form. Here's the code. I'm having an obvious problem with the wh

RE: CF Isdefined on form click

2004-05-14 Thread Robert Orlini
Thanks Charlie. I'm new to this LOOP stuff. I tried it this way but it doesn't increment correctly (see below). Anything I missed or messed up? ... -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, May 14, 2004 12:06 PM To: CF-Talk Subject: Re: CF Isdefi

RE: CF Isdefined on form click

2004-05-14 Thread Robert Orlini
dd a counter of some sort) :) Charlie - Original Message - From: "Robert Orlini" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, May 14, 2004 8:48 AM Subject: RE: CF

RE: CF Isdefined on form click

2004-05-14 Thread Robert Orlini
- From: "Robert Orlini" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, May 14, 2004 8:23 AM Subject: CF Isdefined on form click > I have a form that checks () if the user clicks a MORE button ( value="more">). If the button i

CF Isdefined on form click

2004-05-14 Thread Robert Orlini
I have a form that checks () if the user clicks a MORE button (). If the button is clicked it adds input form fields that are qty, description, price, total line. It works the first time adding a second row with input form fields that are qty, description, price, total line. It does not work in su

RE: Image reset button

2004-05-11 Thread Robert Orlini
e the onclick attributes? myFormName should be the actual name of your form (?) - Original Message - From: "Robert Orlini" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, May 11, 2004 9:42 AM Subject: RE: Image reset button > Thanks

RE: Image reset button

2004-05-11 Thread Robert Orlini
Thanks Charles. I get a _javascript_ error when I click the button though. RO -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 12:04 PM To: CF-Talk Subject: Re: Image reset button - Original Message - From: "Robert O

RE: Image reset button

2004-05-11 Thread Robert Orlini
net Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com > -Original Message- > From: Robert Orlini [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 11, 2004 10:49 AM > To: CF-Talk > Subject: Image reset button

Image reset button

2004-05-11 Thread Robert Orlini
Is there a way to make an image button to function as a reset button? Here is a SUBMIT as an image: How would I revise this w/an image? Thanks. Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Syntax error on Where statement?

2004-05-05 Thread Robert Orlini
sqltype in the first to cf_sql_char. opt for the former if possible. Charlie - Original Message - From: "Robert Orlini" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, May 05, 2004 8:23 AM Subject: RE: Syntax error on Where stat

RE: Syntax error on Where statement?

2004-05-05 Thread Robert Orlini
is an integer). Otherwise, if you're going to leave it as a char field, change the cfsqltype in the first to cf_sql_char. opt for the former if possible. Charlie - Original Message - From: "Robert Orlini" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL P

RE: Syntax error on Where statement?

2004-05-05 Thread Robert Orlini
All are CHAR fields except ID which is a primary key INT type. Should maint_report_date be other than CHAR? I know date/time would be good, but...I'm kinda new to this SQL biz. Robert O. -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004

RE: Syntax error on Where statement?

2004-05-05 Thread Robert Orlini
#" cfsqltype="cf_sql_date"> AND  id = - Original Message - From: "Robert Orlini" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, May 05, 2004 7:56 AM Subject: Syntax error on Where statement? > Anyone know why

Syntax error on Where statement?

2004-05-05 Thread Robert Orlini
Anyone know why my syntax is wrong in my Where statement please? Cold Fusion Server logged the following error information: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near '='. SQL = "Update maintenance_report

RE: Form button

2004-05-04 Thread Robert Orlini
" First off I'd say just try adding .X to form.C1 EQ "update"  -->  form.C1.X EQ "update". Steven Semrau SRA International http://www.sra.com -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 3:24 PM To: CF-Talk S

Form button

2004-05-04 Thread Robert Orlini
I have an image as a form button as: In my CF code pressing this button should execute an update, however the following code generates an error: Cold Fusion Server logged the following error information: An error occurred while evaluating the _expression_: IsDefined("form.C1.X") and form.C1

OT: Javascript time picker

2004-04-23 Thread Robert Orlini
Anyone know or have a good _javascript_ time picker and/or dropdown script? I need one with AM/PM not in 24 hour format. Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Uneditable textarea box

2004-04-23 Thread Robert Orlini
bar if it's not needed.  One thing this won't do is wrap the text. You'd probably need some DHTML behind the div to check the line length, etc. Jeff Garza   _   From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Friday, April 23, 2004 6:25 AM To: CF-Talk Subject: RE: Uneditable

RE: Uneditable textarea box

2004-04-23 Thread Robert Orlini
How would the code look if it was just a one line text box as opposed to a textarea box? Robert O. -Original Message- From: Jeff Garza [mailto:[EMAIL PROTECTED] Sent: Friday, April 23, 2004 9:23 AM To: CF-Talk Subject: RE: Uneditable textarea box Try using a DIV with a stylesheet behin

OT: Javascript popup onsubmit

2004-04-19 Thread Robert Orlini
Any help w/this _javascript_ would be appreciated. Since I'm very new to _javascript_.
  function popup(popupType) {
  window.open(this);
  }
value="#dateFormat(dateAdd('m',i,now()),'mm')#">#dateFormat(dateAdd('m',i,now()),' ')# The main page displays the page I w

RE: Query date

2004-04-16 Thread Robert Orlini
il 16, 2004 11:20 AM To: CF-Talk Subject: RE: Query date Robert Orlini said: > > I need to compare date ranges of this format: 00/00/. Which format is that? dd/mm/ or mm/dd/? > If the dates in my column are lets say 04/15/2004, 04/20/2004, then > these dates are to be liste

RE: Query date

2004-04-16 Thread Robert Orlini
t;> > -Original Message- > From: Robert Orlini [mailto:[EMAIL PROTECTED] > Sent: vrijdag 16 april 2004 14:47 > To: CF-Talk > Subject: RE: Query date > > Thanks Jochem. I still get an error. See below: >   > Microsoft][ODBC SQL Server Driver][SQL Server]Incorre

RE: Query date

2004-04-16 Thread Robert Orlini
="cf_sql_integer" value="#Month(Now())#"> > -Original Message- > From: Robert Orlini [mailto:[EMAIL PROTECTED] > Sent: vrijdag 16 april 2004 14:47 > To: CF-Talk > Subject: RE: Query date > > Thanks Jochem. I still get an error. See below: >   > Micro

RE: Query date

2004-04-16 Thread Robert Orlini
- Parameter #1 = 4 Maybe I copied something wrong? Robert O. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 4:11 PM To: CF-Talk Subject: Re: Query date Robert Orlini wrote: > I'm doing a comparison of the current d

RE: Query date

2004-04-15 Thread Robert Orlini
#x27;' where you fill '' and '' with a begin and end date...dont fool around with stripping the first two chars. off...thats kludgy.. tony Tony Weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] 410.548.2337 www.navtrak.net -Original Message-

Query date

2004-04-15 Thread Robert Orlini
I'm doing a comparison of the current date with the date in a table: Select * >From maintenance_report Where id = id and "#left(maint_report_date,2)#" = "#dateFormat(Now(), "MM")#" Order by id desc I'm isolating the first two chars of the date (i.e. 04/05/2004) lets say "04" and comparing

RE: previous months

2004-04-15 Thread Robert Orlini
Thanks Tony and others for their two cents. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 2:54 PM To: CF-Talk Subject: RE: previous months value="#dateFormat(dateAdd('m',i,now()),'mm/dd/')#">#dateFormat(date Add('m',i,now()),'mm/dd/yyy

RE: previous months

2004-04-15 Thread Robert Orlini
date Add('m',I,now()),'mm/dd/')# try that ...tony -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 2:30 PM To: CF-Talk Subject: previous months I know how to use the date function and all: #DateFormat(tod

previous months

2004-04-15 Thread Robert Orlini
I know how to use the date function and all: #DateFormat(todayDate, "mmm-dd-")# But how do I do a search for previous months? I remember seeing a minus and a number somewhere in the dateformat mask. I want to make a dropdown to list previous months. Robert O HWW [Todays Threads] [This Mes

RE: limit display of text

2004-04-15 Thread Robert Orlini
do, something like this will do #Left(report.maint_report_task,25)#... see http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functi17.htm#wp1099887 Doug -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 11:05 AM To: CF-Talk Subject

limit display of text

2004-04-15 Thread Robert Orlini
I have a filed, #report.maint_report_task#, that will be displayed via a . How can I display just a portion of what the field contains? If it contains: "blah, blah, blah, blah" Because of display constraints, I want it to just display a portion with the three periods after it: "blah, blah...". Do

RE: CFIF within input

2004-04-06 Thread Robert Orlini
CF-Talk Subject: RE: CFIF within input ur missing a ">" trim(side_1_comments) NEQ ""> value="#trim(side_1_comments)#"> try that. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:21 AM To: CF-Talk S

RE: CFIF within input

2004-04-06 Thread Robert Orlini
m(side_1_comments)#"> try that. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:21 AM To: CF-Talk Subject: CFIF within input I want to display text in a input box's value field if there is any info in the database. The cod

CFIF within input

2004-04-06 Thread Robert Orlini
I want to display text in a input box's value field if there is any info in the database. The code I'm trying is: > But I get an error. It seems simple, but I must be missing something I can't see. Any suggestion please? Thanks. Robert O. HWW [Todays Threads] [This Message] [Subscription]

RE: Update price

2004-03-30 Thread Robert Orlini
Application Construction Kit" isbn # 0-321-12516-9    UPDATE bookinfo    SET    percentage = value="#form.percentage#"> ,   discountedprice = price    WHERE  bookid = 4 Ray http:/www.crystalvision.org At 10:50 AM 3/30/2004, Robert Orlini wrote: >I get an error P

RE: Update price

2004-03-30 Thread Robert Orlini
e#"> , discountprice = price WHERE ... Assuming your percentage is numeric. I see you have quotes around it, so mayby it's a varchar (CF_SQL_VARCHAR) Don't forget the WHERE clause or you will update all records in the table > -Original Message- > From: Robert Orlini

Update price

2004-03-30 Thread Robert Orlini
I have a query in an action page where I set a column to 0 (from a form) and update discountedprice to the same value as price. Here is the code: Update bookinfo SET percentage = '#form.percentage#' SET 'discountedprice' = 'price' I'm kinda a newy to all this so of course it doesn't work. I g

RE: Max id

2004-03-29 Thread Robert Orlini
fused.  It sounds like your want the max(id) whether or not it's the latest modified.  Or are you saying they have the exact same time?  Sounds like your database isn't quite what it should be unless I'm missing something here. John -Original Message- From: Robert Orlini

FW: Max id

2004-03-26 Thread Robert Orlini
m status Order by datechanged desc That will put the newest one on top and return only the top row.  Am I missing something? John -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Thursday, March 25, 2004 3:44 PM To: CF-Talk Subject: RE: Max id Thanks Tony,...only now I

FW: Max id

2004-03-26 Thread Robert Orlini
m status Order by datechanged desc That will put the newest one on top and return only the top row.  Am I missing something? John -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Thursday, March 25, 2004 3:44 PM To: CF-Talk Subject: RE: Max id Thanks Tony,...only now I

RE: Max id

2004-03-25 Thread Robert Orlini
CTED] Sent: Thursday, March 25, 2004 3:24 PM To: CF-Talk Subject: RE: Max id try this... Select TOP 1 MAX(ID), side_1_comments from status where datechanged = '#DateFormat(Now(), "mm/dd/")#' group by side_1_comments order by id DESC tw -Original Message- From

Max id

2004-03-25 Thread Robert Orlini
I have a table that will be updated daily. In the table I want to select info from the latest record even if it is today's date. I used MAX(ID) to get the latest record. Is that good or am I going about this wrong? So far it doesn't seem to do that with my script below: Select MAX(ID), side_1_co

date dropdown

2004-03-19 Thread Robert Orlini
Anyone out there know where I can find a CF or _javascript_ date drop down with day, month, year that a user can select from and send to a form? Thanks. Robert O. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Order by date and then time

2004-03-15 Thread Robert Orlini
I would like to order first by datechanged and then by the time it was changed. I have so far this code: Select * from statuslog Order by datechanged desc It orders correctly by date changed. For example, if multiple changes were made today, 3/15/2004, how do I then tell it to order by the tim

Incorrect syntax near...

2004-03-12 Thread Robert Orlini
In this SQL script below I get the following error: "Incorrect syntax near '='." I've tried #form.custommessage# in single quotes, double quotes and no quotes, but still it won't work though it displays the text in the debug. This is the error above "ODBC Error Code = 37000 (Syntax error or access

SOT: Distinct

2004-03-08 Thread Robert Orlini
SELECT distinct email, customerid FROM customers Where customer != 'test' Order by customerid desc In the above Query, how do I distinct just the email and not the customerid. Because of the Order by SQL requires me to put customer id in the Distinct part of Select. This throws things off since

RE: Infusion

2004-03-05 Thread Robert Orlini
Thanks Michael, One more thing, with CFMX I heard there is no more CF Studio and I have to purchase Dreamweaver or another Macromedia product? Robert O. -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Friday, March 05, 2004 3:19 PM To: CF-Talk Subject: Re: I

Infusion

2004-03-05 Thread Robert Orlini
Anyone out there using Infusion Mail Server for their CF apps as opposed to CFMail? We want to create a email list of users that would be informed of the status of our website. I believe CFMail may have a problem with sending out more than 100 or 200 emails at a time. Would this package help us?

RE: populating dropdowns

2004-03-01 Thread Robert Orlini
The trim function fixed everything in this part: Select * from admin Where username = '#trim(session.username)#' and here as well: Custom Status Message But as always I do appreciate the quick and helpful responses. Robert O. -Original Message- From: Bryan F. Hogan [mailt

populating dropdowns

2004-03-01 Thread Robert Orlini
I'm trying to restrict an option on a dropdown from appearing based on the users priority. I have the code below which does not generate any errors but will not display the "Custom Message" option when the priority is the correct one. What am I missing here please? Select one of six messages from

RE: auto history

2004-02-26 Thread Robert Orlini
Worked great... Thanks Barney and Jeff Robert O.! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, February 26, 2004 1:21 PM To: CF-Talk Subject: Re: auto history   <br>     history.go(-1);<br>    On 26 Feb 2004 at 13:12, Robert

auto history

2004-02-26 Thread Robert Orlini
This seems easy but it doesn't click right now. I want an automatic history done within CFIF See code: I know the HREF in there does not belong, what is the correct JS coding there so that the CFIF detects the condition and goes right back to the page w/o the user "clicking" anything. Thx Ro

OT; JavaScript auto go back

2004-02-25 Thread Robert Orlini
Anyone know what is the _javascript_ to have an "automatic" history to the previous page. I know the ones with a href and a GO BACK link you click on, but is there one that redirects or historys to the previous page? Thx. Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast U

RE: Radio button check

2004-02-25 Thread Robert Orlini
Thanks Matt. Your script and a few tweaks from me and everything looks good. Robert O. -Original Message- From: Plunkett, Matt [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 25, 2004 10:10 AM To: CF-Talk Subject: RE: Radio button check -Original Message- From: Robert

OT: Radio button check

2004-02-25 Thread Robert Orlini
How do I check whether a certain value is checked off on a radio button? The group name is "send". The value I want checked is whether it is "sendemail". If it is I want an alert to ask that the subject is required. Thx. Robert O. Here is part of what I have so far: if((form.send.value).checke

RE: Passing form info via image map

2004-02-18 Thread Robert Orlini
Director www.cfug-vancouverisland.com   - Original Message -   From: Robert Orlini   To: CF-Talk   Sent: Wednesday, February 18, 2004 12:12 PM   Subject: OT: Passing form info via image map   Is there any way to use an image map to pass info onto a form similar to a submit button? I

OT: Passing form info via image map

2004-02-18 Thread Robert Orlini
Is there any way to use an image map to pass info onto a form similar to a submit button? I'm trying to accomplish this by passing variables. See part of my code below and let me know if any have done this better or different please. Thanks.   Robert O. HWW [Todays Threads] [This Me

RE: textarea field limit

2004-02-17 Thread Robert Orlini
many characters they had left to type as they are typing. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 17, 2004 8:37 AM To: CF-Talk Subject: RE: textarea field limit Thanks John. I'm new to _javascript_ some what. Is the "199" the li

RE: textarea field limit

2004-02-17 Thread Robert Orlini
-----Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 17, 2004 8:28 AM To: CF-Talk Subject: textarea field limit Is there any way to limit how much text is put into a textarea field via a form? I want to prevent too many characters from being typed in similar t

textarea field limit

2004-02-17 Thread Robert Orlini
Is there any way to limit how much text is put into a textarea field via a form? I want to prevent too many characters from being typed in similar to the maxlength field in a onle line text box. Thx. Robert O. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settin

RE: image map

2004-02-13 Thread Robert Orlini
:33 AM To: CF-Talk Subject: RE: image map ok, how about all the code associated? -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Friday, February 13, 2004 10:24 AM To: CF-Talk Subject: RE: image map Can't -- it's only on development. RO -Original

RE: image map

2004-02-13 Thread Robert Orlini
riginal Message----- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Friday, February 13, 2004 10:11 AM To: CF-Talk Subject: RE: image map Just did..Mike to no avail. RO -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Friday, February 13, 2004 10:09 AM To: CF-Talk Sub

RE: image map

2004-02-13 Thread Robert Orlini
Just did..Mike to no avail. RO -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Friday, February 13, 2004 10:09 AM To: CF-Talk Subject: Re: image map Have you tried it without any # signs?   - Original Message -   From: Robert Orlini   To: CF-Talk   Sent

OT: image map

2004-02-13 Thread Robert Orlini
This is OT sorry. But I have a CF pop-up page and I'm using an image map code for a close button located on an image (used FP 200 for this). It doesn't seem to work. The code is: I escaped the pound signs at the closing FPmap0 so it looked like "##FPMap0", but it still does not work or even di

OT: Prevent Refresh

2004-02-11 Thread Robert Orlini
Is there any way to disable the Refresh button or option or prevent a user from refreshing a page? It's causing some problems with our CF coding and sending out multiple emails. Is there a way in _javascript_ or CF? Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscr

RE: Trim in cfoutput

2004-02-10 Thread Robert Orlini
Thanks all for your QUICK suggestions. Sometimes its too easy but your thinking too ahead of the game. Robert O. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 10, 2004 9:32 AM To: CF-Talk Subject: RE: Trim in cfoutput Change it to #trim(geti

Trim in cfoutput

2004-02-10 Thread Robert Orlini
How do I apply the trim function in a CFOUTPUT? I have: Trim(#getinfo.trialname#).htm. (Maybe it should be in cfoutput--not sure on this) It's probably wrong I figure. I need the ".htm" to appear right after the "getinfo.trialname" so it can be clicked directly to a html page. Right now it just d

wireless apps

2004-01-22 Thread Robert Orlini
Anyone out there fooled around with CF and wireless applications? I'm looking at the info in the current CF 5.0 book. Can it be programmed to send a page to a phone if a service is down? Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: OT radio button validation

2004-01-21 Thread Robert Orlini
Thanks Christian and others who gave their valuable 2 cents or minutes! -Original Message- From: Christian Cantrell [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 2:30 PM To: CF-Talk Subject: Re: OT radio button validation On Wednesday, January 21, 2004, at 01:04  PM, Robert

OT radio button validation

2004-01-21 Thread Robert Orlini
Anyone have a quick _javascript_ code top check if a certain radio button is selected then a input field must have content? The buttons are grouped as "paymentmethod". One is "credit card" and one is "purchase order". The input field "ponumber" must have content if "purchase order" radio button is

loop thru tables

2004-01-20 Thread Robert Orlini
I have a number of tables in one Access datasource. How would I loop thru all of them and search the expire date field? Robert Orlini HW Wilson 718-588-8400 x2656 ô¿ô [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

<    1   2   3   4   5   >