RE: Access SQL stored procs
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 realization of how much you already have. -Original Message- From: Chris Lofback [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 8:38 PM To: CF-Talk Subject: RE: Access SQL stored procs I've seen errors like this when sending a NUMERIC CF datatype to a BIGINT datatype field. I used to always use NUMERIC for any numeric data (seems like it should work, right?) but I've had the occasional problem with it (mainly in Oracle). If the field datatype is BIGINT, try switching the CFSQLTYPE to CF_SQL_BIGINT instead of CF_SQL_NUMERIC. Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: JAIME HOI [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 2:04 AM To: CF-Talk Subject: RE: Access SQL stored procs In MSSQL it works fine. But when used with coldfusion somehow keep prompting me the error. I check the datatype, it matches. So i am still veri puzzled why is this so. -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 11:17 AM To: CF-Talk Subject: RE: Access SQL stored procs Does it work if you run it directly in Access? -Original Message- From: JAIME HOI [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 8:00 PM To: CF-Talk Subject: RE: Access SQL stored procs hi My stored procedure works fine in Oracle but in MSSQL its not working fine. I wonder why . I get this error Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification Anybody knows why? My stored procedure is CFSTOREDPROC procedure=CHRIS.SP_DECS datasource=#Request.HR_DSN# cfprocparam type=IN cfsqltype=CF_SQL_VARCHAR value=ABCDE cfprocparam type=IN value=13354 cfsqltype=CF_SQL_NUMERIC cfprocparam type=Out variable=curr_slry cfsqltype=CF_SQL_NUMERIC /CFSTOREDPROC -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 25, 2002 4:39 AM To: CF-Talk Subject: RE: Access SQL stored procs It's a normal STOREDPROC implementation: Here's a snippet: cfstoredproc datasource=#request.edatasource# dbtype=ODBC procedure=ecards_dupes_2months cfprocresult name=ecarddupes /cfstoredproc Ian -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 10:31 AM To: CF-Talk Subject: RE: Access SQL stored procs Ok thanks Do you know of any place I can find docs on the syntax? Shawn Regan -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 10:12 AM To: CF-Talk Subject: RE: Access SQL stored procs Yes, we have. It works quite well: You write your query in Access, then use CFSTOREDPROC to access it. Cut the processing time on a few of our pages from over 4 seconds to just under 400 ms. You can also access a query as a table, of course, but then PROCPARAM is right out... Ian -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 10:04 AM To: CF-Talk Subject: OT: Access SQL stored procs Hey CF people, Happy Friday!! Well I have a question about access. I thought I saw something or read something about use the access query objects as stored procs. Has anyone done this and if so can you share? TIA Shawn Regan __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Problem with form submittal
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 being ignored: form action=CompleteOrder.cfm method=post name=main id=main onSubmit=return CheckRequired() Is there anyway to get the span above to act exactly like clicking a submit button on the form? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IE 6.0 Bug ... style sheet bug ... looking for workaround
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 [mailto:[EMAIL PROTECTED]]
Sent: Sunday, June 02, 2002 12:28 PM
To: CF-Talk
Subject: IE 6.0 Bug ... style sheet bug ... looking for workaround
I just installed a large project on a site that is used
exclusively with IE 6.0 and suddenly some very simple text is not
displaying inside forms.
So I hit it with IE 5.5 and all is OK.
I am having trouble with Free Form text that floats above Select
Boxes not displaying unless I drag the scroll bar to force IE to
repaint the screen... the text is there, but not displayed until
the scroll bar drag forces IE to repaint the section as it comes
into view a second time... THIS ONLY happens above the FIRST
Select Box on the page.
I jerked the .css file and put 1 style sheet tag into the header
section to demonstrate the problem. Removing the 'background:
66' from the style sheet solves the problem at the expense of
the entire site design.
Pulled most of my hair out by now.
You can reproduce this BUG with this simple html code below... if
you are running IE 6.0
Any Ideas?? what a workaround might be??
Once again, thanks for Looking at this.
~Brian
--
--
html
head
style type=text/css
!--
FORM { font-family : Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size : 11px;
background : 66;
border : thin outset }
--
/style
/head
body leftmargin=0 topmargin=0
table width=100% cellspacing=0
tr
td
brADDING ITEM DETAIL - CHOOSE A PART TYPE
form name=PartTypeSelect action=index.html method=POST
brstrongSelect Part Type/strongbr
Select name=PartType_ID size=6 align=left
onclick=this.form.submit()
Option value=3BACKLIGHT/Option
Option value=5MILLENIA/Option
Option value=4TETRUS/Option
Option value=2TSUNAMI/Option
/SELECT
br
/form
form action=index.html method=post
input name=Submit type=Submit value=Cancel Action
/form
form name=PartSelect action=index.cfm method=POST
input name=PartType_ID type=Hidden value=2
strongSelect Part/strongbr
Select name=Part_ID size=6 align=top
onclick=this.form.submit()
Option value=2THE FIRST PART NUMBER A THE
FIRST PART NAME/Option
Option value=3TSV C TSUNAMI-VITEX/Option
/SELECT
/form
br
/td
/tr
/table
/body
/html
--
here it is again
--
Perhaps this Exclaimed one (!) one is a readable copy if the
first one formats and displays as a web document in your Email reader.
!html
!head
!style type=text/css
!--
FORM { font-family : Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size : 11px;
background : 66;
border : thin outset }
--
/style
/head
!body leftmargin=0 topmargin=0
table width=100% cellspacing=0
tr
td
brADDING ITEM DETAIL - CHOOSE A PART TYPE
form name=PartTypeSelect action=index.html method=POST
brstrongSelect Part Type/strongbr
Select name=PartType_ID size=6 align=left
onclick=this.form.submit()
Option value=3BACKLIGHT/Option
Option value=5MILLENIA/Option
Option value=4TETRUS/Option
Option value=2TSUNAMI/Option
/SELECT
br
/form
form action=index.html method=post
input name=Submit type=Submit value=Cancel Action
/form
form name=PartSelect action=index.cfm method=POST
input name=PartType_ID type=Hidden value=2
strongSelect Part/strongbr
Select name=Part_ID size=6 align=top
onclick=this.form.submit()
Option value=2THE FIRST PART NUMBER A THE
FIRST PART NAME/Option
Option value=3TSV C TSUNAMI-VITEX/Option
/SELECT
/form
br
/td
/tr
/table
/body
/html
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IE 6.0 Bug ... style sheet bug ... looking for workaround
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 bug ... looking for workaround
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 [mailto:[EMAIL PROTECTED]]
Sent: Sunday, June 02, 2002 12:28 PM
To: CF-Talk
Subject: IE 6.0 Bug ... style sheet bug ... looking for workaround
I just installed a large project on a site that is used
exclusively with IE 6.0 and suddenly some very simple text is not
displaying inside forms.
So I hit it with IE 5.5 and all is OK.
I am having trouble with Free Form text that floats above Select
Boxes not displaying unless I drag the scroll bar to force IE to
repaint the screen... the text is there, but not displayed until
the scroll bar drag forces IE to repaint the section as it comes
into view a second time... THIS ONLY happens above the FIRST
Select Box on the page.
I jerked the .css file and put 1 style sheet tag into the header
section to demonstrate the problem. Removing the 'background:
66' from the style sheet solves the problem at the expense of
the entire site design.
Pulled most of my hair out by now.
You can reproduce this BUG with this simple html code below... if
you are running IE 6.0
Any Ideas?? what a workaround might be??
Once again, thanks for Looking at this.
~Brian
--
--
html
head
style type=text/css
!--
FORM { font-family : Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size : 11px;
background : 66;
border : thin outset }
--
/style
/head
body leftmargin=0 topmargin=0
table width=100% cellspacing=0
tr
td
brADDING ITEM DETAIL - CHOOSE A PART TYPE
form name=PartTypeSelect action=index.html method=POST
brstrongSelect Part Type/strongbr
Select name=PartType_ID size=6 align=left
onclick=this.form.submit()
Option value=3BACKLIGHT/Option
Option value=5MILLENIA/Option
Option value=4TETRUS/Option
Option value=2TSUNAMI/Option
/SELECT
br
/form
form action=index.html method=post
input name=Submit type=Submit value=Cancel Action
/form
form name=PartSelect action=index.cfm method=POST
input name=PartType_ID type=Hidden value=2
strongSelect Part/strongbr
Select name=Part_ID size=6 align=top
onclick=this.form.submit()
Option value=2THE FIRST PART NUMBER A THE
FIRST PART NAME/Option
Option value=3TSV C TSUNAMI-VITEX/Option
/SELECT
/form
br
/td
/tr
/table
/body
/html
--
here it is again
--
Perhaps this Exclaimed one (!) one is a readable copy if the
first one formats and displays as a web document in your Email reader.
!html
!head
!style type=text/css
!--
FORM { font-family : Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size : 11px;
background : 66;
border : thin outset }
--
/style
/head
!body leftmargin=0 topmargin=0
table width=100% cellspacing=0
tr
td
brADDING ITEM DETAIL - CHOOSE A PART TYPE
form name=PartTypeSelect action=index.html method=POST
brstrongSelect Part Type/strongbr
Select name=PartType_ID size=6 align=left
onclick=this.form.submit()
Option value=3BACKLIGHT/Option
Option value=5MILLENIA/Option
Option value=4TETRUS/Option
Option value=2TSUNAMI/Option
/SELECT
br
/form
form action=index.html method=post
input name=Submit type=Submit value=Cancel Action
/form
form name=PartSelect action=index.cfm method=POST
input name=PartType_ID type=Hidden value=2
strongSelect Part/strongbr
Select name=Part_ID size=6 align=top
onclick=this.form.submit()
Option value=2THE FIRST PART NUMBER A THE
FIRST PART NAME/Option
Option value=3TSV C TSUNAMI-VITEX/Option
/SELECT
/form
br
/td
/tr
/table
/body
/html
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IE 6.0 Bug ... style sheet bug ... looking for workaround
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 Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 02, 2002 11:48 PM To: CF-Talk Subject: RE: IE 6.0 Bug ... style sheet bug ... looking for workaround 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 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Problem with form submittal
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 Message - From: Constanty DeCinko III [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 03, 2002 2:29 AM Subject: Problem with form submittal 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 being ignored: form action=CompleteOrder.cfm method=post name=main id=main onSubmit=return CheckRequired() Is there anyway to get the span above to act exactly like clicking a submit button on the form? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ColdFusion MX / Studio MX now available!
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 together, and not like this! -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] Sent: Monday, 3 June 2002 2:39 PM To: CF-Talk Subject: RE: ColdFusion MX / Studio MX now available! How long before we can order the files on CD I wonder :) __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ColdFusion MX / Studio MX now available!
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! Probably because the other applications you mentioned are client programs that end-users will be using, so they would go into a normal program directory. Since ColdFusion is a server application, it should have its own directory off the root. This makes it easier to manage. Since previous versions of CF were also off the root, it would probably cause considerable confusion if they moved it. If it ain't broke, don't fix it, as they say. -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: File Browse buttons with input type=file
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.
http://www.devguru.com/Technologies/ecmascript/quickref/fileupload.html
What you have to do is set the file upload objects visibility to
hidden, and then use a normal button and input tags as replacements,
which of course you can style however you want.
Then add an onclick event handler to the new browse button that fires the hidden file
upload
objects click method, this brings up the file browser.
Finally add an onchange handler to the hidden file upload field which copy's
the file field's value to your custom input field.
Something like this:
function showFile(fText) {
document.getElementById('fTextField').value = fText;
}
function browseFiles() {
document.getElementById('fileField').click();
}
input type=file id=fileField style=display:none onchange=showFile(this.value)
input type=text id=fTextField
input type=button onclick=browseFiles() value=browse
Beware, I just typed that out so it probably wont work. :)
--
jon
Monday, June 3, 2002, 12:54:32 AM, you wrote:
NH Is there a way to apply a style to the buttons on the input type=file
NH buttons?
NH Thanks,
NH Neil
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Create dropdown selection from external files
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 or a few hundred. Depends on the job. external file being read in with cffile action=READ file=#TheFolder#\page-results.log nameconflict=OVERWRITE variable=results = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = S U M M A R Y O F F O L I O S / L E A D = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 001folio: 165 . . . 011.50 points free 002folio: 166 . . . 007.00 points free 003folio: 167 . . . 019.00 points free 004folio: 168 . . . 006.00 points free 005folio: 169 . . . 008.00 points free 006folio: 170 . . . 021.00 points free 007folio: 171 . . . 033.00 points free 008folio: 172 . . . 013.00 points free 009folio: 173 . . . 005.00 points free 010folio: 174 . . . 019.00 points free 011folio: 175 . . . 026.00 points free 012folio: 176 . . . 013.00 points free 013folio: 177 . . . 016.00 points free 014folio: 178 . . . 021.00 points free 015folio: 179 . . . 003.50 points free 016folio: 180 . . . 004.00 points free 017folio: 181 . . . 004.00 points free 018folio: 182 . . . 006.00 points free 019folio: 183 . . . 017.00 points free Here is my select select name=filelist size=5 multiple option value=file#page_number#/option /select +---+ Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] ++ __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
GetLinks tag - ignoring class attrib
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) ?= ?[']?([^[:space:]']+)(|(([']|[[:space:]])[^]*)), BodyText, nextMatch, true); I've hit a brick wall - anyone got any ideas? Thanks Will __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF5 and CFMX on the same machine
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 http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF5 and CFMX on the same machine
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 wrote: KO Hi KO Does anyone know if its possible to run CF5 and the trial version of CFMX on KO the same machine? KO Also is it possible for them both to use iis as the webserver? KO Thanks KO Kola KO __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF5 and CFMX on the same machine
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 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 wrote: KO Hi KO Does anyone know if its possible to run CF5 and the trial version of CFMX on KO the same machine? KO Also is it possible for them both to use iis as the webserver? KO Thanks KO Kola KO __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Create dropdown selection from external files
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 a few hundred. Depends on the job. snip = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = S U M M A R Y O F F O L I O S / L E A D = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 001folio: 165 . . . 011.50 points free 002folio: 166 . . . 007.00 points free snip Last week I sent an answer to your problem to the list and directly to you... did you have troubles with my solution? Here it is again: You can use regular expressions to parse the page number from each line of the file. Here's the code you'll need: !--- read in the file --- CFFILE ACTION=READ FILE=#TheFolder#\page-results.log VARIABLE=sIn !--- create the array of page nums --- CFSET arPages = ArrayNew(1) !--- find lines like 001folio: 165 . . . 011.50 points free --- CFSET strCR = Chr(13) Chr(10) CFSET reLine = ([0-9]+folio:[ ]+)([0-9]+)[::Graph::| ]+(#strCR#)? CFSET stcLine = REFindNoCase(reLine, sIn, 1, True) !--- loop through the line matches, pull out the page number and add it to the array --- CFLOOP CONDITION=#stcLine.pos[1]# NEQ 0 CFSET strLine = Mid(sIn, stcLine.pos[1], stcLine.len[1]) CFSET strPageNum = REReplaceNoCase(strLine, reLine, \2, ALL) CFSET result = ArrayAppend(arPages, strPageNum) !--- get the next match --- CFSET stcLine = REFindNoCase(reLine, sIn, stcLine.pos[1]+stcLine.len[1]-1, True) /CFLOOP !--- you now have an array of the page numbers (arPages) from which you can populate your select box --- CFOUTPUT select name=filelist size=5 multiple CFLOOP INDEX=i FROM=1 TO=#ArrayLen(arPages)# option value=#arPages[i]##arPages[i]#/option /CFLOOP /select /CFOUTPUT I tested everything except the select box building code on my own machine using a text file I created from your email. You should be able to copy and paste the code directly into your application. Hope this helps, Seth Petry-Johnson Argo Enterprise and Associates __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Create dropdown selection from external files
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 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 a few hundred. Depends on the job. snip = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = S U M M A R Y O F F O L I O S / L E A D = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 001folio: 165 . . . 011.50 points free 002folio: 166 . . . 007.00 points free snip Last week I sent an answer to your problem to the list and directly to you... did you have troubles with my solution? Here it is again: You can use regular expressions to parse the page number from each line of the file. Here's the code you'll need: !--- read in the file --- CFFILE ACTION=READ FILE=#TheFolder#\page-results.log VARIABLE=sIn !--- create the array of page nums --- CFSET arPages = ArrayNew(1) !--- find lines like 001folio: 165 . . . 011.50 points free --- CFSET strCR = Chr(13) Chr(10) CFSET reLine = ([0-9]+folio:[ ]+)([0-9]+)[::Graph::| ]+(#strCR#)? CFSET stcLine = REFindNoCase(reLine, sIn, 1, True) !--- loop through the line matches, pull out the page number and add it to the array --- CFLOOP CONDITION=#stcLine.pos[1]# NEQ 0 CFSET strLine = Mid(sIn, stcLine.pos[1], stcLine.len[1]) CFSET strPageNum = REReplaceNoCase(strLine, reLine, \2, ALL) CFSET result = ArrayAppend(arPages, strPageNum) !--- get the next match --- CFSET stcLine = REFindNoCase(reLine, sIn, stcLine.pos[1]+stcLine.len[1]-1, True) /CFLOOP !--- you now have an array of the page numbers (arPages) from which you can populate your select box --- CFOUTPUT select name=filelist size=5 multiple CFLOOP INDEX=i FROM=1 TO=#ArrayLen(arPages)# option value=#arPages[i]##arPages[i]#/option /CFLOOP /select /CFOUTPUT I tested everything except the select box building code on my own machine using a text file I created from your email. You should be able to copy and paste the code directly into your application. Hope this helps, Seth Petry-Johnson Argo Enterprise and Associates __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Create dropdown selection from external files
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 numbers --- cfset arPages = arrayNew(listLen(sIN, delimiter)) !--- add the page numbers to the array --- cfloop from=1 to=#listLen(sIN, delimiter)# index=i cfset temp = listGetAt(sin,i, delimiter) cfset arPages[i] = listGetAt(temp, 1, cfloop Tim -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 8:37 AM To: CF-Talk Subject: Re: Create dropdown selection from external files 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 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 a few hundred. Depends on the job. snip = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = S U M M A R Y O F F O L I O S / L E A D = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 001folio: 165 . . . 011.50 points free 002folio: 166 . . . 007.00 points free snip Last week I sent an answer to your problem to the list and directly to you... did you have troubles with my solution? Here it is again: You can use regular expressions to parse the page number from each line of the file. Here's the code you'll need: !--- read in the file --- CFFILE ACTION=READ FILE=#TheFolder#\page-results.log VARIABLE=sIn !--- create the array of page nums --- CFSET arPages = ArrayNew(1) !--- find lines like 001folio: 165 . . . 011.50 points free --- CFSET strCR = Chr(13) Chr(10) CFSET reLine = ([0-9]+folio:[ ]+)([0-9]+)[::Graph::| ]+(#strCR#)? CFSET stcLine = REFindNoCase(reLine, sIn, 1, True) !--- loop through the line matches, pull out the page number and add it to the array --- CFLOOP CONDITION=#stcLine.pos[1]# NEQ 0 CFSET strLine = Mid(sIn, stcLine.pos[1], stcLine.len[1]) CFSET strPageNum = REReplaceNoCase(strLine, reLine, \2, ALL) CFSET result = ArrayAppend(arPages, strPageNum) !--- get the next match --- CFSET stcLine = REFindNoCase(reLine, sIn, stcLine.pos[1]+stcLine.len[1]-1, True) /CFLOOP !--- you now have an array of the page numbers (arPages) from which you can populate your select box --- CFOUTPUT select name=filelist size=5 multiple CFLOOP INDEX=i FROM=1 TO=#ArrayLen(arPages)# option value=#arPages[i]##arPages[i]#/option /CFLOOP /select /CFOUTPUT I tested everything except the select box building code on my own machine using a text file I created from your email. You should be able to copy and paste the code directly into your application. Hope this helps, Seth Petry-Johnson Argo Enterprise and Associates __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problem with form submittal
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 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 Message - From: Constanty DeCinko III [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 03, 2002 2:29 AM Subject: Problem with form submittal 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 being ignored: form action=CompleteOrder.cfm method=post name=main id=main onSubmit=return CheckRequired() Is there anyway to get the span above to act exactly like clicking a submit button on the form? __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Create dropdown selection from external files
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 format of data, so the list functions would choke on lines that did not contain the folio data (for example, the S U M M A R Y O F F O L I O S / L E A D header). To be safe you'd need to compare each line against a regular expressions anyway to make sure that it is a line you wanted to process, so it just makes sense to use regular expressions from the get-go. 2) Each parseable line contains a string like so: 001folio: 165 . . . 011.50 points free It was my understanding that the posted wanted the 165 part of that string, NOT the 001 part. It looked to me like your code would treat each line as a delimited list and would grab the first element in that list which would be the 001 part. If this WAS the desired result then your function would work great, although I would first validate that the line was well-formed: cfloop from=1 to=#listLen(sIN, delimiter)# index=i cfset temp = listGetAt(sin,i, delimiter) cfif ListLen(temp, ) EQ 2 !--- make sure the line is well-formed --- cfset arPages[i] = listGetAt(temp, 1, /cfif cfloop Regards, Seth Petry-Johnson Argo Enterprise and Associates __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How to get MX to process .html files???
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 / Programmer -- [EMAIL PROTECTED] 913-754-4273 -- __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Rumor of lay-offs
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 http://www.ePrompter.com. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to get MX to process .html files???
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 Master for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Justin Hansen [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 9:30 AM To: CF-Talk Subject: How to get MX to process .html files??? 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? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: File Browse buttons with input type=file
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 PM
To: CF-Talk
Subject: File Browse buttons with input type=file
Is there a way to apply a style to the buttons on the input type=file
buttons?
Thanks,
Neil
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Outer Join grabbing too many records
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 BY i.id, i.title,i.filename, cm.name ORDER BY i.postdate desc, i.title /cfquery 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 has comments, some have 1 some have 10). My output will be something like this: FILENAME1 (comments: 0) FILENAME2 (comments:2) FILENAME3 (comments 0) FILENAME4 (comments1) ect... Thank you Paul Giesenhagen QuillDesign __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Rumor of lay-offs
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 Can anyone confirm or deny this: http://comments.fuckedcompany.com/phpcomments/index.php?newsid=87356sid =1 pag e=1parentid=0crapfilter=1 BJ ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Rumor of lay-offs
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 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 Can anyone confirm or deny this: http://comments.fuckedcompany.com/phpcomments/index.php?newsid=87356sid =1 pag e=1parentid=0crapfilter=1 BJ ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Rumor of lay-offs
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, doesn't make it trash. If you were working at MM right now, information like that would be priceless. you could start looking for a new job before everyone else. how is that trash? Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 10:51 AM To: CF-Talk Subject: RE: Rumor of lay-offs 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 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 Can anyone confirm or deny this: http://comments.fuckedcompany.com/phpcomments/index.php?newsid=87356sid =1 pag e=1parentid=0crapfilter=1 BJ ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Rumor of lay-offs
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: Rumor of lay-offs 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 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 Can anyone confirm or deny this: http://comments.fuckedcompany.com/phpcomments/index.php?newsid=87356sid =1 pag e=1parentid=0crapfilter=1 BJ ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF5 and CFMX on the same machine
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 as a standalone server, then create one virtual server just for CF MX, and create a connector using the command-line interface: c:\cfusionmx\runtime\bin\wsconfig It can be run as a command-line tool by specifying the appropriate arguments, or if you don't specify any, it'll provide a GUI. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
tag-updater
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 community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Outer Join grabbing too many records
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 i.id = c.imageid LEFT OUTER JOIN comments cm ON cm.parent_id = i.id AND c.catid = '#variables.catid#' GROUP BY i.id, i.title,i.filename, cm.name ORDER BY i.postdate desc, i.title /cfquery 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 has comments, some have 1 some have 10). __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Outer Join grabbing too many records
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 has comments, some have 1 some have 10). == paul, your table joins should be inner joins since you only want to return records that match your join criteria. also the filter c.catid = '#variables.catid#' isn't working because you are using AND rather than WHERE. and i assume c.catid is a string, since you have #variable.catid# enclosed in single quotes. that's all i see so i would try this: cfquery datasource=canadacrew name=listimages SELECT i.id, i.title, i.filename, cm.name FROM images i INNER JOIN comments cm ON i.id = cm.parent_id INNER JOIN image_category c ON c.catid = i.id WHERE c.catid = '#variables.catid#' GROUP BY i.id, i.title,i.filename, cm.name ORDER BY i.postdate desc, i.title /cfquery ~ dina p.s. you may want to consider buying a reference book called sam's teach yourself sql in 10 minutes - second edition. it's available on forta's site: http://www.forta.com/books/0672321289/, and i'm sure you can also find it thru any major book outlet. i haven't read it myself, but others on this list have given it an enthusiastic 'thumbs up.' __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Colocation in NYC
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: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Outer Join grabbing too many records
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 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 WHERE c.catid = '#variables.catid#' GROUP BY i.id, i.title,i.filename, cm.name ORDER BY i.postdate desc, i.title /cfquery !--- Output grouping on ID, count the comments --- cfoutput query=listimages group=id cfset variables.comment_count = -1 cfoutputcfset variables.comment_count = variables.comment_count + 1/cfoutput Comments (#variables.comment_count#) /cfoutput If there are 10 comments, it just shows a 1 instead of a 10 for variables.comment_count. Thank You Paul Giesenhagen QuillDesign - Original Message - From: stas [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 03, 2002 10:25 AM Subject: Re: Outer Join grabbing too many records 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 i.id = c.imageid LEFT OUTER JOIN comments cm ON cm.parent_id = i.id AND c.catid = '#variables.catid#' GROUP BY i.id, i.title,i.filename, cm.name ORDER BY i.postdate desc, i.title /cfquery 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 has comments, some have 1 some have 10). __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: File Browse buttons with input type=file
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 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 PM
To: CF-Talk
Subject: File Browse buttons with input type=file
Is there a way to apply a style to the buttons on the input type=file
buttons?
Thanks,
Neil
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Outer Join grabbing too many records
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 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 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 WHERE c.catid = '#variables.catid#' GROUP BY i.id, i.title,i.filename, cm.name ORDER BY i.postdate desc, i.title /cfquery !--- Output grouping on ID, count the comments --- cfoutput query=listimages group=id cfset variables.comment_count = -1 cfoutputcfset variables.comment_count = variables.comment_count + 1/cfoutput Comments (#variables.comment_count#) /cfoutput If there are 10 comments, it just shows a 1 instead of a 10 for variables.comment_count. Thank You Paul Giesenhagen QuillDesign - Original Message - From: stas [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 03, 2002 10:25 AM Subject: Re: Outer Join grabbing too many records 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 i.id = c.imageid LEFT OUTER JOIN comments cm ON cm.parent_id = i.id AND c.catid = '#variables.catid#' GROUP BY i.id, i.title,i.filename, cm.name ORDER BY i.postdate desc, i.title /cfquery 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 has comments, some have 1 some have 10). __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
searching large amounts of text
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 course, is rather enormous compared to the other fields. His current tool works very well for this particular application. Looking into the future, though, he is starting to think that it might be wise for him to consider moving it all into ColdFusion with an Oracle back end. He came to me to ask whether I had any ideas. 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 index of this single column, allowing advanced searching across the record. He wondered whether there was a better way, and specifically whether there was a better way to do live queries without this sort of nightly batch job. His initial stab, an extremely complicated SQL statement, was prohibitively slow. So I'm writing to you all to find out if there is a better way. I don't want anyone to solve the problem; that's too much to ask. But if anyone can suggest some places where my friend might look, some ideas that he might search on for reading, he and I would be very grateful. To better define the issue, here are some pretend, but more or less accurate, details: approx. 120,000 records single table: GeneralInformationColumn1 50 characters GeneralInformationColumn1 50 characters GeneralInformationColumn1 50 characters GeneralInformationColumn1 50 characters GeneralInformationColumn1 50 characters GeneralInformationColumn1 50 characters GeneralInformationColumn1 50 characters GeneralInformationColumn1 50 characters __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RESEND: searching large amounts of text
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 course, is rather enormous compared to the other fields. His current tool works very well for this particular application. Looking into the future, though, he is starting to think that it might be wise for him to consider moving it all into ColdFusion with an Oracle back end. He came to me to ask whether I had any ideas. 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 index of this single column, allowing advanced searching across the record. He wondered whether there was a better way, and specifically whether there was a better way to do live queries without this sort of nightly batch job. His initial stab, an extremely complicated SQL statement, was prohibitively slow. So I'm writing to you all to find out if there is a better way. I don't want anyone to solve the problem; that's too much to ask. But if anyone can suggest some places where my friend might look, some ideas that he might search on for reading, he and I would be very grateful. To better define the issue, here are some pretend, but more or less accurate, details: approx. 120,000 records single table: GeneralInformationColumn1 50 characters GeneralInformationColumn2 50 characters GeneralInformationColumn3 50 characters GeneralInformationColumn4 50 characters GeneralInformationColumn5 20 characters GeneralInformationColumn6 20 characters GeneralInformationColumn7 20 characters GeneralInformationColumn8 20 characters .. GeneralInformationColumn20 20 characters BigText1 10 characters Needs ability to do boolean searches that span columns. In other words, a search for A AND (B or C) would get a hit if a single column contained A and B, or if one column contained A and another contained C. Thanks in advance for any help you can send. Matthieu __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: searching large amounts of text
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 index of this single column, allowing advanced searching across the record. He wondered whether there was a better way, and specifically whether there was a better way to do live queries without this sort of nightly batch job. His initial stab, an extremely complicated SQL statement, was prohibitively slow. I'd probably recommend using Verity as well, but there's no reason to go to all that work to use it. Just query the database to return the fields you want indexed, and index those fields; don't bother with creating a new table or any of that part. cfquery name=qIndexTable1 ... SELECT primarykey, field1, field2, field3, ... FROMTable1 /cfquery cfindex action=refresh collection=mycollection query=primarykey title=field1 body=field1,field2,field3,... ... cfquery name=qIndexTable2 ... ... /cfquery cfindex action=update collection=mycollection ... Note that this may take some time, so you probably want to do it on a scheduled basis, and if you're using CF 4.5.x, you want to prevent anyone from searching the collection until the indexing is complete. If it takes long enough, you might consider using two collections, and indexing them on an alternating schedule. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL2000 JDBC Driver and CFMX
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 authentication, but beyond that, it's easy enough to just create a native SQL login. I haven't tested that at all, and it doesn't bother me much as long as I can still call my beloved stored procedures. dynamic sql is a pain in sp often doesn't buy you much. still use cfquery for this most of the time. 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. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Adobe Java API
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 send me a quote. Thanks! [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Adobe Java API
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 competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Joseph Thompson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 03, 2002 12:21 PM Subject: Adobe Java API 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 send me a quote. Thanks! [EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Colocation in NYC
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, preferably within walking distance in midtown? Thanks! __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Adobe Java API
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 more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfcomet?
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 http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Adobe Java API
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 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Article on using Excel as a datasource
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 Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFMX-Linux/Unix
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 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFHTTP limitations?
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 working on a project for the past several months that uses CFHTTP to connect to a Python server that performs high-level math calculations. The amount of data (all textual, no binary) going through the pipe on any given call is roughly 15K...no, that's not a type-o, I mean 15K. While we haven't had many issues, I'm looking for pitfalls if I were to upgrade, and potentially alternatives to the tag, specifically if the overall performance will increase. This app will be high-volume when it's relased, and stress tests have shown this call to be a bit of a bottleneck. I have searched the archives and seen issues with variable encoding and stuff like that. Would some of you be good enough to give me even a checklist, let alone a short explanation of CFHTTP issues? I am using CF 4.5.2 on Solaris (upgrading straight to MX in the coming months) if that helps. Thanks in advance, Dave. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX-Linux/Unix
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... Jesse Noller Macromedia Server Development [EMAIL PROTECTED] Wait! We can't stop here! This is bat country! --Fear And Loathing In Las Vegas __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX-Linux/Unix
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. -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... Jesse Noller Macromedia Server Development [EMAIL PROTECTED] Wait! We can't stop here! This is bat country! --Fear And Loathing In Las Vegas __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
dw mx chopping code?
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? __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX-Linux/Unix
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 Loathing In Las Vegas __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: dw mx chopping code?
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 feature? Erika | -Original Message- | From: Andre Turrettini [mailto:[EMAIL PROTECTED]] | Sent: 03 June 2002 18:55 | To: CF-Talk | Subject: dw mx chopping code? | | | 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? | __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX-Linux/Unix
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 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 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
datetime formatting
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 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: datetime formatting
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 formatting 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 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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 in MSSQL, use getdate(). Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -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 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 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: datetime formatting
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 Subject: datetime formatting 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 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: datetime formatting
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 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 formatting 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 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: datetime formatting
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 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 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX-Linux/Unix
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: CFMX-Linux/Unix 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. -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... Jesse Noller Macromedia Server Development [EMAIL PROTECTED] Wait! We can't stop here! This is bat country! --Fear And Loathing In Las Vegas __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: datetime formatting
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 in MSSQL, use getdate(). Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -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 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 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: datetime formatting
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 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]] Sent: Monday, June 03, 2002 2:33 PM To: CF-Talk Subject: datetime formatting 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 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Sum Help
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 easy way am I forgetting something??? KP __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: datetime formatting
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 formatted as a date or time. FormatDateTime(Date[, NamedFormat]) Arguments Date Required. Date expression to be formatted. NamedFormat Optional. Numeric value that indicates the date/time format used. If omitted, vbGeneralDate is used. Settings The NamedFormat argument has the following settings: Constant Value Description vbGeneralDate 0 Display a date and/or time. If there is a date part, display it as a short date. If there is a time part, display it as a long time. If present, both parts are displayed. vbLongDate 1 Display a date using the long date format specified in your computer's regional settings. vbShortDate 2 Display a date using the short date format specified in your computer's regional settings. vbLongTime 3 Display a time using the time format specified in your computer's regional settings. vbShortTime 4 Display a time using the 24-hour format (hh:mm). Remarks The following example uses the FormatDateTime function to format the expression as a long date and assign it to MyDateTime: Function GetCurrentDate ' FormatDateTime formats Date in long date. GetCurrentDate = FormatDateTime(Date, 1) End Function -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:45 PM To: CF-Talk Subject: RE: datetime formatting 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 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]] Sent: Monday, June 03, 2002 2:33 PM To: CF-Talk Subject: datetime formatting 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 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Sum Help
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, 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 easy way am I forgetting something??? KP __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: datetime formatting
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, Tony -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:45 PM To: CF-Talk Subject: RE: datetime formatting 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 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]] Sent: Monday, June 03, 2002 2:33 PM To: CF-Talk Subject: datetime formatting 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 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: datetime formatting
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 2:45 PM To: CF-Talk Subject: RE: datetime formatting 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 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]] Sent: Monday, June 03, 2002 2:33 PM To: CF-Talk Subject: datetime formatting 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 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: datetime formatting
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 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 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]] Sent: Monday, June 03, 2002 2:33 PM To: CF-Talk Subject: datetime formatting 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 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Sum Help
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 Tipton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 03, 2002 1:55 PM Subject: RE: Sum Help 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, 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 easy way am I forgetting something??? KP __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: datetime formatting
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: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:52 PM To: CF-Talk Subject: RE: datetime formatting 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 2:45 PM To: CF-Talk Subject: RE: datetime formatting 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 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]] Sent: Monday, June 03, 2002 2:33 PM To: CF-Talk Subject: datetime formatting 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 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: datetime formatting
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 your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Members Only section
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 Pena Atomicqube __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: datetime formatting
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 test' INSERT INTO table1 (CreationDate, title) VALUES (@mytime, @title) SQL Server does it for you DECLARE @title varchar(50) SET @title = 'this is a test' INSERT INTO table1 (title) VALUES (@title) What you probably are doing is assigning the getdate() to a local variables. and then doing an insert using this variables. If this is what are you doing then you are correct. SQL Server will insert the exact time for all records in the insert. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:50 PM To: CF-Talk Subject: RE: datetime formatting 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, Tony -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:45 PM To: CF-Talk Subject: RE: datetime formatting 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 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]] Sent: Monday, June 03, 2002 2:33 PM To: CF-Talk Subject: datetime formatting 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 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
if value exists, show it
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 #variable# /cfif Is one of these better than the others for dealing with text values? I understand that IsDefined should be locked; I assume that is not the case for the other two. TIA, Trey __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX-Linux/Unix
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 3, 2002, at 10:31 AM, 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 Loathing In Las Vegas __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: if value exists, show it
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 variable called variable. === Raymond Camden, ColdFusion Jedi Master for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -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 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 #variable# /cfif Is one of these better than the others for dealing with text values? I understand that IsDefined should be locked; I assume that is not the case for the other two. TIA, Trey __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Sum Help
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]] 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, 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 easy way am I forgetting something??? KP __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Members Only section
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 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 Pena Atomicqube __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Members Only section
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 PROTECTED] http://www.sheriff.org -Original Message- From: Ernie Pena [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 3:10 PM To: CF-Talk Subject: Members Only section 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 Pena Atomicqube __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: if value exists, show it
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 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 #variable# /cfif Is one of these better than the others for dealing with text values? I understand that IsDefined should be locked; I assume that is not the case for the other two. TIA, Trey __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX-Linux/Unix
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 PM To: CF-Talk Subject: Re: CFMX-Linux/Unix 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 3, 2002, at 10:31 AM, 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 Loathing In Las Vegas __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: if value exists, show it
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 will be false and not display) If the variable may not be defined use. cfif isdefined(#variable#) #variable# /cfif HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: trey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 03, 2002 1:08 PM Subject: if value exists, show it 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 #variable# /cfif Is one of these better than the others for dealing with text values? I understand that IsDefined should be locked; I assume that is not the case for the other two. TIA, Trey __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: if value exists, show it
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 Wallick * Web Application Developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com/ -Original Message- From: trey [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 3:08 PM To: CF-Talk Subject: if value exists, show it 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 #variable# /cfif Is one of these better than the others for dealing with text values? I understand that IsDefined should be locked; I assume that is not the case for the other two. TIA, Trey __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: if value exists, show it
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 www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: trey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 03, 2002 1:08 PM Subject: if value exists, show it 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 #variable# /cfif Is one of these better than the others for dealing with text values? I understand that IsDefined should be locked; I assume that is not the case for the other two. TIA, Trey __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL2000 JDBC Driver and CFMX
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 Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.368 / Virus Database: 204 - Release Date: 29/5/2545 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: datetime formatting
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 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 test' INSERT INTO table1 (CreationDate, title) VALUES (@mytime, @title) SQL Server does it for you DECLARE @title varchar(50) SET @title = 'this is a test' INSERT INTO table1 (title) VALUES (@title) What you probably are doing is assigning the getdate() to a local variables. and then doing an insert using this variables. If this is what are you doing then you are correct. SQL Server will insert the exact time for all records in the insert. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:50 PM To: CF-Talk Subject: RE: datetime formatting 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, Tony -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:45 PM To: CF-Talk Subject: RE: datetime formatting 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 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]] Sent: Monday, June 03, 2002 2:33 PM To: CF-Talk Subject: datetime formatting 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 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: if value exists, show it
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 len(#variable#) #variable# /cfif oh, and, isdefined does *not* need to be locked. you only need to lock variables scoped as application, session, and server. ~ dina - Original Message - From: trey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 03, 2002 3:08 PM Subject: if value exists, show it 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 #variable# /cfif Is one of these better than the others for dealing with text values? I understand that IsDefined should be locked; I assume that is not the case for the other two. TIA, Trey __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: if value exists, show it
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 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 len(#variable#) #variable# /cfif oh, and, isdefined does *not* need to be locked. you only need to lock variables scoped as application, session, and server. ~ dina - Original Message - From: trey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 03, 2002 3:08 PM Subject: if value exists, show it 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 #variable# /cfif Is one of these better than the others for dealing with text values? I understand that IsDefined should be locked; I assume that is not the case for the other two. TIA, Trey __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: if value exists, show it
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 boolean that tells if the variable exists or not. This will return true even if the string is empty. There is no locking required specifically for isDefined(). cfif len(#variable#) GT 0 #variable# /cfif This assumes the variable exists and will output its contents if it is not empty (sounds closest to what you want). This could be better written simply as.. cfif len(variable) cfif #variable# IS #variable# /cfif This will not do much, since you're displaying the string if it IS empty. If you changed the operator to IS NOT or NEQ it would act just like the len() does above. I would presonally prefer using len() in this case. -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Sum Help
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 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]] 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, 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 easy way am I forgetting something??? KP __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Members Only section
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 MTUSER WHERE Username = '#form.Username#' AND Password = '#FORM.Password#' /CFQUERY !---If it was an invalid login, send them back to the login page --- CFIF IsValidLogin.RECORDCOUNT IS 0 cflocation url=index.cfm?Failed=Yes !---Set Cookie --- CFELSE cfcookie name=admin value=#form.username# !---Send them to the home of the application --- META HTTP-EQUIV=Refresh content=0; URL=wsb/index.cfm /cfif Application.cfm: !---simple Cfif to keep them out --- cfif isdefined(cookie.admin) is False cflocation url=http://www.atomicqube.com; /cfif -Original Message- From: Ernie Pena [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 3:10 PM To: CF-Talk Subject: Members Only section 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 Pena Atomicqube __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: if value exists, show it
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 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 #variable# /cfif Is one of these better than the others for dealing with text values? I understand that IsDefined should be locked; I assume that is not the case for the other two. TIA, Trey __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Members Only section
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 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 Pena Atomicqube __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: if value exists, show it
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 numbers: CFIF IsDefined(variable) AND IsNumeric(Variable) #variable# /CFIF Or make sure the number is not zero: CFIF IsDefined(variable) AND IsNumeric(Variable) AND Variable #variable# /CFIF Etc... Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: Justin Scott [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 3:36 PM To: CF-Talk Subject: Re: if value exists, show it 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 boolean that tells if the variable exists or not. This will return true even if the string is empty. There is no locking required specifically for isDefined(). cfif len(#variable#) GT 0 #variable# /cfif This assumes the variable exists and will output its contents if it is not empty (sounds closest to what you want). This could be better written simply as.. cfif len(variable) cfif #variable# IS #variable# /cfif This will not do much, since you're displaying the string if it IS empty. If you changed the operator to IS NOT or NEQ it would act just like the len() does above. I would presonally prefer using len() in this case. -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: if value exists, show it
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, June 03, 2002 3:43 PM To: CF-Talk Subject: Re: if value exists, show it 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 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 #variable# /cfif Is one of these better than the others for dealing with text values? I understand that IsDefined should be locked; I assume that is not the case for the other two. TIA, Trey __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Installing on XP machine
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 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: dw mx chopping code?
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 PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Erika L Walker-Arnold [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:13 PM To: CF-Talk Subject: RE: dw mx chopping code? 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 feature? Erika | -Original Message- | From: Andre Turrettini [mailto:[EMAIL PROTECTED]] | Sent: 03 June 2002 18:55 | To: CF-Talk | Subject: dw mx chopping code? | | | 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? | __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: if value exists, show it
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 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, June 03, 2002 3:43 PM To: CF-Talk Subject: Re: if value exists, show it If you're wanting to know if it was returned from a query.. cfif queryname.recordcount #variable# /cfif __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
