parent/child

I'm trying to figure out how to have the child closed (instead of open) when the display page loads. Any suggestions? Thanks, Steve Here's an example of some code... SCRIPT LANGUAGE=javascript function toggleChild (entry) { if (entry.style.display ==

parent/child

I'm trying to figure out how to have the child closed (instead of open) when the display page loads. Any suggestions? Thanks, Steve Here's an example of some code... SCRIPT LANGUAGE=javascript function toggleChild (entry) { if (entry.style.display ==

parent/child

I'm trying to figure out how to have the child closed (instead of open) when the display page loads. Any suggestions? Thanks, Steve Here's an example of some code... SCRIPT LANGUAGE=javascript function toggleChild (entry) { if (entry.style.display ==

parent/child

I'm trying to figure out how to have the child closed (instead of open) when the display page loads. Any suggestions? Thanks, Steve Here's an example of some code... SCRIPT LANGUAGE=javascript function toggleChild (entry) { if (entry.style.display ==

What's with this?

I have this bit of code... cfset date1=dateformat(createdate(year(now()),month(now()),daysinmonth(month(n ow(,mm/dd/) cfset date2=dateformat(createdate(year(now()),month(now()),1),mm/dd/) and I'm getting this error on date1 In the function CreateDate(year, month, day) the

RE: What's with this?

the month,so really all you need is : daysinmonth(now()) regards Stephen -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: 01 June 2001 14:11 To: CF-Talk Subject: What's with this? I have this bit of code... cfset date1=dateformat(createdate(year(now

SQL server question

I'm not sure if this is the right list to post for this question, but here it goes. We have a database that we're converting from Access to SQL server 7, and since I'm new to this there are 2 issues as of now. 1. Can you set up a link (or alias I guess) that would link the old table name

sql server

ok... I've set up a SQL 2000 server and had to figure out a way to access a remote SQL 2000 server and run queries against it. solved Problem now is that I need to set up an alias for the 4 level qualified path. -- example... select * from

another sql server question

We've received the following error after installing SQL server 2000 personal edition. [MS Design Tools] Class not registered Any ideas? ~~ Structure your ColdFusion code with Fusebox. Get the official book at

session variable storage

registry or database? which is better and why? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe:

RE: Checking for NULL

cfif trim(qQuery.field) eq blah /cfif Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676

twoselectsrelated

I've been playing with twoselectsrelated, and for some reason I'm running into a bind. I have a multipart form where I'm storing the data using the following methodology. I take the data and throw it into an array and store the array in a structure and then finally keep it in a WDDX packet.

RE: AHHHHHHHH Netscape HTML Question

Works for me in netscape 4.7. what version of 4 are you using? Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676

RE: AHHHHHHHH Netscape HTML Question

Actually...look at line 29. you're trying to put a table inside a td but you closed the td before created the table. Steven D Dworman - Web Consultant Systems Administrator ComSpec International -

RE: SQL Query Quandary

Make your checkboxes the same name and values the amenity_id. Then when you submit the form you'll have a list of values that you can use in your SQL statement. In the statement you'll want to use Select blah From blah where amenity_id IN (#perservesinglequotes(your_list)#) or something to

RE: CFEXECUTE

I've never used this tag, but don't you have to put ftp -s in arguments and the c:\path\to\file\ftpcommands.txt in outfile? Steven D Dworman - Web Consultant Systems Administrator ComSpec International -

RE: Last Updated Date

select refdate from sysobjects where name = 'TABLE NAME' Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676

RE: Last Updated Date

Simon - Original Message - From: Steven Dworman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 1:05 PM Subject: RE: Last Updated Date select refdate from sysobjects where name = 'TABLE NAME' Steven D Dworman

cf system requirements from macromedia

What is the typical traffic load that the basic system requirements can handle? Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell:

related select boxes

Ok...I've tried every related select boxes custom tag that I can find. None of which will populate the second box in the following circumstances: 1. on the initial visit to the page a user selects a country and thus the state select box is populated 2. upon completing the entire process the

RE: Three select

Forcewidth4 should be forcewidth3 Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676

RE: getting xxx from xxx

cfset some_var = xxx cfset out_var = mid(string_var,2,3) cfoutput#out_var#/cfoutput Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell:

RE: getting xxx from xxx

- EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 10:57 AM To: CF-Talk Subject: RE: getting xxx from xxx cfset some_var = xxx

RE: CFAbort in 5.0

I think you're supposed to use cfexit in custom tags. Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676

RE: SQL Query Problem

Can't you just use isnull(BrandID,0)? Then you'll have 0's replacing null values, and your average won't be messed up. Steven D Dworman - Web Consultant Systems Administrator ComSpec International -

RE: SQL Query Problem

careful about this, as I have seen that mistake before, and it wreaks havoc! Dave. Original Message Follows From: Steven Dworman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: SQL Query Problem Date: Fri, 16 Nov 2001 08:13:37 -0500 Can't you

RE: cfquery and two column output

http://webreference.com/authoring/style/sheets/layout/advanced/ check out the links under further reading. Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com

RE: cfquery and two column output

- EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 9:52 AM To: CF-Talk Subject: RE: cfquery and two column output http

RE: maxrows question

select 0 from table_name where column_name = '#passed_value#' or select 0 from table_name a where exists(select 0 from another_table_name b where b.column_name = a.column_name) i think either should work -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: Thursday,

asp vs. cf

My boss just asked me for a list of pros and cons. I want to show him that CF is superior to ASP, but I don't know ASP. If you guys could help with my list I'd appreciate it. Thanks, Steven D Dworman - Web Consultant Systems

RE: asp vs. cf

Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] My boss just asked me for a list of pros and cons. I want to show him that CF is superior to ASP, but I don't know ASP. If you guys could help with my list I'd appreciate it. Thanks

RE: CFMAIL

did you verify that cf server can connect to your mail server? verify all the settings in the administrator. i think default smtp is port 25. if that doesn't work then just use cfmail tag. you can set the server name and port number in the tag. another thing to check, if you're using

RE: Dynamic form fields

try #evaluate('form.name[#getids.id#]')# -Original Message- From: Bruce, Rodney (Contractor) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 03, 2001 2:15 PM To: CF-Talk Subject: Dynamic form fields hello all Hope you can help with a little problem. I have on a field that

RE: Dynamic form fields

is the Force, and a powerful ally it is. - Yoda -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Monday, December 03, 2001 3:11 PM To: CF-Talk Subject: RE: Dynamic form fields try #evaluate('form.name[#getids.id#]')# -Original Message- From: Bruce, Rodney

layers and divs

I have a page that checks for the browser type and then diplays either 1. div's for microsoft 2. layer's for netscape for 1 everything is cool. the divs expand and collapse, however, for 2 they just show up and disappear. How can I get the layers to expand and collapse like divs? example

BLOB

What's the ideal way to retrieve BLOBs from an Oracle database. I've never worked with these before, when I tried a cfquery statement I got the ORA932: inconsistent datatypes error. Any help is appreciated. Steven D Dworman

cfgrid references

Just looking for some reference material on cfgrid, outside of the Forta books. Thanks, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

locking error

Can someone explain this error to me? I took out the locks in the application.cfm file when I got this error message. Unable to acquire lock for single threaded sessions within timeout period. Please raise the request timeout limit to lengthen the time available to acquire the lock. The

oracle and coldfusion

Here's the situation. I have this rather large and complex package of procedures, and I want to avoid doing a commit or rollback inside the procs. What I am attempting to do is run the procedures and if there is an error message do a rollback, or if no error message then do a commit. This

Re: cftransaction

in oracle i use it with procedures. since i've found that it's not proper to put commits and/or rollbacks inside the procs cftransaction comes in handy. you can control a commit or a rollback per transaction to the db. it also allows you to use isolation (locking in the db), but i haven't

RE: Alternating BG colors on a TD

Try something like this cfset rowcolor1=00 cfset rowcolor2=FF cfset bgcolor1= table cfoutput query=blah cfif bgcolor1 is #RowColor2# cfset bgcolor1 = #RowColor1# cfelse cfset bgcolor1 = #RowColor2#

someone want to help me?

My boss wants me to spec out the process of taking credit card orders over the web I have limited experience with this and any help you guys can give me is appreciated Thanks, Steven D Dworman - Web Consultant Systems Administrator

RE: someone want to help me?

thanks for the tips. they should help plenty. -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 12:25 PM To: CF-Talk Subject: someone want to help me? My boss wants me to spec out the process of taking credit card orders over the web

OT: excel

How can I keep Excel from formatting columns when I open a .csv file? I have a serial number column that can be all numbers, or a combinantion of numbers and text. When Excel sees a long string of numbers it formats it in scientific notation. Thanks, Steven D Dworman

RE: OT: excel

, Steven Dworman wrote: How can I keep Excel from formatting columns when I open a .csv file? I have a serial number column that can be all numbers, or a combinantion of numbers and text. When Excel sees a long string of numbers it formats it in scientific notation. Thanks, Steven D Dworman

forcing a log out

Is there a script that will catch if the user closes the browser without logging off from an app? I need to force a logout and run this script I have to update an audit table. Thanks, Steven D Dworman - Web Consultant Systems

RE: forcing a log out

: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 1:09 PM To: CF-Talk Subject: forcing a log out Is there a script that will catch if the user closes the browser without logging off from an app? I need to force a logout and run this script I have to update an audit table

RE: forcing a log out

source on your favorite cf_Porn site. LOL! 8P -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 1:54 PM To: CF-Talk Subject: RE: forcing a log out onunload will run on any page redirection, not just closing the browser. -Original

OT: Oracle and Excel

There is a programmer who is trying to do the following: export data to a workbook in excel using OLE alter cell data on the fly save the current workbook What is the command he needs to send through OLE to save the workbook without overwriting it? I don't have a code snippet. Thanks, Steven

native data sources option

Why would this option show up in administrator for one installation but not another? How can I get it to show up? Thanks, Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone:

Re: anyone seen such error msg b4??

datasource...check it - Original Message - From: han peng [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, March 24, 2002 11:21 PM Subject: anyone seen such error msg b4?? unknown exception condition PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag i got this

standby screen

Is there a way I can show the user a message saying processing while a page is processing queries? How do I do this? Thanks, Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com

RE: cfhttp question

http://devex.allaire.com/developer/gallery/info.cfm?id=CA3471D5-2830-11D4-AA 9700508B94F380method=full -Original Message- From: Fisichella [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 9:36 AM To: CF-Talk Subject: cfhttp question Hi, I'm using cfhttp to grab quotes from

RE: cfhttp question

You bet -Original Message- From: Fisichella [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 9:59 AM To: CF-Talk Subject: Re: cfhttp question Thanks a lot Steve. Thanks. - Original Message - From: Steven Dworman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent

Re: Source Control and Your Dog

visual source safe or teamsite. i've used both of them. only heard good things about pvcs. so i guess any of the three would be ok. my $0.02 - Original Message - From: Zac spitzer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, December 15, 2001 5:21 PM Subject: Re:

Re: Unique ID Help

make sure the datatype is a varchar (varchar2 if oracle) and that it is long enough. you'll need single quotes around it - Original Message - From: Gregory Harris [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, December 15, 2001 1:30 PM Subject: Unique ID Help Ok,

OT: Akopia Interchange

Any good resources on this? Steven D. Dworman Web Consultant Systems Administrator Comspec International phone: 248.647.8841 cell : 734.972.9676 Empower-XL Software for Higher Education

Re: Stopping/Starting/Restarting services.

create a batch file like this... net stop Cold Fusion RDS net stop Cold Fusion Executive net stop Cold Fusion Application Server net start Cold Fusion Application Server net start Cold Fusion Executive net start Cold Fusion RDS exit - Original Message - From: Bill Davidson [EMAIL

Re: SQL GURUS?

make sure the category table you're updating has the update priveledge checked. - Original Message - From: Dale Fontenot [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 03, 2002 7:03 PM Subject: RE: SQL GURUS? If I remember correctly the problem is a privilege

RE: cf_twoselectesrelated help!!!!

What does your query look like? Also, shouldn't the onchange even be this.form.submit();? Are you submitting to the same form? It seems like you're calling the query once for the selectsrelated tag, submitting the form to itself but the query i s not called again. -Original Message-

RE: Dave or someone -- Help me with error msg!!!

**snip** CFQUERY NAME=gilwaya DATASOURCE=jgrn123 USERNAME=jgrn123 where's the password attribute? CFQUERY NAME=gilwaya DATASOURCE=jgrn123 USERNAME=jgrn123 PASSWORD=?? -Original Message- From: Julia Green [mailto:[EMAIL PROTECTED]] Sent: Friday, January 04, 2002 2:39 PM To: CF-Talk

Re: SQL question

select distinct type from table where category = 'large' - Original Message - From: Chad Gray [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, January 05, 2002 10:19 AM Subject: SQL question I have a table that i would like to pull some information out of. It looks

Re: Javascript Calendar

does it have to be javascript? i have a cf calender that does what you're looking for. - Original Message - From: Neil H. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, January 05, 2002 4:32 PM Subject: Javascript Calendar I am looking for a calendar that will pop up

Re: Javascript Calendar

Calendar Will it populate the form without going to a new page? I wanted JavaScript to populate the form? Neil - Original Message - From: Steven Dworman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, January 05, 2002 4:30 PM Subject: Re: Javascript Calendar

Re: Creating ZIP archives

cfx_zip, or something like that. check out the developers exchange on allaire's site. - Original Message - From: Nick Texidor [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 07, 2002 6:39 PM Subject: Creating ZIP archives Hi, I have a requirement to zip up

Re: Mental Block

use the next n logic that's floating around. if you're using sql server just get the rownum of the record you retrieve initially, and set that number as the start. then you can just add/subtr act whatever step number you choose to make the next/previous buttons. if you need the code email me

Re: Oracle 8i and cfstoredproc confusion

that error means you're either, sending too many or too few parameters, o r you're not returning any parameters to your stored procedure... are you creating a function or a stored procedure? Your code says functi on, but you're saying stored proc. you should be creating a procedure not a

Re: How to time out a session held as client variables?

deleteclientvariables() - Original Message - From: Mike Kear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 15, 2002 12:07 AM Subject: How to time out a session held as client variables? I know how to expire a session that's been managed with session variabl

OT: CSS

I've been reading through css resources, but I can't seem to find much on altering the properties of a select box. Changing the font, width, height, blah blah is no problem. This issue is changing the scroll bar properties such as color, and border properties so that I can remove the 3d effect.

RE: CSS

; } There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Steven Dworman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 21, 2002 7:27 AM Subject: OT: CSS I've been

msmenu

Is there a way to highlight the menu header after you've clicked a link in one of the menus? In other words can I alter the color scheme of individual items instead of the whole menu bar? Thanks, Steven D Dworman - Web Consultant Systems

RE: msmenu

. But that may not be an option if you are already developing with the msmenu. Shawn Grover -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 24, 2002 11:25 AM To: CF-Talk Subject: msmenu Is there a way to highlight the menu header after you've clicked a link

cf and eDir

Has anyone used CF with eDir? Please tell me your stories and what I need to know. Thanks, Steven D. Dworman Web Consultant Systems Administrator Comspec Connect Admininistrator Comspec International phone: 248.647.8841 cell : 734.972.9676

OT: pdf

Here's the deal. A client has an extremely important pdf that they want locked down. What this means is that they want to burn it on a cd, make the cd copy protected, and not allow the user to save the file after it's been opened. On top of that they want to prevent the user from doing a

executing a dts package

Here's the deal. We have a DTS package that needs to be executed on a monthly basis. The problem is that SQL server 7 can't execute it. It fails every time. If we run the package manually it works just fine. Any ideas? Thanks, Steven D Dworman

RE: executing a dts package

yes -Original Message- From: Darryl Lyons [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 4:11 PM To: CF-Talk Subject: RE: executing a dts package You've set up an SQL Job for running the DTS package I am assuming? -Original Message- From: Steven Dworman [mailto

registry error

I've never had this happen. Here goes... I went in to administrator to delete an ODBC source. Sounds simple I know, but I got this error: Unable to delete the registry entry in branch HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\***datasource here*** A problem was encountered trying to access

Re: registry error

of using the Coldfusion admin that is, if you're using windows :) -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 1:51 PM To: CF-Talk Subject: registry error I've never had this happen. Here goes... I went in to administrator

Re: getting auto id

not if you use stored procs, or a package (bunch of procs and functions) you just leave the rollback; / and commit; / statements out and use cftransaction to execute them. Steven D. Dworman Certified Macromedia Developer Web Consultant Systems

Re: getting auto id

are you using a stored proc for sql statement? if so just make an out var in your proc, and set your seqeunce value equal to it. then in your cf code use a cfprocparam of type out and you can reference the variable with a proc_name.var_name Steven D. Dworman Certified Macromedia Developer

really dumb cf admin question

How do I get the native driver option installed? Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com phone: 248.647.8841 cell: 248.767.9925

pdflib

one of the developers here is using pdflib and upon generating a pdf there is a green pdflib.com logo on each page. We have a registered copy, so licensing shouldn't be an issue. has anyone experienced this? Steven D Dworman Macromedia Certified Developer

installing application on a linux box

I only have limited experience with Coldfusion on a Unix/Linux platform. The network department at a client site has CF installed on their webserver, so that side is settled. Is there a checklist out there of what I should test and/or change in my code so that the application can be installed

executing sql server dts package from cf

I've never done this. Where can I find information? Thanks, Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com phone: 248.647.8841 cell:

RE: executing sql server dts package from cf

sArg = /S servername /U username /P password /N packagename CFEXECUTE name=c:\program files\microsoft sql server\80\tools\binn\dtsrun.exe arguments=#sArg# outputfile=c:\MyExportLog.txt timeout=1800/ HTH, Dave -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: 10 May 2002

executing dts package...part 2

Well I have been able to fire off any dts package I want through my CF app. However, when it has to open the excel file to import data into a temp table the process fails. Reason being that it can't find the file. I have mapped the location where SQL server reads the excel file properly on the

RE: executing dts package...part 2

: Carlisle, Eric [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 28, 2002 2:40 PM Subject: RE: executing dts package...part 2 Any chance you can use a UNC path instead of drive mapping? -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May

RE: executing dts package...part 2

nevermind...got it -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 10:37 AM To: CF-Talk Subject: RE: executing dts package...part 2 no unc path allowed. that's why i had to map the drive. the issue is that sql server thinks the mapping

RE: [admin] List status - A CHALLENGE

agreed -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 3:03 PM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE Sorry , but armpit of america status belongs to east lansing, michigan. Believe me , I spent two years there