RE: Access SQL stored procs

2002-06-03 Thread JAIME HOI
I found out where the error comes from. For MSSQL , when we are passing in as Numeric field, they do not accept empty string. Must pass in a zero if it is empty string then can avoid the error message. BUt for oracle, its fine. Contentment is not the fulfillment of what you want, it is the

Problem with form submittal

2002-06-03 Thread Constanty DeCinko III
I have the following code in a navigation frame that submits a form in another frame: span tabIndex=5 ACCESSKEY=s style=text-decoration:none; cursor:hand onfocus=parent.FormDetail.main.submit()font color=#FFstronguS/uubmit Order/strong/font/span The problem is, the onSubmit of the form is

RE: IE 6.0 Bug ... style sheet bug ... looking for workaround

2002-06-03 Thread Brian Scandale
Tried that... and a zillion other things too. ;-( Are you running IE 6.0 and see the problem?? At 11:09 PM 6/2/02 -0700, you wrote: Brian, Try adding a pound sign before the rgb color value. background: #66; Robert -Original Message- From: Brian Scandale

RE: IE 6.0 Bug ... style sheet bug ... looking for workaround

2002-06-03 Thread LANCASTER, STEVEN M. (JSC-OL) (BAR)
Have you checked MS site for a possible fix? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 1:48 AM To: CF-Talk Subject: RE: IE 6.0 Bug ... style sheet

RE: IE 6.0 Bug ... style sheet bug ... looking for workaround

2002-06-03 Thread Robert Obreczarek
Brian, Nope, I just noticed the missing pound sign. I know Netscape has problems with that. As for IE 6, I'm not planning to upgrade. I've heard too many complaints about it (same goes for NN 6). I'm pretty comfortable with ie 5.5 sp2. Sorry I can't be much more helpful. Robert -Original

Re: Problem with form submittal

2002-06-03 Thread Justin Scott
You might create a function in the navigation area that the span calls instead. This function would replicate the onsubmit code, as well as the submit code if the checkrequired returns ok. -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com - Original

RE: ColdFusion MX / Studio MX now available!

2002-06-03 Thread Andrew Scott
I have to ask one stupid question to MM. With the MX suite of applications, why is it that everything else, Dreamweaver MX, Flash MX go into the macromedia folder on the startup menu. But CFMX has to have its own folder? Nit picking, yes... But it would have made better sense to keep everything

Re: ColdFusion MX / Studio MX now available!

2002-06-03 Thread Justin Scott
With the MX suite of applications, why is it that everything else, Dreamweaver MX, Flash MX go into the macromedia folder on the startup menu. But CFMX has to have its own folder? Nit picking, yes... But it would have made better sense to keep everything together, and not like this!

Re: File Browse buttons with input type=file

2002-06-03 Thread Jon Hall
Yes, but it's such a pain that I usually write it off as not worth it. A file input object in IE (only IE, there is an RFE for Mozilla support) has a click method that will simulate a user click and bring up the file browser.

Create dropdown selection from external files

2002-06-03 Thread phumes1
Hi, I have the following list from an external file that is being creating with the cfexecute tag. What I would like to do (but not sure how) is to grab the page numbers from the list ONLY and include them in the select tag. Here is a snippet from the external file. This could be a few lines

GetLinks tag - ignoring class attrib

2002-06-03 Thread W Luke
Hi, I'm using the GetLinks tag in the gallery, but need to modify the following REFindNoCase line so that it *ignores* anchor tags containing the class attribute, eg a class=a href=link.cfmHello/a objMatch = REFindNoCase((A|FRAME)[[:space:]]+[^]*(HREF|SRC) ?=

CF5 and CFMX on the same machine

2002-06-03 Thread Kola Oyedeji
Hi Does anyone know if its possible to run CF5 and the trial version of CFMX on the same machine? Also is it possible for them both to use iis as the webserver? Thanks Kola __ Get the mailserver that powers this list at

Re: CF5 and CFMX on the same machine

2002-06-03 Thread Critz
oi Kola!! yes. cfmx will give you that option on install. It runs on a separate port. -- Best regards, Critter, MMCP Certified ColdFusion Developer Crit[s2k] - CF_ChannelOp Network=EFNet Channel=ColdFusion Monday, June 3, 2002, 7:36:05 AM, you

Re: CF5 and CFMX on the same machine

2002-06-03 Thread Yves Arsenault
Thanks guys, that was a question I was about to ask! :-) Yves - Original Message - From: Critz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 03, 2002 9:16 AM Subject: Re: CF5 and CFMX on the same machine oi Kola!! yes. cfmx will give you that option on

Re: Create dropdown selection from external files

2002-06-03 Thread Seth Petry-Johnson
I have the following list from an external file that is being creating with the cfexecute tag. What I would like to do (but not sure how) is to grab the page numbers from the list ONLY and include them in the select tag. Here is a snippet from the external file. This could be a few lines or

Re: Create dropdown selection from external files

2002-06-03 Thread phumes1
I don't recall receiving your email. I probably deleted it by accident. Your code worked great. Thanks Seth At 08:23 AM 6/3/2002 -0400, you wrote: I have the following list from an external file that is being creating with the cfexecute tag. What I would like to do (but not sure how) is

RE: Create dropdown selection from external files

2002-06-03 Thread Timothy Heald
You could also treat it like two lists right? !--- read in the file --- CFFILE ACTION=READ FILE=#TheFolder#\page-results.log VARIABLE=sIn !--- use this variable for your line delimiter weather it be char(10) or whatever --- CFSET delimiter = char(10) !--- create the array to hold the page

RE: Problem with form submittal

2002-06-03 Thread Constanty DeCinko III
Thanks. That seems to work. Not sure why the other did not, but moving the location of the function seems to do the trick. -Original Message- From: Justin Scott [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 12:47 AM To: CF-Talk Subject: Re: Problem with form submittal You

Re: Create dropdown selection from external files

2002-06-03 Thread Seth Petry-Johnson
You could also treat it like two lists right? You could definately use the list functions to loop through line by line (using a CRLF as the delimiter as your code did), but you would encounter two main problems with parsing out the line numbers: 1) Not every line in the file contains the same

How to get MX to process .html files???

2002-06-03 Thread Justin Hansen
I have a lot of cf code in .html files and have been doing so since version CF 4.0, by pointing the .html extension to the iscf.dll in IIS. How can I get MX to do the same thing? Or do I have to rename all my files? Justin Hansen -- Uhlig Communications Web Developer /

Rumor of lay-offs

2002-06-03 Thread mynews
Can anyone confirm or deny this: http://comments.fuckedcompany.com/phpcomments/index.php?newsid=87356sid=1pag e=1parentid=0crapfilter=1 BJ ___ Sent by ePrompter, the premier email notification software. Free download at

RE: How to get MX to process .html files???

2002-06-03 Thread Raymond Camden
Just make a new entry in the IIS admin. You should see one for CFM and (probably) one for DBM as well. Just copy it - that should work I would think. (although I didn't actually test it ;) === Raymond Camden, ColdFusion Jedi

RE: File Browse buttons with input type=file

2002-06-03 Thread Ryan Kime
Yes, in your style or CSS file, define the style for INPUT {} and that will get you on the right track. Seems to ignore the color: call, but all of my other settings work on the Browse button. -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 02, 2002 11:55

OT: Outer Join grabbing too many records

2002-06-03 Thread Paul Giesenhagen
cfquery datasource=canadacrew name=listimages SELECT i.id, i.title,i.filename, cm.name FROM images i INNER JOIN image_categories c ON i.id = c.imageid LEFT OUTER JOIN comments cm ON cm.parent_id = i.id AND c.catid = '#variables.catid#' GROUP

RE: Rumor of lay-offs

2002-06-03 Thread Matt Liotta
Yeah, it is true. Although, I think it was less than 20 people. Additionally, I believe they knew well in advance of the release. -Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 6:32 AM To: CF-Talk Subject: Rumor of lay-offs

RE: Rumor of lay-offs

2002-06-03 Thread Stacy Young
Guys why even bother with that board. Just trash talk. SY -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 10:31 AM To: CF-Talk Subject: RE: Rumor of lay-offs Yeah, it is true. Although, I think it was less than 20 people. Additionally, I

RE: Rumor of lay-offs

2002-06-03 Thread Tony_Petruzzi
i have been visiting FC for well over two years now. I must say that they are right on the money about their stories. I have no idea where Pud gets his info, but it's right on target. I personally think you could sell stock based off the information on his site. Just because the news is bad news,

RE: Rumor of lay-offs

2002-06-03 Thread Matt Liotta
Ah, but like all rumors floated on FuckedCompany; there is a nugget of truth behind them. Rumors can be quite useful if taken with a grain of salt. -Matt -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 7:51 AM To: CF-Talk Subject: RE:

RE: CF5 and CFMX on the same machine

2002-06-03 Thread Dave Watts
Does anyone know if its possible to run CF5 and the trial version of CFMX on the same machine? Yes, as several others have mentioned. Also is it possible for them both to use iis as the webserver? Yes, but it'll require a little manual configuration. The way I did it was to install CF MX

tag-updater

2002-06-03 Thread Frank Mamone
I extracted tye cf-tag updater into the root of cfs 4.5 but don't see the new tags. Is there something else I should do? __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the

Re: Outer Join grabbing too many records

2002-06-03 Thread stas
Move your c.catid = '#variables.catid#' into the WHERE clause. - Original Message - From: Paul Giesenhagen [EMAIL PROTECTED] cfquery datasource=canadacrew name=listimages SELECT i.id, i.title,i.filename, cm.name FROM images i INNER JOIN image_categories c ON

Re: Outer Join grabbing too many records

2002-06-03 Thread Dina Hess
I am running this query on MySQL, and the problem is that no matter what #variables.catid# Is, it always brings up every image .. Basically I want to bring up every image that is defined by the 'variables.catid' and if there are comments, display the comments for that image ..(Not every image

Colocation in NYC

2002-06-03 Thread stas
Hello, Can anybody recommend a collocation provider in NYC, preferably within walking distance in midtown? Thanks! __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ:

Re: Outer Join grabbing too many records

2002-06-03 Thread Paul Giesenhagen
Sheesh, can't believe I didn't see that ... but when I do correct it, it does display the images correctly, but my GROUPING Function is not working right now. I am grouping on the id value and the output looks basically like this: !--- Query --- cfquery datasource=canadacrew name=listimages

Re: File Browse buttons with input type=file

2002-06-03 Thread Neil H.
That worked, thanks! Jon this one seems a bit easier :) Neil - Original Message - From: Ryan Kime [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 03, 2002 10:11 AM Subject: RE: File Browse buttons with input type=file Yes, in your style or CSS file, define the

Re: Outer Join grabbing too many records

2002-06-03 Thread Paul Giesenhagen
Dunno .. it is working now ... disreguard! and THANKS for all the help! Paul Giesenhagen QuillDesign - Original Message - From: Paul Giesenhagen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 03, 2002 10:49 AM Subject: Re: Outer Join grabbing too many records

searching large amounts of text

2002-06-03 Thread Cornillon, Matthieu
Hi, everyone. A friend of mine has a bunch of data currently stored in InMagic's DBTextWorks. This data is a series of document records. Each record has several fields with general information (author(s), publication date, etc.) and a field with the body of the document. This last field, of

RESEND: searching large amounts of text

2002-06-03 Thread Cornillon, Matthieu
Hi, everyone. A friend of mine has a bunch of data currently stored in InMagic's DBTextWorks. This data is a series of document records. Each record has several fields with general information (author(s), publication date, etc.) and a field with the body of the document. This last field, of

RE: searching large amounts of text

2002-06-03 Thread Dave Watts
Unfortunately, I know very little about search features in ColdFusion. The best advice (not so good) that I could give him was to have a nightly batch job that would concatenate all fields from a single record and enter it into a single field of a new table. Then it could do a Verity

RE: SQL2000 JDBC Driver and CFMX

2002-06-03 Thread Dave Watts
least in my mind, occurs when you already have a bunch of Windows users and you want to use their accounts as database logins. in a mixed (cf plus other apps) environment this would actually be the norm. I can see it being an issue if you don't have your server set up for mixed-mode

Adobe Java API

2002-06-03 Thread Joseph Thompson
If anyone has had success (or failures I suppose) with the Java API from here: http://www.docfi.com/products/jpdf/jpdf.htm could they let me know? An upcomming project will require some serious PDF manipulation. If anyone has a good dynamic PDF generator (that integrates with CF) feel free to

Re: Adobe Java API

2002-06-03 Thread Howie Hamlin
We use ActivePDF - highly recommended. www.activepdf.com Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the

RE: Colocation in NYC

2002-06-03 Thread Jim Curran
Not near midtown, but I've heard Thorn Communications is great. http://www.thorn.net - j -Original Message- From: stas [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 11:37 AM To: CF-Talk Subject: Colocation in NYC Hello, Can anybody recommend a collocation provider in NYC,

Re: Adobe Java API

2002-06-03 Thread Joseph Thompson
I am evaluating that right now as well. Thanks for the vote of confidence in it! We use ActivePDF - highly recommended. www.activepdf.com __ Your ad could be here. Monies from ads go to support these lists and provide

cfcomet?

2002-06-03 Thread Sarsoun, Jeff
Does anybody know if http://www.cfcomet.com is permanently gone or moved? I'm getting a blank page with no web site is configured at this address printed on it. Jeff __ Get the mailserver that powers this list at

Re: Adobe Java API

2002-06-03 Thread BILL BROWN
I'll second that. We've been using it for over a year and it has worked great. Bill Brown Web Developer Desert Schools Federal Credit Union [EMAIL PROTECTED] 6/3/02 9:34 AM We use ActivePDF - highly recommended. www.activepdf.com Regards, -- Howie Hamlin - inFusion Project Manager

Article on using Excel as a datasource

2002-06-03 Thread Howie Hamlin
I saw this on another list and thought it looked informative: http://www15.brinkster.com/idude/using_excel_file_datasources.htm Enjoy! -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The

CFMX-Linux/Unix

2002-06-03 Thread Jesse Noller
ok, so here's a question... Anyone messing with CFMX on Linux/Unix? Just wondering... Jesse Noller Macromedia Server Development [EMAIL PROTECTED] Wait! We can't stop here! This is bat country! --Fear And Loathing In Las Vegas

CFHTTP limitations?

2002-06-03 Thread Dave Carabetta
Over the past few months, there have been several posts (including a bunch from myself) concerning issues with CFHTTP. I was wondering if some of you who have worked extensively with CFHTTP can shed some light on the current issues/problems/limitations with CFHTTP. Essentially, I have been

RE: CFMX-Linux/Unix

2002-06-03 Thread Matt Liotta
Well you know I am. -Matt -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 10:31 AM To: CF-Talk Subject: CFMX-Linux/Unix ok, so here's a question... Anyone messing with CFMX on Linux/Unix? Just wondering...

RE: CFMX-Linux/Unix

2002-06-03 Thread Jesse Noller
Oh yeah, go ahead and throw me questions/criticism, beer. Except you matt. I don't like you =] /joke -jesse -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 1:44 PM To: CF-Talk Subject: RE: CFMX-Linux/Unix Well you know I am.

dw mx chopping code?

2002-06-03 Thread Andre Turrettini
I'm fiddling with dwmx and was liking it untill I noticed it was chopping off some of my code! I've double checked it so even though I may be smoking something, it seems to be in fact happening on my machine? Anybody noticed this?

Re: CFMX-Linux/Unix

2002-06-03 Thread Alex
yes On Mon, 3 Jun 2002, Jesse Noller wrote: ok, so here's a question... Anyone messing with CFMX on Linux/Unix? Just wondering... Jesse Noller Macromedia Server Development [EMAIL PROTECTED] Wait! We can't stop here! This is bat country! --Fear And

RE: dw mx chopping code?

2002-06-03 Thread Erika L Walker-Arnold
One thing I noticed is do not let it update your links Like when you make a change to a page Name or you delete a file ... If you have any query strings attached to the file name, it will chop them off. I haven't noticed anything else, but I never touch design mode ... Are you using that

RE: CFMX-Linux/Unix

2002-06-03 Thread Jesse Noller
What do you think, impressions, thoughts, etc? -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 1:51 PM To: CF-Talk Subject: Re: CFMX-Linux/Unix yes On Mon, 3 Jun 2002, Jesse Noller wrote: ok, so here's a question... Anyone messing

datetime formatting

2002-06-03 Thread Bosky, Dave
I need to insert the current date and time into a table whenever a record is created. How would I format the current date and time in the following format using ASP? -MM-DD HH:MM:SS I'm not sure of the proper function in ASP to accomplish this task. Thanks, Dave

Re: datetime formatting

2002-06-03 Thread Dina Hess
dave, since asp uses both javascript and vbscript, we'll need to know which of those scripting languages you are using to help. ~ dina - Original Message - From: Bosky, Dave [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 03, 2002 1:33 PM Subject: datetime

RE: datetime formatting

2002-06-03 Thread Tony_Petruzzi
forget ASP! do it right from the database with a default on the column. in access use now() in the default field and in MSSQL, use getdate(). Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]]

RE: datetime formatting

2002-06-03 Thread Tony Carcieri
If you are using Access you could specify NOW() in the format section other wise I would do this: cfset SubmitDate = CreateODBCDateTime(Now()) and then insert it into your DB -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:33 PM To: CF-Talk

RE: datetime formatting

2002-06-03 Thread Bosky, Dave
Sorry. vbscript. Dave -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:34 PM To: CF-Talk Subject: Re: datetime formatting dave, since asp uses both javascript and vbscript, we'll need to know which of those scripting languages you are

RE: datetime formatting

2002-06-03 Thread Ken Wilson
Would you not be better off letting the database handle that itself so that you don't have to worry with it? Ken -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:33 PM To: CF-Talk Subject: datetime formatting I need to insert the current

RE: CFMX-Linux/Unix

2002-06-03 Thread Matt Liotta
I haven't upgraded to final yet, but I hope that the case sensitivity bug and installer have been fixed. You know my gripes with the installer. -Matt -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 10:51 AM To: CF-Talk Subject: RE:

Re: datetime formatting

2002-06-03 Thread Dina Hess
that'll work... ~ dina - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 03, 2002 1:38 PM Subject: RE: datetime formatting forget ASP! do it right from the database with a default on the column. in access use now() in the default field and

RE: datetime formatting

2002-06-03 Thread Bosky, Dave
I'm using mySQL with a datetime field. Thanks, Dave Bosky -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:39 PM To: CF-Talk Subject: RE: datetime formatting forget ASP! do it right from the database with a default on the column. in

Sum Help

2002-06-03 Thread Kris Pilles
Ok.. I;ve got myself confused here... I have a table that has some numbers lets say 5 records (50, 45, 33, 23, 12) now I want to be able to select * from that table (not a problem). But I need to sum those numbers so that I can output sum(50+45+33+23+12)... How can I do this??? Is there an

RE: datetime formatting

2002-06-03 Thread Joshua Tipton
dim mydate, mytime, timedate, final set mydate = date set mytime = time set timedate = mydate mytime set final = formatdatetime(timedate, 0) Not sure if this will work pulled it out of my head and pulled the other from a vbscript help file. Josh FormatDateTime Function Returns an expression

RE: Sum Help

2002-06-03 Thread Joshua Tipton
select sum(column) as sumofcolumn from table -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:48 PM To: CF-Talk Subject: Sum Help Ok.. I;ve got myself confused here... I have a table that has some numbers lets say 5 records (50, 45, 33,

RE: datetime formatting

2002-06-03 Thread Tony Carcieri
Tony, Doesn't getDate() consistently return the same date/time no matter how many recs are inserted? I found that in SQL. If I used getdate() and I inserted 10 records, each had the same date/time even though I submitted them at different intervals. Just need a clarification on this. Thanks,

RE: datetime formatting

2002-06-03 Thread Tony Carcieri
Just a note Dave, VBScript only lets you use US English date format (ie mm/dd/) even if your locale settings are different. I also believe you need ## signs around the date. Thanks, Tony -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002

Re: datetime formatting

2002-06-03 Thread Dina Hess
getting back to the database solution...try now(); i think that works in mysql, too. ~ dina - Original Message - From: Bosky, Dave [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 03, 2002 1:44 PM Subject: RE: datetime formatting I'm using mySQL with a datetime

Re: Sum Help

2002-06-03 Thread Dina Hess
also, since you are trying to project all columns plus the aggregate, you will need to list all non-aggregate columns in a group by: example: select column_1,column_2, ..., count(column2) as myCount from myTable group by column_1, column_2... ~ dina - Original Message - From: Joshua

RE: datetime formatting

2002-06-03 Thread Bosky, Dave
I thought you only use # signs w/access. I guess I could get the current year,month,day,hour,minute,second, and piece them together in the format I need but its kind of ghetto style. I just thought there was A function. I sure miss CF :) Thanks, Dave Bosky -Original Message- From:

Re: datetime formatting

2002-06-03 Thread Dina Hess
I also believe you need ## signs around the date. not true...you're thinking of ms access take a look at this link to mySQL date/time functions: http://www.mysql.com/doc/D/a/Date_and_time_functions.html ~ dina __ Structure

Members Only section

2002-06-03 Thread Ernie Pena
Whats the best way to handle security on a members section wouldsomthing like this work? Application.cfm w/cookies set to expire in1 hour, or some other means please advise. Here is what kind of box I have, Windows 2K SQL 2K CF5 1gig or ram 36 gig scsi dule PIII 933 Thanks in advanced Ernie

RE: datetime formatting

2002-06-03 Thread Tony_Petruzzi
might be inserting the value yourself from a storedprocedure then. The default will only be used when the user hasn't specified a value. example: you are insert the datetime yourself DECLARE @mytime datetime, @title varchar(50) SET @mytime = getdate() SET @title = 'this is a

if value exists, show it

2002-06-03 Thread trey
I simply want to test to see if a variable has a value (eg text has been returned from a query) and if so, show it. There seem to be a few options -- cfif isdefined(#variable#) #variable# /cfif or cfif len(#variable#) GT 0 #variable# /cfif or cfif #variable# IS

Re: CFMX-Linux/Unix

2002-06-03 Thread Dick Applebaum
Hey Jesse Yes, I am messing with MX Linux as part of the articles I am writing to get CF MX working on OS X. I just got the trial installed and ported across, JRun and ColdFusion are running... but still no luck with the processes started by the cfusion C++ program Dick On Monday, June

RE: if value exists, show it

2002-06-03 Thread Raymond Camden
This is wrong on multiple counts. First, isDefined takes a string. Ie, you should do: cfif isDefined(variable) #variable# /cfif If youdo, isDefined(#variable#) you are saying, If variable is foo, tell me if I have a variable called foo. What you really want is Tell me if I have a

RE: Sum Help

2002-06-03 Thread Cameron Childress
Queries are treated like Arrays in CF. Try this: #ArraySum(QueryName['columname'])# -Cameron - Cameron Childress Sumo Consulting Inc. --- cell: 678-637-5072 aim: cameroncf email: [EMAIL PROTECTED] -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]]

Re: Members Only section

2002-06-03 Thread Shawnea Carter
We use session variables. Pretty straight forward. Shawnea Carter VP Client Services Internet4Associations - Original Message - From: Ernie Pena [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 03, 2002 3:10 PM Subject: Members Only section Whats the best way to

RE: Members Only section

2002-06-03 Thread Tony_Petruzzi
use client variables. cfif NOT Isdefined(client.deptid) OR NOT Isdefined(client.admin) cflocation url=../index.cfm addtoken=No /cfif cfif DateDiff( n, client.LastVisit, now() ) GTE 20 cflocation url=../index.cfm addtoken=No /cfif Anthony Petruzzi Webmaster 954-321-4703 [EMAIL

RE: if value exists, show it

2002-06-03 Thread Jim Curran
My personal favorite version is: cfparam name=variable type=string default= cfif len(variable) neq 0 #variable# /cfif - j -Original Message- From: trey [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 4:08 PM To: CF-Talk Subject: if value exists, show it I simply want

RE: CFMX-Linux/Unix

2002-06-03 Thread Jesse Noller
You won't be able to start the C++ launcher, the only thing you could possibly do is find the i386/Linux emulation libs (if they exist) for os/x to use the launcher, same for verity -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 3:08

Re: if value exists, show it

2002-06-03 Thread Bryan Stevenson
If the variable is always defined, but may not have a value then use: cfif len(variable) #variable# /cfif NOTE: 1) you do not need to use ## around the variable name in the CFIF tag 2) you do not need GT 0 (instead do a boolean check - if variable has a length it will be true...if not it

RE: if value exists, show it

2002-06-03 Thread Wallick, Mike
Personally, I use the ValueOrSpace() UDF from http://www.cflib.org. cfif Len(variable) is one I use quite often as well. I use ValueOrSpace() when say, populating a table from a db query, and Len(variable) when I'm deciding to do one thing or another with processing (like form processing). Mike

Re: if value exists, show it

2002-06-03 Thread Bryan Stevenson
oops...my badmy second example's syntax is wronglisten to Ray ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner

Re: SQL2000 JDBC Driver and CFMX

2002-06-03 Thread Paul Hastings
It doesn't buy you much as far as functionality, but it's a nice feeling to simply deny a user the right to run arbitrary SQL, from a security perspective. yes but we're all religously applying cfqueryparam...and handling lists, etc is a royal pain. --- Outgoing mail is certified Virus

RE: datetime formatting

2002-06-03 Thread Tony Carcieri
thanks for the clarification. Thanks, Tony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 3:10 PM To: CF-Talk Subject: RE: datetime formatting might be inserting the value yourself from a storedprocedure then. The default will only be

Re: if value exists, show it

2002-06-03 Thread Dina Hess
trey, this seems to be the most widely accepted way of doing that: !--- define the variable with an empty string to keep code from breaking if it's not defined --- cfparam name=variable type=whatever default= !--- check to see if the variable has a length. if yes, display it --- cfif

Re: if value exists, show it

2002-06-03 Thread Dina Hess
lol. screwed up the syntax...you don't need to enclose variable with # in the cfif tag. ~ dina - Original Message - From: Dina Hess [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 03, 2002 2:22 PM Subject: Re: if value exists, show it trey, this seems to be the

Re: if value exists, show it

2002-06-03 Thread Justin Scott
Hi Trey! I simply want to test to see if a variable has a value (eg text has been returned from a query) and if so, show it. There seem to be a few options -- cfif isdefined(#variable#) #variable# /cfif As Raymond already pointed out, isDefined() takes a string as the input and returns a

Re: Sum Help

2002-06-03 Thread Dina Hess
just curious... isn't it more efficient to have the database perform this calc? ~ dina - Original Message - From: Cameron Childress [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 03, 2002 2:17 PM Subject: RE: Sum Help Queries are treated like Arrays in CF. Try

RE: Members Only section

2002-06-03 Thread Kris Pilles
Ernie: Why don't you have the cookie set to expire on the session... That way when the user closes the browser their session is over and they would have to log back in... Login action: !---Lookup the login in the database --- CFQUERY NAME=IsValidLogin DATASOURCE=#session.DSN# SELECT * FROM

Re: if value exists, show it

2002-06-03 Thread Terry
If you're wanting to know if it was returned from a query.. cfif queryname.recordcount #variable# /cfif *** REPLY SEPARATOR *** On 6/3/02 at 1:08 PM trey wrote: I simply want to test to see if a variable has a value (eg text has been returned from a query) and if

Re: Members Only section

2002-06-03 Thread Alex
Depends on you and what you want. Cookies, sessions, htaccess, OS authenticatio, and anything else all work with pluses and minuses. I use cookies or sessions; it's simple and works. On Mon, 3 Jun 2002, Ernie Pena wrote: Whats the best way to handle security on a members section wouldsomthing

RE: if value exists, show it

2002-06-03 Thread Chris Lofback
I like using CF's short circuit logic (introduced in 4.5, I think?) like this: CFIF IsDefined(variable) AND Len(Variable) #variable# /CFIF Evaluation is sequential in the CFIF. This way, you only show the variable if it exists and is not empty. Something similar can be done with

RE: if value exists, show it

2002-06-03 Thread Chris Lofback
Well, this only tells you if any records were returned, not if a particular field in a record is empty... Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: Terry [mailto:[EMAIL PROTECTED]] Sent: Monday,

Installing on XP machine

2002-06-03 Thread Andy Ousterhout
I am try to install CF-Studio on computer running XP-Home and can't find IIS. I remember seeing a thread on this a while back and couldn't locate it in the archives. Does any know if I can install on machine with XP-Home and if so, where do I find web-server. Thanks Andy

RE: dw mx chopping code?

2002-06-03 Thread Raymond Camden
Can you elaborate? I'm trying to test this but can't reproduce it. I have: a href=test.cfm?x=1y=1test/a I can modify the URL params with no problems. === Raymond Camden, ColdFusion Jedi Master for Macromedia Email: [EMAIL

RE: if value exists, show it

2002-06-03 Thread Terry
I thought the question was: snip I simply want to test to see if a variable has a value (eg text has been returned from a query) and if so, show it. /snip *** REPLY SEPARATOR *** On 6/3/02 at 3:44 PM Chris Lofback wrote: Well, this only tells you if any records were

  1   2   >