fieldnames structure

could just do something like: input type=hidden name=page1struct value=#structcopy(form.fieldnames)# But that throws an error. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox

Re: adding counts

The access version would be SELECT SUM(IIF(abstype IN ('U','E'), 1, 0)) as totalabsences -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http

SOT: Oracle ?'s

coopep.dg_herddata WHERE herdcode = cfqueryparam value=#herdcode# cfsqltype=CF_SQL_INTEGER) GROUP BY trunc(fulldate, 'Mon') ORDER BY month /cfquery Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Structure your ColdFusion code

Re: Index of array

There is an easier way of doing this. You cache the query and modify your startrow attribute in your cfquery tag. There's also a custom tag in the developer gallery I believe. -Deanna Deanna Schneider Interactive Media Developer [EMAIL PROTECTED

simple oracle sp

per row): column1column2 AB CF DU My big ol' oracle pl/sql book is just confusing me more. Thanks! -Deanna Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Get

Re: simple oracle sp

Thanks much Joel and Greg. I think your suggestions will get me back on the right track! -Deanna Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http

Re: Coldfusion Advanced Queries and Output?

: A HREF=http://testpages/downloadsmore.cfm?area=#latestdl.area;#latestdl.area #/a Hope that helps. -D Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http

graphing issue

increase the height) to give it more room because it just fills up whatever space is there. Changing the barspacing sort of helps, but not much. Anyone figure out a way to deal with lots of data in a cfgraph? (Like 24 bars?) -Deanna Deanna Schneider Interactive Media Developer [EMAIL PROTECTED

Re: Passing a recordset INTO an Oracle Stored Procedure

=In_Employee value= -Really? No value? Deanna Schneider Interactive Media Developer [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

Re: SQL - Oracle Functions

on a.event and populate the field. You can write a trigger to do this automatically when a new item is added to the database, too. Hope that helps. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Get the mailserver that powers

query of query and aliasing

. Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ 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

Re: `NOT in` CFQuery problem

= #CreateODBCDate(DateAdd(d, -30, today))# AND (email NOT in '#QuotedValueList(firstquery.semail)#') /CFQUERY Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http

Re: Upgrading from v4.5 pro to v5.0 pro

return. I'm guessing this is a change in the way cfsetting works, but I could be wrong there. -Deanna Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http

Re: Long client var in Oracle [was: WDDX]

#) /cfquery cfclientvariables would be the variable name of the client variables you are inserting. I just tried this on our setup and it worked great. -Deanna Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Your ad could

Re: AND OR placement in SQL

) as newsubject, * FROM advert_details WHERE town = '#form.towny#' cfif isdefined('form.category') OR (natpaid = Yes AND nationwide = Yes AND category = '#form.category#') cfelse OR (natpaid = Yes AND nationwide = Yes) /cfif /cfquery Make sense? -Deanna Deanna Schneider Interactive Media Developer

Re: Updating a multiple select box dynamically. question?

#rs_Consultant_Types.Consultant_Types_Name#/cfoutput/option /cfloop Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Re: cf to excel display issue

is that the replacement must be of the same datatype as the original column. So, if you don't want zeros to show up for a number column, you'd have to do a replace in your cfoutput to replace the zeros with null or something similar. Hope that helps. -Deanna Deanna Schneider Interactive Media Developer [EMAIL

Re: *** Complicated SQL riddle

Hey Jeremy, While pulling data out of the nested set model is easy, getting it in is not so easy. Care to throw out some examples of that? -D Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Your ad could be here. Monies from

Re: *** Complicated SQL riddle

Anyone care to work on porting these stored procedures to Oracle? I'm willing to work on it, but would love some help. -Deanna Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http

Re: *** Complicated SQL riddle

of A suba B subb C subc It's quite annoying. Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Re: *** Complicated SQL riddle

Good point. We're still using 4.5. Unlucky us. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http

Re: Access OLE DB vs. ODBC

, though I'm not sure if that's still the case with 5.0.) By the way, a group of developers has been working on migrating this to oracle for over a year now. *sigh* -Deanna Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Your ad

studio issues

or something that would automatically refresh? (I do have automatically refresh selected on settings.) Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http

Re: studio issues

Thanks all. I'll try the using external browser thing that Tim suggested. *sigh* Or, I'll go back to 4.0 again. ;) -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get

OT: javascript driving me crazy

, but that doesn't work so well with only 28 columns. Ideas? Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http

Re: javascript driving me crazy

for anyone? -d Deanna Schneider Interactive Media Developer [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

grouping dilemna

. Here's the brief table: projectid (num) projectname (varchar2) duedate (date) parentid (num or null) There's more in the table, but you get the idea. Thoughts on pulling grouped data by the max(duedate) of the group? Thanks! -Deanna Deanna Schneider Interactive Media Developer [EMAIL PROTECTED

Re: CFselect puzzling

box. Then, I'd do something like so: cfset myselectedlist = myquery.mycolumn select name=myselect size=1 option value=myvalue cfif listfind(myselectedlist, myvalue) GT 0selected My Value /option /select Make sense? Deanna Schneider Interactive Media Developer [EMAIL PROTECTED

Re: looping form collection

I don't think that form fields were always stored in a structure, were they? I think you need to find out what version of cfserver they're running. I want to say that they weren't stored in a structure until 4.5, the same time scope became a valid attribute for locks. -d Deanna Schneider

sort of OT: firewall issues

is never even getting to our server. He can log into the protected area just fine, he just can't seem to send a file out. Our html server logs show that he's coming through an MS proxy server 2.0. Thanks! Deanna Schneider Interactive Media Developer [EMAIL PROTECTED

re:ftp replication

Telestream has a product that does this. It's part of the functionality of their flip factory product. Flip factory actually does more than that, but you can configure an account to ftp anytime something changes in a folder. It's pricey though. -d Deanna Schneider Interactive Media Developer

Re: ftp replication

Well, that's a good question. I think we have FF Pro, but I'm honestly not sure. It's not a feature we're using, but we've been through the feature chat about a million times, and I know it was discussed. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED

Re: Could someone check this with non-IE5.5 ?

NS 4.76 is a no go. -d Deanna Schneider Interactive Media Developer [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

Re: WAY OT: Project Management Tools

Deanna Schneider Interactive Media Developer [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

cf in select stmt help

other tables, as I don't know the relationships there, and I always have to play with the database query builder in Access (I'm assuming this is access). I'm better at writing sql for oracle, but this should get you started. Deanna Schneider Interactive Media Developer [EMAIL PROTECTED

Re: Looping through a CFfile upload

(photoname, caseid) VALUES ('#serverfile#', #form.newid#) /cfquery /cfif /cfloop /cfoutput Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http

Re: db structure question

to be used once per record means that you only have to query one table. The other option, of course, is the create a view that flattens your db, then query the view. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Structure

dhtml graphing solution for non CF5 users

. But, since no one around here wants to hand out any cashola to buy a better solution, I'm stuck with the kludge. You can see the output of one example here: http://test.uwex.edu/ces/customtags/testgraph.cfm You can respond directly to me at the address below. -d Deanna Schneider Interactive Media

Re: OT:SQL syntax again

Deanna Schneider Interactive Media Developer [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

Re: Invalid SQL error - need Help

(*) fcount from STUDENTS group by stvcnty_desc, county ORDER BY county Also, I noticed that you're not including a dsn/password/username in the cfquery tag. I'm assuming you left those out for security, but you will need them. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED

Re: Invalid SQL error - need Help

Ah yes, you are correct on that renaming. I wasn't catching that that was what you were doing. Sorry. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book

creating excel file in the REQUESTED format

= f.foodstampid ORDER BY c.name, f.item, d.datecollected /cfquery Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ

Re: creating excel file in the REQUESTED format

BY name /cfquery#getfs.item[currentrow]#,#getfs.datecollected[currentrow]#,#valuel ist(gettotal.total)# /cfoutput cfsetting enablecfoutputonly=no Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Structure your ColdFusion code

Re: adding counts

the syntax if you need it. If you're using mssql, I can't help ya. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ

Re: Oracle 8i and cfstoredproc confusion

/cfstoredproc Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http

Re: OnRequestEnd.cfm not running

FINDING the OnRequestEnd file to begin with - not in it not finding it when there's an error. -Deanna Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB

Re: Multiple sites...

Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com

Re: OnRequestEnd.cfm not running

Oops. My bad. But, while we're pointint out mistakes, Ben, has anyone mentioned your incorrect syntax on list functions in the CF 5.0 Language Reference? *grin* Deanna Schneider Interactive Media Developer [EMAIL PROTECTED

Re: Group queries in Coldfusion by date.

value=Select another Month/option cfoutput query=test group=themonth option value=#themonth##monthasstring(themonth)#/option/cfoutput /select input type=submit value=Go! /form Deanna Schneider Interactive Media Developer [EMAIL PROTECTED

OT: between in oracle decode - Part II

)) AS sixties, SUM(DECODE( (SIGN((age/80)-1) + SIGN((age/69)-1)), 0, 1, 0)) AS seventies FROM (SELECT trunc(months_between(sysdate, q1)/12, 0) AS AGE, q1 FROM flpweb.tcy_pretest GROUP BY trunc(months_between(sysdate, q1)/12, 0), q1 ORDER BY months_between(sysdate, q1)/12) a Deanna

Re: oracle date/time

Try something to this effect: value=to_date('03-Jan-2002 12:01', 'dd-mon- hh:mi') Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB

accessibility - elegant solutions?

Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com

Re: Displaying Alternate text for no records in CF

cleaner. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http

Statistical T-Test

Hi Folks, Has anyone ever had to do a statistical t-test before? Got a UDF that hasn't been posted to cflib.org yet? Thanks! -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Dedicated Windows 2000 Server

Re: OT-FONT Problem

Try running it through www.whatthefont.com - a great tool for figuring out what font something is. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Get Your Own Dedicated Windows 2000 Server PIII 800

Re: Graphics Custom tag

I wrote a sort of kludgy scatter graph tag based on dhtml (and all its downfalls). Let me know if you want it and I'll dig it up. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Why Share? Dedicated

Re: FK related to PK in same table?

In the relationships view, select relationships - edit relationships. On the dialog box, select create new. You'll get a dialog box that lets you select a left and right table. Just select the same table, and the appropriate fields. -d Deanna Schneider Interactive Media Developer [EMAIL

Re: Help required on CF Performance....

The answer was www.opensta.org. You can set up a script to run with multiple virtual users and see how performance degrades (or doesn't) with additional users. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED

Re: Fixed: finding hidden characters

characters. (You may span rows, though.) Make sense? -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation

OT, sort of - server outages for backups

Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com

Re: Las record

blowing away your transaction after the first cfquery. Other people disagree with that, but in the better safe than sorry approach, if you're using Oracle, you should consider selecting the next value from a sequence FIRST, and then use the value to populate your primary key second. -d Deanna

SOT: Call XML w/ CF

experienced this? -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http

Re: SOT: Call XML w/ CF

I'm using Voxeo. It's just a development app - we're just exploring possibilities. I can try going to another page. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ This list and all House of Fusion

Re: SOT: Call XML w/ CF

to an xml file at the end.) Anyway, it's not a big deal. You can contact me off list if you want more info. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted

Re: Long text fields

I'd go with a clob unless you plan to do some checking to make sure they haven't gone over the limit. But, remember that when you use a clob, you have to use a cfqueryparam to pass the value to the database. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED

Advanced Statistical Analysis

this stuff real-time on the web. The boss has pretty much said, no way. But, I'm curious. Has anyone done things like regression anaylsis, t-tests, and the like using CF? If so, did you hook into some more powerful stats package behind the scenes, etc. etc? Thanks. -d Deanna Schneider Interactive

Re: Advanced Statistical Analysis

to the campus computing.) -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http

Re: CFFILE PDF to Sybase?

it. Alternatively, you can put it on some non-browsable area of the server, and serve it via cfcontent. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted

Re: Advanced Statistical Analysis

Thanks Dave, That bit of info helps. I checked with our stats person, and she thinks it's patently ridiculous to have the stats run in real time without interpretation. So, I think I'll be checking into an odbc connection to the completed datasets option. -d Deanna Schneider Interactive Media

Re: JOIN Query (with query)

I'm not sure you need a join possibly a subquery? SELECT o.id, o.name, o.description FROM #request.optionTable# o WHERE o.id IN (SELECT optionid FROM #request.productOptionTable# WHERE productid NOT IN ('#url.productid#') Deanna Schneider Interactive Media Developer [EMAIL PROTECTED

Re: escaping ampersands in sql*plus

Matthieu, Do this before your code: SET ESCAPE ON then this INSERT INTO DEPARTMENTS VALUES (1,2,3,'Mergers \ Acquisitions'); Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Structure your ColdFusion code

Re: Error with a simple expression.

. '#PreserveSingleQuotes(thisdisplay)#' Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http

Re: escaping ampersands in sql*plus

You can also change the escape character using the set command in SQL Plus. The \ is the default, but if you do something like SET ESCAPE (your new symbol here) ON The escape character will be your new symbol. Not positive on the syntax on that, though. -d Deanna Schneider Interactive

Re: Verity

Is it possible that the limit isn't per collection, but per server? If that's the case, then you may have other collections that add up to your max minus 5000. Thus, when you run this index, it hits 5000 and stops. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED

Re: Verity

of verity, but grew frustrated with that as well.) -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com

Re: multiple queries in one page, there has to be a better way

a view in your database that does the above query (with all your other stuff), and then select once from the view in CF. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Signup for the Fusion Authority news

CFC incorrect argument type - possible bug?

out claiming invalid type? Why does it only error when you try to use it and then with an erroneous error? Would you call this a bug? Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~| Archives: http

Re: LDAP Passwords

You mean like so: !--- Change password --- cfldap server=#request.ldapserver# port=389 action=modify username=uid=#request.ldapusername#, ou=CES, ou=uwex, o=Extension password=#request.ldappassword# attributes=userpassword=#form.password# dn=uid=#newid#, ou=CES, ou=uwex, o=Extension Deanna

Re: LDAP Passwords

and do some testing. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody

Re: copying db info with cf

schemaname.oldtablename; //reenable any triggers ALTER TRIGGER mytrigger ENABLE; //reenable any constraints ALTER TABLE mytable MODIFY CONSTRAINT myconstraint ENABLE; Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~| Archives

Re: Oracle query help

Generally, I think all is used as a qualifier to a subquery, much like you would use IN or BETWEEN. So, if you did: select * FROM mytable WHERE mycolumn = ALL(1,2,3) This would select everything where myid was equal to 1, 2 and 3. -d Deanna Schneider Interactive Media Developer [EMAIL

Re: OT: Javascript ?

Thanks everyone for your replies. I obviously had a momentary lapse of sanity there. *sigh* -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm

Re: Oracle Error no descriptor for this position

Have you tried recycling Oracle. I seem to recall getting this once, and it was something the DBA's had to deal with - not actually related to CF. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~| Archives

Re: Oracle Error no descriptor for this position

Oracle doesn't have an issue with alias names being the same as the column name you're aliasing. It handles that just fine. I do it in exactly that kind of way, where you're not really changing the meaning of the column, just verifying non-null-ness. -d Deanna Schneider Interactive Media

Re: Oracle Error no descriptor for this position

happen to be using that function, would you? -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com

Re: Using Distinct with other fields in one query

If all you really want is a list of distinct emails and the names that go with them, you can do this: Select Email,CustomerID,Name From SomeTable ORDER BY EMAIL cfoutput query=yourquery group=email p #email#:br cfoutput#customerid# - #name#br/cfoutput /p /cfoutput Deanna Schneider Interactive

Re: SQL Errors when updating Oracle table with CF ???

Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http

SOT: cgi variables on Apache

, but does anyone out there know if this is accurate, or if there might be a way around this other than changing all the code that uses auth_user? Thanks. Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~| Archives

Re: SQL Errors when updating Oracle table with CF ???

/cfquery /select Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists

Re: Verity Ordering Take 2.

Tim, If the field is already a date field in Oracle, you don't want to use to_date, you want to use to_date(to_char()). To_date expects a char field, so if you want to use it for reformatting a date, you have to to_char the date, then to_date it. Deanna Schneider Interactive Media Developer

Re: OT? Macromedia Contribute, is it Content Management or not?

amount to another full-time job, which ain't happening considering that we work for a state that's several billion dollars in debt. So, will I ever use contribute? Probably not. But, my colleague that designs static sites for those 72 counties jumped up and down when I told her about it. -d Deanna

Re: SQL vs PL/SQL

. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid

huge CFIF - better way?

is not !---Everything Required is Done--- pa href=writefile.cfmDownload Your XML File./a/p /cfif Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http

Re: cfstoredproc and CF MX

Joe, can you give an example of how you're using call or exec to run your stored procedures, and info on what database you're using. Does that approach only work when there are no out parameters, or are those still returned? -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED

Re: Suppress OnRequestEnd.cfm output

It's just and and/or logic issue. Change your ors to ands...in other words, the way it is now, it will always evaluate true, because reviewList.cfm IS NOT reviewListSA.cfm Make sense? d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED

Re: Delete query that doesn't delete (inside a loop)

Howard, Is there any reason (at least for the delete query) that you need to loop at all? Why not just do: DELETE FROMyourtable WHERE email IN (#mylistofemails#) You will accomplish the same thing, but it will probably run a lot faster. -Deanna Deanna Schneider Interactive Media

Re: Cascade delete

Deanna Schneider Interactive Media Developer [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

Quotation Hell

of the item off at the quote marks. What the heck?!? I've never had this problem before, and I didn't change any code. Am I nuts? -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Structure your ColdFusion code

Re: Quotation Hell

Yep. That makes sense. I wonder why in two years I've never come across this as a problem before. Ugh. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep

Re: getting auto id

schemaname.sequencename.nextval AS newid FROM dual /cfquery cfquery... INSERT INTO schemaname.tablename(IDColumn, Column2) VALUES(#getnew.newid#, 'mydata') /cfquery -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED

  1   2   3   4   5   6   7   8   >