RE: Question about processing a CSV file.
If the file is in a web accessible folder, you can use cfhttp to read it into a query. Then loop over the query to update the database. cfhttp url="" name=qCSV columns=header_id,track_nbr textqualifier= delimiter=, resolveurl=no throwonerror=yes timeout=20 charset=iso-8859-1/cfhttp cfloop query=qCSV UPDATE table SET track_nbr = cfqueryparam cfsqltype=cf_sql_varchar value=#qCSV.track_nbr# WHERE header_id = cfqueryparam cfsqltype=cf_sql_numeric value=#qCSV.header_id# /cfloop Pascal -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: 13 September 2004 23:36 To: CF-Talk Subject: Question about processing a CSV file. Hi, I was wondering if anyone could help me out as I am stuck on this part.I have a csv file that I would like to read and then issue an update query based on the contents. Basically I would like to read the file and then loop over the file and issue and update query for each line (maybe I could convert it to stored procedure later). And what I want to do is loop over it and issue an update: PUSEDOCODE: CFLOOP over the file update table set track_nbr = '2345678il' where header_id = 5388120 /cfloop [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Incorporating Javascript to confirm into a document...
A JS variable is not passed when you post the form. You can use a hidden
form field. But easier is to just do the whole thing in JS and don't
post if the user clicks cancel:
function delete_presentation()
{
return confirm(Do you really want to delete this
presentation??);
}
Pascal
-Original Message-
From: Brett Barnhart [mailto:[EMAIL PROTECTED]
Sent: 13 September 2004 18:15
To: CF-Talk
Subject: Incorporating _javascript_ to confirm into a document...
I've been working on this all morning and I am missing something. I
have a
delete button on a page and I want a _javascript_ Confirm box to pop up.
I am trying to assign a variable in the _javascript_ and then Test that
script
in my CFIF. This works fine until I add the confirmation box.
I declare the variable
CFPARAM NAME=confirm_delete_presentation Default=false
Here is my _javascript_
function delete_presentation()
{
confirm_delete_presentation= confirm(Do you really want to delete
this
presentation??);
}
Here is my CFIF
CFIF IsDefined(form.delete.x) and badFlags EQ and
confirm_delete_presentation EQ true
-- Script to do the deleting
/CFIF
and finally my button
INPUT TYPE=image NAME=delete SRC="">
ALT=Delete
Presentation >
Any hints?
Thanks!
Brett
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: Download link broken on Macromedia.com
I had a similar problem with downloads from the MM site. Turned out my firewall was blocking downloads of types not specified, and for some reason the original packet info sent from the MM site doesn't appear as an exe but as something else. Cutter Sean Corfield wrote: On Tue, 14 Sep 2004 09:34:30 +1000, Mike Kear [EMAIL PROTECTED] wrote: I've been trying to update my FLASH MX2004PRoand all I get from http://download.macromedia.com/pub/flash/updates/mx2004/flmx2004_702update_en.exe is page is not available It downloads just fine for me... the 68Mb file took about three minutes to download. -- Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: parsing MIBs with Coldfusion
MIB file? Men In Black? Sorry, couldn't resist...;) Cutter Steve Dworman wrote: All Is there a custom tag that parses industry standard MIB files?I need to be able to load a MIB file and have CF parse the file so I can present the variables and descriptions to the user. Any help is appreciated. --Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
ot: java popup window
i friggin lost my code for a popup window off of a dynamic pix that auto sizes to the photo size anyone have any code handy to do that? tia [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Flash
www.flashmx2004.com -- Original Message -- From: Troy Simpson [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Mon, 13 Sep 2004 09:23:46 -0400 I am now developing a flash client.Anyone know of a good list to post Flash questions? Thanks, -- Troy Simpson Applications Analyst/Programmer, OCPDBA, MCSE, SCSA North Carolina State University Libraries Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 E-mail: [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Splitting a Query
Hi Ricardo, An alternative might be SELECT crmFields.groupof, crmFields.id FROM crmFields JOIN crm ON (crmFields.id = crm.fieldid) WHERE crmFields.position = 99 AND crm.clientid = 1248 AND crm.value != It might also be worth looking at what indexes are in place on the columns that are in your WHERE and ON clauses (if you have control of this of course :-) HTH Mike T - Original Message - From: Ricardo Russon [EMAIL PROTECTED] Date: Tue, 14 Sep 2004 12:15:57 +1000 Subject: Splitting a Query To: CF-Talk [EMAIL PROTECTED] Let me start by saying that i am having a very slow day. I have a query: SELECT crmFields.groupof, crmFields.id FROM crmFields WHERE crmFields.position = 99 AND crmFields.id IN(SELECT crm.fieldid FROM crm WHERE crm.clientid = 1248 AND crm.value != ) It runs very very very slow, and chunks up the server a lot. There are thousands of fields for it to cross reference. I am thinking that splitting it up, and taking the load off the db would be a good idea. Can anyone suggest a way to do this? thanks Ricardo. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Update a field
You may have to provide a bit more detail before we can help. What interface are you using to execute this code?Since this is CF-TALK I assume there is some CF code involved?Can you supply this code then someone may be able to spot the problem for you. - Original Message - From: Daniel Kessler [EMAIL PROTECTED] Date: Mon, 13 Sep 2004 10:27:28 -0400 Subject: Update a field To: CF-Talk [EMAIL PROTECTED] I'm trying to manually update an entry in a database (ORACLE) so that I can insert a number into it'd ID field. update whats_new set id = 2 where header = 'Dr. Catherine Ennis Wins McKenzie Award' I'm getting SQL Command Not Properly Ended.This works fine if I remove the WHERE line, but the reason that I'm giving it an id is that the header is too inexact an identifier. So any thoughts on how to get this working?I tried adding some semi-colons, but it didn't work. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Printing Multiple Files All dynamically created or linked through Cold Fusion - Now desperate
Have you thought about having the system create a ZIP on a scheduled basis (use a scheduled task that runs every night and creates an updated ZIP file), then provide the user with a static link to the archive. That would not provide the required printing however it would get the documents to the user. Hatton [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Currently running page requests
There are a couple of automated tasks on our server here that run periodically but take between 10-30 minutes to execute while they look up several hundred other web pages from other servers.Is there any way to get a list of currently running page requests on the server so I can keep track or them? -- James Smith [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: Gmail isnt the be-all and end-all for flashcoders
I've found out that you can't post to flashcoders from gmail apparently, because gmail doesnt offer any way to send text-only mail. Since flashcoders apparently rejects html email, and gmail only sends html email, you can't post to flashcoders if you use gmail. that's a lesson to learn if it's ever proposed to ban html email on cf-talk.It'll mean all those people who scrambled to get gmail accounts wont be able to post. Or have i got the wrong end of the stick again? -- Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: (crosspost) CFMBB - open source message board
I see a big CF error dump at http://www.cfmbb.org/ On Mon, 13 Sep 2004 14:23:34 -0400, Rick Root [EMAIL PROTECTED] wrote: Well, I'm not ready to release the source code for the first version yet, but I *AM* ready to share what I've done so far for public viewing and comment. so if you'd like to check out this new coldfusion based message board, please visit http://www.cfmbb.org/ Thanks. Cross-posted to cf-talk and bluedragon-interest Rick root [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFHTTP
I'm trying to get data (title of page) from a url which is passed with _javascript_. The set (gotolink) seems to work, but cfhttp doesn't seem to connect. The gotoLink output works also. What's wrong with my code? cfset goToLink = 'scriptdocument.write(window.opener.form.link_e.value);/script' cfoutputLink = #gotolink#/cfoutput cfhttp url="" resolveurl=no/cfhttp cfoutput#cfhttp.FileContent#/cfoutput [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Printing Multiple Files All dynamically created or linked through Cold Fusion - Now desperate
Already have it as that is one of the functions as well. It's not the distribution of the documents as much as it is making it easy to print. There can be between 1 and 50+ products that have a 3 page questionare associated with them. On top of that - I can have up to 10 documents - images, docs, txts .xls files associated with them. This user (not always going to be the brightest) has to print everything out in a specific order. Otherwise I am forcing the user to print everything associated at the right time. To complicate it more -the dynamic html page that has the products is all one long document with forced page breaks. I demo'd every convert to PDF function possible - but because I need to support a handful of documents it's not the best route. I can use cfcontent to view all these documents - but have no way of controlling any functionality - even back or next buttons since cfsavcontent on displaying something like doc or pdf takes over 100% of the page. I can't believe that right now it looks as if there is no way to pull all these formats together through coldfusion to control the printing. Ideally I would love just one long document - be it doc or pdf - but would settle for some technique to loop through a list of files to print spawning the text box and on each return to page automatically trigger another print process. jay Have you thought about having the system create a ZIP on a scheduled basis (use a scheduled task that runs every night and creates an updated ZIP file), then provide the user with a static link to the archive. That would not provide the required printing however it would get the documents to the user. Hatton [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFHTTP
That is never going to work as _javascript_ is client-side and CF is server-side. The CF script runs when the user requests the page. You will have to do something like get the _javascript_ to call a script on the server and pass the url entered as a query string on the script call URL, or do it as a form submission. Andrew. - Original Message - From: Luc Deault [EMAIL PROTECTED] Date: Tue, 14 Sep 2004 08:44:44 -0400 Subject: CFHTTP To: CF-Talk [EMAIL PROTECTED] I'm trying to get data (title of page) from a url which is passed with _javascript_. The set (gotolink) seems to work, but cfhttp doesn't seem to connect. The gotoLink output works also. What's wrong with my code? cfset goToLink = 'scriptdocument.write(window.opener.form.link_e.value);/script' cfoutputLink = #gotolink#/cfoutput cfhttp url="" resolveurl=no/cfhttp cfoutput#cfhttp.FileContent#/cfoutput [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFHTTP
Don't want to be a pest but why is my first cfoutput actually outputting the right string? ___ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFHTTP
Because when you output it the browser see the script tags and processes and the document.write writes the output to the browser. This however is done client-side and not server side. All the CF server is the script... part and output it to the browser. If you view the source in the browser you will see. Andrew. - Original Message - From: Luc Deault [EMAIL PROTECTED] Date: Tue, 14 Sep 2004 09:01:50 -0400 Subject: Re: CFHTTP To: CF-Talk [EMAIL PROTECTED] Don't want to be a pest but why is my first cfoutput actually outputting the right string? ___ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Currently running page requests
This is a fairly rudimentary idea but you could have each process log its beginning and its termination. A quick check of the log (maybe a DB table) would tell you what is currently running. - Original Message - From: James Smith To: CF-Talk Sent: Tuesday, September 14, 2004 6:59 AM Subject: Currently running page requests There are a couple of automated tasks on our server here that run periodically but take between 10-30 minutes to execute while they look up several hundred other web pages from other servers.Is there any way to get a list of currently running page requests on the server so I can keep track or them? -- James Smith [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Currently running page requests
Is there any way to get a list of currently running page requests on the server so I can keep track or them? You can perform a dump of the current stack trace, which will list (amongst a big pile of other stuff) what's requests are currently being processed by CF.See the MM technote about it: http://www.macromedia.com/support/coldfusion/ts/documents/tn18339.htm Tim. -- --- Badpen Tech - CF and web-tech: http://tech.badpen.com/ --- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. --- This message may contain information which is legally privileged and/or confidential.If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Form Filling w/ activePDF Toolkit
Well, Internet Explorer just refuses to cooperate (it seems to work OK for me in Firefox), and I was unable to make any changes that would work, so this should do the trick for you guys. Sorry about the errors. http://yexley.net/bob/code/cdrlreport.zip http://yexley.net/bob/code/cdrlreport.zip // YEX // -Original Message- From: Rick Mason [mailto:[EMAIL PROTECTED] Sent: Monday, September 13, 2004 7:13 PM To: CF-Talk Subject: Re: Form Filling w/ activePDF Toolkit I received the same message as well. Rick Mason - Original Message - From: Chris Tilley [EMAIL PROTECTED] Date: Mon, 13 Sep 2004 16:37:59 -0400 Subject: Re: Form Filling w/ activePDF Toolkit To: CF-Talk [EMAIL PROTECTED] When I try the link:http://yexley.net/bob/code/cdrlreport.txt I get the following error. The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Currently running page requests
And its nigh on useless in my opinion. _ From: Tim Blair [mailto:[EMAIL PROTECTED] Sent: 14 September 2004 14:23 To: CF-Talk Subject: RE: Currently running page requests Is there any way to get a list of currently running page requests on the server so I can keep track or them? You can perform a dump of the current stack trace, which will list (amongst a big pile of other stuff) what's requests are currently being processed by CF.See the MM technote about it: http://www.macromedia.com/support/coldfusion/ts/documents/tn18339.htm Tim. -- --- Badpen Tech - CF and web-tech: http://tech.badpen.com/ --- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. --- This message may contain information which is legally privileged and/or confidential.If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Currently running page requests
Well I've found the stack trace invaluable in terms of information. But the fact that you have to have your server running through command prompt makes its pretty useless. For example in a production app, you have to shut down the server. (not cool) Then restart it in a command window (not cool), then you cannot log off! (not cool) Although I'm told this is a windows only issue. Still, its great insight into problems... but you cant really get it when you need it. -Adam - Original Message - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] Date: Tue, 14 Sep 2004 14:26:01 +0100 Subject: RE: Currently running page requests To: CF-Talk [EMAIL PROTECTED] And its nigh on useless in my opinion. _ From: Tim Blair [mailto:[EMAIL PROTECTED] Sent: 14 September 2004 14:23 To: CF-Talk Subject: RE: Currently running page requests Is there any way to get a list of currently running page requests on the server so I can keep track or them? You can perform a dump of the current stack trace, which will list (amongst a big pile of other stuff) what's requests are currently being processed by CF.See the MM technote about it: http://www.macromedia.com/support/coldfusion/ts/documents/tn18339.htm Tim. -- --- Badpen Tech - CF and web-tech: http://tech.badpen.com/ --- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. --- This message may contain information which is legally privileged and/or confidential.If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT- NEWS - cfcertification.com
Did anyone recently visit http://www.cfcertification.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT- NEWS - cfcertification.com
Don't go to this site - it has adult content and has nothing to do with CF. - Original Message - From: Asim Manzur To: CF-Talk Sent: Tuesday, September 14, 2004 9:59 AM Subject: OT- NEWS - cfcertification.com Did anyone recently visit http://www.cfcertification.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT- NEWS - cfcertification.com
From: Asim Manzur Did anyone recently visit http://www.cfcertification.com/ What the hell is wrong with you? You could at the VERY MINIMUM, let people know the link was not work safe. Why would you post that crap here? Some people. -MT [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: Gmail isnt the be-all and end-all for flashcoders
HTML mail IS banned on all HoF lists. That is to say, mail that ONLY has an HTML part is banned. Mail that has both an HTML part and a plain text part is processed properly. I've posted from GMail a number of times with no problem. I'd ask the Flashcoders listmanager for information on how they parse the mail to determine what to block. I've found out that you can't post to flashcoders from gmail apparently, because gmail doesnt offer any way to send text-only mail. Since flashcoders apparently rejects html email, and gmail only sends html email, you can't post to flashcoders if you use gmail. that's a lesson to learn if it's ever proposed to ban html email on cf-talk.It'll mean all those people who scrambled to get gmail accounts wont be able to post. Or have i got the wrong end of the stick again? -- Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT- NEWS - cfcertification.com
Asim, How about forewarning us next time instead of letting us click on a link to an adult site. Great job! Or perhaps this is your site and you're just a spammer. geez. Get some common sense. Rey... - Original Message - From: Asim Manzur [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 9:59 AM Subject: OT- NEWS - cfcertification.com Did anyone recently visit http://www.cfcertification.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: [Spam?] Re: CFHTTP
It isn't. It is outputting a script tag that is writing the correct url. There is a big difference. If you look in the source code, the url isn't there. -Original Message- From: Luc Deault [mailto:[EMAIL PROTECTED] Sent: 14 September 2004 15:02 To: CF-Talk Subject: [Spam?] Re: CFHTTP Don't want to be a pest but why is my first cfoutput actually outputting the right string? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Variable names stored in database
I would like to store style sheet information in a database but need to be able to change some of the parameters on the fly.If a straight file doing the variable substitutions is no big deal.
cfquery name=specs datasource=#dsn#
SELECT
color
FROM
spec_table
WHERE
customer = 42
/cfquery
cfset variables.bgcolor = spec.color
cfoutput
style type=text/css
div.template1{
width: 300;
height: 250;
border: 1px solid black;
background-color : #variables.bgcolor#;
}
/style
/cfoutput
Yes I know I don't need to use the extra step in this case but if it is stored in a DB I need constant names in string.
So is it possible to store the style block ina DB and then do the variable replacement?
Shawn McKee
Mgr., Web Development
http://www.newsstand.com
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
seperating CF and IIS
Hey there, we are running ColdFusion and IIS on the same windows server.I always thought that this was the recommended way, however, while thumbing through the CFMX developers study guide is mentions on page 386 to seperate these servers.Anyone have any insight to the best way of managing this?Anyone run in distributed mode and see issues or better performance? Any thoughts? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Gmail isnt the be-all and end-all for flashcoders
I've found out that you can't post to flashcoders from gmail apparently, because gmail doesnt offer any way to send text-only mail. Since flashcoders apparently rejects html email, and gmail only sends html email, you can't post to flashcoders if you use gmail. that's a lesson to learn if it's ever proposed to ban html email on cf-talk.It'll mean all those people who scrambled to get gmail accounts wont be able to post. Or have i got the wrong end of the stick again? I suspect there's something else going on. We have over a hundred people with gmail addresses on Flashcoders, and they're able to post from gmail. However, I don't use gmail, nor do I have a gmail account, so I can't tell you what you need to do to configure it correctly. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT- NEWS - cfcertification.com
Don't get mad guys, I use to goto that site, it had some certification preperation that time for cfmx, I just checked that today and found that. I was thinking that might be someone knows about it that what happened, it has been hacked or what. my intension was not going there to see the adult content. Hope that I cleared my point of view. Asim, How about forewarning us next time instead of letting us click on a link to an adult site. Great job! Or perhaps this is your site and you're just a spammer. geez. Get some common sense. Rey... - Original Message - From: Asim Manzur [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 9:59 AM Subject: OT- NEWS - cfcertification.com Did anyone recently visit http://www.cfcertification.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: seperating CF and IIS
Hey there, we are running ColdFusion and IIS on the same windows server.I always thought that this was the recommended way, however, while thumbing through the CFMX developers study guide is mentions on page 386 to seperate these servers.Anyone have any insight to the best way of managing this?Anyone run in distributed mode and see issues or better performance? In general, people use distributed mode for security, not performance. In general, I've usually seen lower performance with distributed mode, but like anything else that can certainly vary depending on circumstances. Very few people use distributed mode. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: HTTPS post
Thanks Lee, That worked great! - Original Message - From: Lee Howard To: CF-Talk Sent: Monday, September 13, 2004 8:57 PM Subject: Re: HTTPS post How about using a com object.Something like this in VB. Dim objXMLHTTP, xml, response Set xml = CreateObject(MSXML2.XMLHTTP) ' Notice the two changes in the next two lines: xml.Open POST, http://www.webserver.com/Find, false xml.setRequestHeader Content-Type, application/x-www-form-urlencoded xml.Send action=""> response = xml.responseText Set xml = Nothing found something similar here: http://www.developerfusion.com/show/3272/2/ On Mon, 13 Sep 2004 12:18:39 -0400, Mickael [EMAIL PROTECTED] wrote: Hello All, This is a question for the gurus on the this list.I have a request from a client to do an HTTPS post to their webpage, this is not that difficult if I use CF on a webserver no biggie. They client want this however to run off of a pc not runnnga webserver or CF.They have the ability to create HTML pages using VB6, would anyone on this list know how an html page could be formated and have the form submitted to a remote page via HTTPs? Does this make sense? Thanks Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT- NEWS - cfcertification.com
Did anyone recently visit http://www.cfcertification.com/ Wow. The certification process has changed a lot since my last test, let me tell you. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Download link broken on Macromedia.com
On Tue, 14 Sep 2004 04:30:46 -0400, Cutter [EMAIL PROTECTED] wrote: I had a similar problem with downloads from the MM site. Turned out my firewall was blocking downloads of types not specified, and for some reason the original packet info sent from the MM site doesn't appear as an exe but as something else. Interesting. I can ask the web team about that. I also believe that in order to download bits from that site, you need to access it from a macromedia.com URL and you need cookies enabled (to prevent direct download bits being distributed - which allows Macromedia to switch the names of download files whenever they update bits). -- Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: seperating CF and IIS
Hey Dave, that is how I understood it.Unless I read wrong, the developers guide recommeded distributed mode.I was wondering what others were doing. Thanks Dave. Michael [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT- NEWS - cfcertification.com
RE: OT- NEWS - cfcertification.com Don't visit this site - it has very little to do with ColdFusion. READ: Pr0n Guy McDowell Web Developer [EMAIL PROTECTED] - Magma Communications Ltd. t: 613.228.3565 x6348 f: 613.228.8313 http://websites.magma.ca This e-mail message is confidential, may be privileged and is intended for the exclusive use of the addressee.Any other person is strictly prohibited from disclosing, distributing or reproducing it.If the addressee cannot be reached or is unknown to you, please inform the sender by return e-mail immediately and delete this e-mail message and destroy all copies.Due to the inherent risks associated with the Internet, we assume no responsibility for unauthorized interception of any Internet communication with you or the transmission of computer viruses.Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT- NEWS - cfcertification.com
On Tuesday 14 Sep 2004 15:27 pm, Asim Manzur wrote: www.cfcertification.com/ http://web.archive.org/web/*/http://www.cfcertification.com/ -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT- NEWS - cfcertification.com
What pron? .. It has articles about CFMX and components. I don't know what site you are visiting right now? Maybe some cache browser history? Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Regular Expressions: Extract code between BODY tags
All: I have a complete HTML file, beginning with doctype declaration and ending with a closing HTML tag, from which I'd like to programmatically strip away everything but the code between (and not including) the BODY tags.That is, only the code (including tags) between the BODY tags should remain.Can anyone provide the RE to accomplish this? TIA -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT- NEWS - cfcertification.com
That is some of the worst Photoshopping I have ever seen... Ray At 10:40 AM 9/14/2004, you wrote: RE: OT- NEWS - cfcertification.com Don't visit this site - it has very little to do with ColdFusion. READ: Pr0n Guy McDowell Web Developer [EMAIL PROTECTED] - Magma Communications Ltd. t: 613.228.3565 x6348 f: 613.228.8313 http://websites.magma.ca This e-mail message is confidential, may be privileged and is intended for the exclusive use of the addressee.Any other person is strictly prohibited from disclosing, distributing or reproducing it.If the addressee cannot be reached or is unknown to you, please inform the sender by return e-mail immediately and delete this e-mail message and destroy all copies.Due to the inherent risks associated with the Internet, we assume no responsibility for unauthorized interception of any Internet communication with you or the transmission of computer viruses.Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Gmail isnt the be-all and end-all for flashcoders
Want one? Got too many :D On Tue, 14 Sep 2004 10:29:40 -0400, Dave Watts [EMAIL PROTECTED] wrote: I've found out that you can't post to flashcoders from gmail apparently, because gmail doesnt offer any way to send text-only mail. Since flashcoders apparently rejects html email, and gmail only sends html email, you can't post to flashcoders if you use gmail. that's a lesson to learn if it's ever proposed to ban html email on cf-talk.It'll mean all those people who scrambled to get gmail accounts wont be able to post. Or have i got the wrong end of the stick again? I suspect there's something else going on. We have over a hundred people with gmail addresses on Flashcoders, and they're able to post from gmail. However, I don't use gmail, nor do I have a gmail account, so I can't tell you what you need to do to configure it correctly. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Regular Expressions: Extract code between BODY tags
rereplacenocase(string, 'body[^]*(.+)/body', \1) Your looking for the body tag with anything in it, then everything after that body tag that does not include the ending body tag. Using REReplace is the most efficient here as your peeling off what you don't want (i.e. whats not body content) _ From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 10:48 AM To: CF-Talk Subject: Regular Expressions: Extract code between BODY tags All: I have a complete HTML file, beginning with doctype declaration and ending with a closing HTML tag, from which I'd like to programmatically strip away everything but the code between (and not including) the BODY tags.That is, only the code (including tags) between the BODY tags should remain.Can anyone provide the RE to accomplish this? TIA -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT- NEWS - cfcertification.com
thanks thomas. now guys visit this link http://web.archive.org/web/*/http://www.cfcertification.com/ doesn't have any p0rn there, and it shows that this site had a coldfusion certificate practice test. On Tuesday 14 Sep 2004 15:27 pm, Asim Manzur wrote: www.cfcertification.com/ http://web.archive.org/web/*/http://www.cfcertification.com/ -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Oracle Stored Procedures
Thanks Adam.The change has been made but I'm still getting the same
error.
Here is the new specification:
PROCEDURE TESTPCKG
Argument NameTypeIN/OUT
Default?
CURRETURNSETREF CURSORIN/OUT
The code I'm using to call it is:
cfstoredproc procedure = Test01.TestPckg
dataSource = #ds#
cfprocresult name=rAcct
/cfstoredproc
cfdump var=#rAcct#
We've also tried calling it with:
cfquery name=testSP datasource=#ds#
{Call Test01.TestPckg}
/cfquery
The error we are seeing is:
[Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'TESTPCKG'
ORA-06550: line 1, column 7: PL/SQL: Statement ignored
Any further input is greatly appreciated as I seem to have exhausted the
macromedia knowledge base articles.
Thanks,
Scott
-Original Message-
From: Adrocknaphobia [mailto:[EMAIL PROTECTED]
Sent: Monday, September 13, 2004 10:18 AM
To: CF-Talk
Subject: Re: Oracle Stored Procedures
That cursor return needs to be set to IN OUT, not just OUT.
-Adam
- Original Message -
From: Scott Mulholland [EMAIL PROTECTED]
Date: Mon, 13 Sep 2004 11:12:19 -0400
Subject: RE: Oracle Stored Procedures
To: CF-Talk [EMAIL PROTECTED]
Janet,
Thanks for the tip!
PROCEDURE TESTPCKG
Argument NameTypeIN/OUT
Default?
CURRETURNSETREF CURSOROUT
-Original Message-
From: Janet Schmitt [mailto:[EMAIL PROTECTED]
Sent: Monday, September 13, 2004 9:23 AM
To: CF-Talk
Subject: RE: Oracle Stored Procedures
In SQL*Plus, you can see the package specification and hence the
procedure
definition by entering the DESC command at the SQL*Plus prompt.For
example;DESC schema_name.package_name;
The DESC will not show you the code inside the package but it will show
you
what each procedure expects for parameters.
HTH.
Janet.
At 05:01 PM 9/10/2004 -0400, you wrote:
I do not have the package unfortunately.
-Original Message-
From: Janet Schmitt [mailto:[EMAIL PROTECTED]
Sent: Friday, September 10, 2004 12:49 PM
To: CF-Talk
Subject: Re: Oracle Stored Procedures
What does the package specification for TESTPCKG look like?
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: Oracle Stored Procedures
Hrmm... what user is defined in your datasource settings? Are you
logging in as the schema owner?
-Adam
- Original Message -
From: Scott Mulholland [EMAIL PROTECTED]
Date: Tue, 14 Sep 2004 10:57:27 -0400
Subject: RE: Oracle Stored Procedures
To: CF-Talk [EMAIL PROTECTED]
Thanks Adam.The change has been made but I'm still getting the same
error.
Here is the new specification:
PROCEDURE TESTPCKG
Argument NameTypeIN/OUT
Default?
CURRETURNSETREF CURSORIN/OUT
The code I'm using to call it is:
cfstoredproc procedure = Test01.TestPckg
dataSource = #ds#
cfprocresult name=rAcct
/cfstoredproc
cfdump var=#rAcct#
We've also tried calling it with:
cfquery name=testSP datasource=#ds#
{Call Test01.TestPckg}
/cfquery
The error we are seeing is:
[Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'TESTPCKG'
ORA-06550: line 1, column 7: PL/SQL: Statement ignored
Any further input is greatly appreciated as I seem to have exhausted the
macromedia knowledge base articles.
Thanks,
Scott
-Original Message-
From: Adrocknaphobia [mailto:[EMAIL PROTECTED]
Sent: Monday, September 13, 2004 10:18 AM
To: CF-Talk
Subject: Re: Oracle Stored Procedures
That cursor return needs to be set to IN OUT, not just OUT.
-Adam
- Original Message -
From: Scott Mulholland [EMAIL PROTECTED]
Date: Mon, 13 Sep 2004 11:12:19 -0400
Subject: RE: Oracle Stored Procedures
To: CF-Talk [EMAIL PROTECTED]
Janet,
Thanks for the tip!
PROCEDURE TESTPCKG
Argument NameTypeIN/OUT
Default?
CURRETURNSETREF CURSOROUT
-Original Message-
From: Janet Schmitt [mailto:[EMAIL PROTECTED]
Sent: Monday, September 13, 2004 9:23 AM
To: CF-Talk
Subject: RE: Oracle Stored Procedures
In SQL*Plus, you can see the package specification and hence the
procedure
definition by entering the DESC command at the SQL*Plus prompt.For
example;DESC schema_name.package_name;
The DESC will not show you the code inside the package but it will show
you
what each procedure expects for parameters.
HTH.
Janet.
At 05:01 PM 9/10/2004 -0400, you wrote:
I do not have the package unfortunately.
-Original Message-
From: Janet Schmitt [mailto:[EMAIL PROTECTED]
Sent: Friday, September 10, 2004 12:49 PM
To: CF-Talk
Subject: Re: Oracle Stored Procedures
What does the package specification for TESTPCKG look like?
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: Incorporating Javascript to confirm into a document...
Pascal,
What does the button look like with this example? I finally got to this to work by calling an external file if the user pressed 'OK', but this is really ugly and really not an exceptable approach.
What you suggest is exactly what I want to happen. If they hit cancel, then nothing happens at all.
I tried to do something like this, which didn't work
INPUT TYPE=image NAME=delete SRC="" ALT=Delete Presentation you really want to delete this presentation??);
A JS variable is not passed when you post the form. You can use a hidden
form field. But easier is to just do the whole thing in JS and don't
post if the user clicks cancel:
function delete_presentation()
{
return confirm(Do you really want to delete this
presentation??);
}
Pascal
-Original Message-
From: Brett Barnhart [mailto:[EMAIL PROTECTED]
Sent: 13 September 2004 18:15
To: CF-Talk
Subject: Incorporating _javascript_ to confirm into a document...
I've been working on this all morning and I am missing something. I
have a
this
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: OT- NEWS - cfcertification.com
LMAO i want to go to the site just to see for myself but scared if i do my computer will lock up and all i'll be able to do if my boss walks in is LOL ;-) donna - Original Message - From: Asim Manzur [EMAIL PROTECTED] Date: Tue, 14 Sep 2004 10:57:52 -0400 Subject: Re: OT- NEWS - cfcertification.com To: CF-Talk [EMAIL PROTECTED] thanks thomas. now guys visit this link http://web.archive.org/web/*/http://www.cfcertification.com/ doesn't have any p0rn there, and it shows that this site had a coldfusion certificate practice test. On Tuesday 14 Sep 2004 15:27 pm, Asim Manzur wrote: www.cfcertification.com/ http://web.archive.org/web/*/http://www.cfcertification.com/ -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Oracle Stored Procedures
I am told the login I was given has full access/permissions.
-Original Message-
From: Adrocknaphobia [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 10:02 AM
To: CF-Talk
Subject: Re: Oracle Stored Procedures
Hrmm... what user is defined in your datasource settings? Are you
logging in as the schema owner?
-Adam
- Original Message -
From: Scott Mulholland [EMAIL PROTECTED]
Date: Tue, 14 Sep 2004 10:57:27 -0400
Subject: RE: Oracle Stored Procedures
To: CF-Talk [EMAIL PROTECTED]
Thanks Adam.The change has been made but I'm still getting the same
error.
Here is the new specification:
PROCEDURE TESTPCKG
Argument NameTypeIN/OUT
Default?
CURRETURNSETREF CURSORIN/OUT
The code I'm using to call it is:
cfstoredproc procedure = Test01.TestPckg
dataSource = #ds#
cfprocresult name=rAcct
/cfstoredproc
cfdump var=#rAcct#
We've also tried calling it with:
cfquery name=testSP datasource=#ds#
{Call Test01.TestPckg}
/cfquery
The error we are seeing is:
[Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'TESTPCKG'
ORA-06550: line 1, column 7: PL/SQL: Statement ignored
Any further input is greatly appreciated as I seem to have exhausted the
macromedia knowledge base articles.
Thanks,
Scott
-Original Message-
From: Adrocknaphobia [mailto:[EMAIL PROTECTED]
Sent: Monday, September 13, 2004 10:18 AM
To: CF-Talk
Subject: Re: Oracle Stored Procedures
That cursor return needs to be set to IN OUT, not just OUT.
-Adam
- Original Message -
From: Scott Mulholland [EMAIL PROTECTED]
Date: Mon, 13 Sep 2004 11:12:19 -0400
Subject: RE: Oracle Stored Procedures
To: CF-Talk [EMAIL PROTECTED]
Janet,
Thanks for the tip!
PROCEDURE TESTPCKG
Argument NameTypeIN/OUT
Default?
CURRETURNSETREF CURSOROUT
-Original Message-
From: Janet Schmitt [mailto:[EMAIL PROTECTED]
Sent: Monday, September 13, 2004 9:23 AM
To: CF-Talk
Subject: RE: Oracle Stored Procedures
In SQL*Plus, you can see the package specification and hence the
procedure
definition by entering the DESC command at the SQL*Plus prompt.For
example;DESC schema_name.package_name;
The DESC will not show you the code inside the package but it will show
you
what each procedure expects for parameters.
HTH.
Janet.
At 05:01 PM 9/10/2004 -0400, you wrote:
I do not have the package unfortunately.
-Original Message-
From: Janet Schmitt [mailto:[EMAIL PROTECTED]
Sent: Friday, September 10, 2004 12:49 PM
To: CF-Talk
Subject: Re: Oracle Stored Procedures
What does the package specification for TESTPCKG look like?
_
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: Regular Expressions: Extract code between BODY tags
You, sir, are a saint.Thank you. Here's the code I ended up using: REReplaceNoCase(contents, '.+body[^]*(.+)/body.+', \1) As it was, it removed the BODY tags but not the contents before and after them. Again, thanks. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ Michael Dinowitz wrote: rereplacenocase(string, 'body[^]*(.+)/body', \1) Your looking for the body tag with anything in it, then everything after that body tag that does not include the ending body tag. Using REReplace is the most efficient here as your peeling off what you don't want (i.e. whats not body content) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Regular Expressions: Extract code between BODY tags
The additions are correct. I was a bit hasty in my posting. _ From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 11:20 AM To: CF-Talk Subject: RE: Regular Expressions: Extract code between BODY tags You, sir, are a saint.Thank you. Here's the code I ended up using: REReplaceNoCase(contents, '.+body[^]*(.+)/body.+', \1) As it was, it removed the BODY tags but not the contents before and after them. Again, thanks. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ Michael Dinowitz wrote: rereplacenocase(string, 'body[^]*(.+)/body', \1) Your looking for the body tag with anything in it, then everything after that body tag that does not include the ending body tag. Using REReplace is the most efficient here as your peeling off what you don't want (i.e. whats not body content) _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Oracle Stored Procedures
Ask them for the schema owner just to test. If I had a dime for every
dba that told me I had all the privs I needed well... lets just
say the CEO of Coinstar and I would be on a first name basis.
I'm going to try some things here to see if I can recreate this problem.
-Adam
- Original Message -
From: Scott Mulholland [EMAIL PROTECTED]
Date: Tue, 14 Sep 2004 11:13:25 -0400
Subject: RE: Oracle Stored Procedures
To: CF-Talk [EMAIL PROTECTED]
I am told the login I was given has full access/permissions.
-Original Message-
From: Adrocknaphobia [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 10:02 AM
To: CF-Talk
Subject: Re: Oracle Stored Procedures
Hrmm... what user is defined in your datasource settings? Are you
logging in as the schema owner?
-Adam
- Original Message -
From: Scott Mulholland [EMAIL PROTECTED]
Date: Tue, 14 Sep 2004 10:57:27 -0400
Subject: RE: Oracle Stored Procedures
To: CF-Talk [EMAIL PROTECTED]
Thanks Adam.The change has been made but I'm still getting the same
error.
Here is the new specification:
PROCEDURE TESTPCKG
Argument NameTypeIN/OUT
Default?
CURRETURNSETREF CURSORIN/OUT
The code I'm using to call it is:
cfstoredproc procedure = Test01.TestPckg
dataSource = #ds#
cfprocresult name=rAcct
/cfstoredproc
cfdump var=#rAcct#
We've also tried calling it with:
cfquery name=testSP datasource=#ds#
{Call Test01.TestPckg}
/cfquery
The error we are seeing is:
[Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'TESTPCKG'
ORA-06550: line 1, column 7: PL/SQL: Statement ignored
Any further input is greatly appreciated as I seem to have exhausted the
macromedia knowledge base articles.
Thanks,
Scott
-Original Message-
From: Adrocknaphobia [mailto:[EMAIL PROTECTED]
Sent: Monday, September 13, 2004 10:18 AM
To: CF-Talk
Subject: Re: Oracle Stored Procedures
That cursor return needs to be set to IN OUT, not just OUT.
-Adam
- Original Message -
From: Scott Mulholland [EMAIL PROTECTED]
Date: Mon, 13 Sep 2004 11:12:19 -0400
Subject: RE: Oracle Stored Procedures
To: CF-Talk [EMAIL PROTECTED]
Janet,
Thanks for the tip!
PROCEDURE TESTPCKG
Argument NameTypeIN/OUT
Default?
CURRETURNSETREF CURSOROUT
-Original Message-
From: Janet Schmitt [mailto:[EMAIL PROTECTED]
Sent: Monday, September 13, 2004 9:23 AM
To: CF-Talk
Subject: RE: Oracle Stored Procedures
In SQL*Plus, you can see the package specification and hence the
procedure
definition by entering the DESC command at the SQL*Plus prompt.For
example;DESC schema_name.package_name;
The DESC will not show you the code inside the package but it will show
you
what each procedure expects for parameters.
HTH.
Janet.
At 05:01 PM 9/10/2004 -0400, you wrote:
I do not have the package unfortunately.
-Original Message-
From: Janet Schmitt [mailto:[EMAIL PROTECTED]
Sent: Friday, September 10, 2004 12:49 PM
To: CF-Talk
Subject: Re: Oracle Stored Procedures
What does the package specification for TESTPCKG look like?
_
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: Regular Expressions: Extract code between BODY tags
Actually this should be rereplacenocase(string, '.*body[^]*(.+)/body.*', \1) Pascal -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: 14 September 2004 16:54 To: CF-Talk Subject: [Spam?] RE: Regular Expressions: Extract code between BODY tags rereplacenocase(string, 'body[^]*(.+)/body', \1) Your looking for the body tag with anything in it, then everything after that body tag that does not include the ending body tag. Using REReplace is the most efficient here as your peeling off what you don't want (i.e. whats not body content) _ From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 10:48 AM To: CF-Talk Subject: Regular Expressions: Extract code between BODY tags All: I have a complete HTML file, beginning with doctype declaration and ending with a closing HTML tag, from which I'd like to programmatically strip away everything but the code between (and not including) the BODY tags. That is, only the code (including tags) between the BODY tags should remain. Can anyone provide the RE to accomplish this? TIA -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Incorporating Javascript to confirm into a document...
INPUT TYPE=image NAME=delete SRC=""> ALT=Delete Presentation confirm(Do you really want to delete this presentation??); Pascal -Original Message- From: Brett Barnhart [mailto:[EMAIL PROTECTED] Sent: 14 September 2004 17:07 To: CF-Talk Subject: Re: Incorporating _javascript_ to confirm into a document... Pascal, What does the button look like with this example? I finally got to this to work by calling an external file if the user pressed 'OK', but this is really ugly and really not an exceptable approach. What you suggest is exactly what I want to happen. If they hit cancel, then nothing happens at all. I tried to do something like this, which didn't work INPUT TYPE=image NAME=delete SRC=""> ALT=Delete Presentation you really want to delete this presentation??); [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Regular Expressions: Extract code between BODY tags
Cool.Again, thanks. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ Michael Dinowitz wrote: The additions are correct. I was a bit hasty in my posting. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Incorporating Javascript to confirm into a document...
But you're still going to need to do something if they hit 'OK',
right?Which would require you to 'call an external file'.
You should really incorporate both the _javascript_ confirm and the handler
for when they click 'OK'.Take a look at the page below (view source) to
see what I am talking about.
http://www.cvwp.com/test/form.html
That help?
Ray
At 11:06 AM 9/14/2004, you wrote:
Pascal,
What does the button look like with this example? I finally got to this
to work by calling an external file if the user pressed 'OK', but this is
really ugly and really not an exceptable approach.
What you suggest is exactly what I want to happen. If they hit cancel,
then nothing happens at all.
I tried to do something like this, which didn't work
INPUT TYPE=image NAME=delete SRC=""
ALT=Delete Presentation you really want to delete
this presentation??);
A JS variable is not passed when you post the form. You can use a hidden
form field. But easier is to just do the whole thing in JS and don't
post if the user clicks cancel:
function delete_presentation()
{
return confirm(Do you really want to delete this
presentation??);
}
Pascal
-Original Message-
From: Brett Barnhart [mailto:[EMAIL PROTECTED]
Sent: 13 September 2004 18:15
To: CF-Talk
Subject: Incorporating _javascript_ to confirm into a document...
I've been working on this all morning and I am missing something. I
have a
this
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: OT- NEWS - cfcertification.com
I'm sure that you did not have any bad intention Asim but please, try to be a little more descriptive next time. Many people have strict work policies re: adult sites. Most people will trust that links placed here will lead to a professional site and by not being clear on what you're posting, it could be a problem. Rey... - Original Message - From: Asim Manzur [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 10:27 AM Subject: Re: OT- NEWS - cfcertification.com Don't get mad guys, I use to goto that site, it had some certification preperation that time for cfmx, I just checked that today and found that. I was thinking that might be someone knows about it that what happened, it has been hacked or what. my intension was not going there to see the adult content. Hope that I cleared my point of view. Asim, How about forewarning us next time instead of letting us click on a link to an adult site. Great job! Or perhaps this is your site and you're just a spammer. geez. Get some common sense. Rey... - Original Message - From: Asim Manzur [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 9:59 AM Subject: OT- NEWS - cfcertification.com Did anyone recently visit http://www.cfcertification.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Quotes in XML Output
Hi all, I'm pulling data from a db and writing to an XML file.The data from the description field sometimes has quotes () surrounding the text.Im generating the XML, I've tried to use #Replace(qCal.description,, ,ALL)# to remove the quotes, but an error gets thrown.How do I solve? cfquery name=qCal datasource... SELECT eventTitle, description FROM someTable /cfquery cfsavecontent variable = xmlDoc events cfoutput query = qCal event title=#Trim(qCal.eventTitle)# description=qCal.description / /cfoutput /events /cfsavecontent [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SuSE Linux Enterprise Server 9 anyone?
hello all, Are/Have any of you installed SuSE Linux Enterprise Server 9 which was just released last month and see how it is with MX? We are still deciding if we want to install version 9 or current version 8. The key is the verity search tool for files which currently does not work under our Nix platform. Hopefully Blackstone would improve on things even under version 9. feedbacks appreciated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Regular Expressions: Extract code between BODY tags
Either the .* or the .+ will work as the original poster said that the body tags would be within a validly formatted HTML document. This brings up a question of the relative merits of the * and + modifiers when doing large matches. I'll have to look in Mastering RegEx if there's any known speed or overhead differences. I doubt it, but :) _ From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 11:25 AM To: CF-Talk Subject: RE: Regular Expressions: Extract code between BODY tags Actually this should be rereplacenocase(string, '.*body[^]*(.+)/body.*', \1) Pascal -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: 14 September 2004 16:54 To: CF-Talk Subject: [Spam?] RE: Regular Expressions: Extract code between BODY tags rereplacenocase(string, 'body[^]*(.+)/body', \1) Your looking for the body tag with anything in it, then everything after that body tag that does not include the ending body tag. Using REReplace is the most efficient here as your peeling off what you don't want (i.e. whats not body content) _ From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 10:48 AM To: CF-Talk Subject: Regular Expressions: Extract code between BODY tags All: I have a complete HTML file, beginning with doctype declaration and ending with a closing HTML tag, from which I'd like to programmatically strip away everything but the code between (and not including) the BODY tags. That is, only the code (including tags) between the BODY tags should remain. Can anyone provide the RE to accomplish this? TIA -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Quotes in XML Output
XMLFormat()? -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: 14 September 2004 17:32 To: CF-Talk Subject: Quotes in XML Output Hi all, I'm pulling data from a db and writing to an XML file.The data from the description field sometimes has quotes () surrounding the text. Im generating the XML, I've tried to use #Replace(qCal.description,, ,ALL)# to remove the quotes, but an error gets thrown.How do I solve? cfquery name=qCal datasource... SELECT eventTitle, description FROM someTable /cfquery cfsavecontent variable = xmlDoc events cfoutput query = qCal event title=#Trim(qCal.eventTitle)# description=qCal.description / /cfoutput /events /cfsavecontent [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT- NEWS - cfcertification.com
I agreed, Will be careful next time. TYVM I'm sure that you did not have any bad intention Asim but please, try to be a little more descriptive next time. Many people have strict work policies re: adult sites. Most people will trust that links placed here will lead to a professional site and by not being clear on what you're posting, it could be a problem. Rey... - Original Message - From: Asim Manzur [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 10:27 AM Subject: Re: OT- NEWS - cfcertification.com Don't get mad guys, I use to goto that site, it had some certification preperation that time for cfmx, I just checked that today and found that. I was thinking that might be someone knows about it that what happened, it has been hacked or what. my intension was not going there to see the adult content. to [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Appointments scheduling system
A basic appointments system can be found on the CF exchange on MM site - this would give you a good foundation - just search for appointment. - Original Message - From: Chris Kavanagh [EMAIL PROTECTED] Date: Mon, 13 Sep 2004 02:43:52 +0100 Subject: Appointments scheduling system To: CF-Talk [EMAIL PROTECTED] Dear list! So I've got to make an appointment scheduling system for a doctor's surgery.I really can't be bothered to code it myself...does anyone know of an existing CF system I could buy, or any open source stuff I could easily repurpose? Kind regards, CK. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT- NEWS - cfcertification.com
Micha Schopman wrote: What pron? Overprised porn :) It has articles about CFMX and components. I don't know what site you are visiting right now? Maybe some cache browser history? Since dig and telnet don't cache I think it is more likely you are the one having caching issues. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Null null error ARGHHH!
Hi folks, I'm running CF MX 6.1 (with updater 3 installed) and every now and then, my users are getting the following error: null null brThe error occurred on line 64. The line number can be different.The file can be different.It's not consistent.In this case, the line number was the following: CFIF URL.SaveComplete OR URL.Questions Both URL.Savecomplete and URL.Questions are set up with default parameters of 0. These errors do NOT show up in the error logs.The only way I see them is because I have a custom error handling program that sends me a dump of all variables when an error occurs on the site.In this case, the URL.SaveComplete had a value of 5 and URL.Questions had a value of 0. There is no reason why this line of code should have errored out, nor is there any reason given (null null). Any ideas or anyone else who has experienced this AND gotten it resolved? FYI this was happening beofre updater 3 as well. Sincerely, Dave Phillips [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Regular Expressions: Extract code between BODY tags
I posted this before the answer from Mosh, but our mail is going out very slowly lately. It was a correction on your post (.* OR .+ was missing before and after your regexp), not on Mosh's second post (that I didn't have at that time). .+ or .* will of course both work and I also doubt there is any difference. Pascal -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: 14 September 2004 17:34 To: CF-Talk Subject: [Spam?] RE: Regular Expressions: Extract code between BODY tags Either the .* or the .+ will work as the original poster said that the body tags would be within a validly formatted HTML document. This brings up a question of the relative merits of the * and + modifiers when doing large matches. I'll have to look in Mastering RegEx if there's any known speed or overhead differences. I doubt it, but :) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Currently running page requests
there was some JSP code for this floating around abit ago.IIRC,
credit goes to Pete Frietag.I never got this to work for me though.
Some sort of caste error and I'm far from a Java guru.Anyone get
this to work?
%
Thread thread = Thread.currentThread();
ThreadGroup threadGroup = thread.getThreadGroup();
int count = threadGroup.activeCount();
Thread[] threads = new Thread[count];
count = threadGroup.enumerate(threads);
out.println(Thread Count: + count + br);
for (int i=0;icount;i++) {
out.println(i: + i + br);
try
{
jrunx.scheduler.WorkerThread t = (jrunx.scheduler.WorkerThread)threads[i];
jrun.servlet.http.WebEndpoint endPoint =
(jrun.servlet.http.WebEndpoint)t.getServletRequest();
out.println(endPoint.getServerName() + endPoint.getRequestURI() + br);
}
catch (Exception e) { }
}
%
- Original Message -
From: Adrocknaphobia [EMAIL PROTECTED]
Date: Tue, 14 Sep 2004 09:34:27 -0400
Subject: Re: Currently running page requests
To: CF-Talk [EMAIL PROTECTED]
Well I've found the stack trace invaluable in terms of information.
But the fact that you have to have your server running through command
prompt makes its pretty useless.
For example in a production app, you have to shut down the server.
(not cool) Then restart it in a command window (not cool), then you
cannot log off! (not cool) Although I'm told this is a windows only
issue. Still, its great insight into problems... but you cant really
get it when you need it.
-Adam
- Original Message -
From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]
Date: Tue, 14 Sep 2004 14:26:01 +0100
Subject: RE: Currently running page requests
To: CF-Talk [EMAIL PROTECTED]
And its nigh on useless in my opinion.
_
From: Tim Blair [mailto:[EMAIL PROTECTED]
Sent: 14 September 2004 14:23
To: CF-Talk
Subject: RE: Currently running page requests
Is there any way to get a list of currently running
page requests on the server so I can keep track or them?
You can perform a dump of the current stack trace, which will list
(amongst a big pile of other stuff) what's requests are currently being
processed by CF.See the MM technote about it:
http://www.macromedia.com/support/coldfusion/ts/documents/tn18339.htm
Tim.
--
---
Badpen Tech - CF and web-tech: http://tech.badpen.com/
---
RAWNET LTD - Internet, New Media and ebusiness Gurus.
WE'VE MOVED - for our new address, please visit our
website at http://www.rawnet.com/ or call us any time
on 0800 294 24 24.
---
This message may contain information which is legally
privileged and/or confidential.If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of rawnet limited,
unless otherwise explicitly and independently indicated
by an authorised representative of rawnet limited.
---
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: Quotes in XML Output
That's it! Thanks, Mark From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 11:34 AM To: CF-Talk Subject: RE: Quotes in XML Output XMLFormat()? -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: 14 September 2004 17:32 To: CF-Talk Subject: Quotes in XML Output Hi all, I'm pulling data from a db and writing to an XML file.The data from the description field sometimes has quotes () surrounding the text. Im generating the XML, I've tried to use #Replace(qCal.description,, ,ALL)# to remove the quotes, but an error gets thrown.How do I solve? cfquery name=qCal datasource... SELECT eventTitle, description FROM someTable /cfquery cfsavecontent variable = xmlDoc events cfoutput query = qCal event title=#Trim(qCal.eventTitle)# description=qCal.description / /cfoutput /events /cfsavecontent _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
ColdFusion form validation Mac Safari
using the innate form validation in cfmx (using a regular _expression_ with the pattern of (^[_a-zA-Z0-9-]+(\.[_a-zA-Z0-9-]+)[EMAIL PROTECTED](\.[a-zA-Z0-9-]+)*\.(([a-zA-Z]{2,3})|(aero|coop|info|museum|name))$)|(^ *$)) seems to be broken in Mac Safari?
It will catch the incorrectly formatted input and pop an error fine, but upon correction of the error and re-submittal of the form, it doesn't seem to recognize the new input and just perpetually pops the old error over and over. Again, this is only on Mac Safari (which I had someone verify the error for me, but don't have access to a Mac with OSX to really check it out good myself) - i've tested with Netscape 4+, IE (on both pc and mac), Firefox (on both pc and mac), Opera and so on... it's driving me nuts!
I've searched everywhere and can't seem to find any mention of this specifically hope someone can verify/help/give more information!
thanks,
amanda
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: Oracle Stored Procedures
It might be something to do with the way the refcursor is defined in the package.Would they be willing to change the package so the refcursor is defined like this? CREATE OR REPLACE PACKAGE schemaname.testpckg IS TYPE curreturnset_type_ref_cursor IS REF CURSOR; PROCEDURE testpckg( curreturnset IN OUT curreturnset_type_ref_cursor); END; At 10:57 AM 9/14/2004 -0400, you wrote: Here is the new specification: PROCEDURE TESTPCKG Argument NameTypeIN/OUT Default? CURRETURNSETREF CURSORIN/OUT The code I'm using to call it is: cfstoredproc procedure = Test01.TestPckg dataSource = #ds# cfprocresult name=rAcct /cfstoredproc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Null null error ARGHHH!
Same here, I get the Null Null error randomly on one of the 40 small sites we host on one sever. From what I can tell it *maybe* related to a bad session var.A user will get the error on the first page and what ever page they try to go to whey will still get the error. I have only experienced the error personally myself once last year. On another server and a much larger site I was using client vars and had the same Null Null problem.I switched over to session vars and the null null problem went way on that server. I also rewrote much of the code on the site in a major site update so I can not say for 100% sure it was the client vars. Anyone else have any ideas? Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com http://www.vividmedia.com/ 608.270.9770 _ From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 10:53 AM To: CF-Talk Subject: Null null error ARGHHH! Hi folks, I'm running CF MX 6.1 (with updater 3 installed) and every now and then, my users are getting the following error: null null brThe error occurred on line 64. The line number can be different.The file can be different.It's not consistent.In this case, the line number was the following: CFIF URL.SaveComplete OR URL.Questions Both URL.Savecomplete and URL.Questions are set up with default parameters of 0. These errors do NOT show up in the error logs.The only way I see them is because I have a custom error handling program that sends me a dump of all variables when an error occurs on the site.In this case, the URL.SaveComplete had a value of 5 and URL.Questions had a value of 0. There is no reason why this line of code should have errored out, nor is there any reason given (null null). Any ideas or anyone else who has experienced this AND gotten it resolved? FYI this was happening beofre updater 3 as well. Sincerely, Dave Phillips _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Incorporating Javascript to confirm into a document...
Right, and that is the approach that I got to work. But, I really don't want to have to call an external file. Right now, it reloads the current page when a button is pressed and tests to see which button is pressed. I just need a way to block the reload if they didn't mean to press the button. So, all the script is on one page. But you're still going to need to do something if they hit 'OK', right?Which would require you to 'call an external file'. You should really incorporate both the _javascript_ confirm and the handler for when they click 'OK'.Take a look at the page below (view source) to see what I am talking about. http://www.cvwp.com/test/form.html That help? Ray At 11:06 AM 9/14/2004, you wrote: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Oracle Stored Procedures
Scott - The other thing you might want to look at is what Oracle drivers are being used.I know there are issues with some of the drivers and Oracle stored procedures. Here isa technote regarding one Oracle driver that mentions support for Oracle refcursors: http://www.macromedia.com/support/coldfusion/ts/documents/tn18344.htm Janet. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Incorporating Javascript to confirm into a document...
If you are interested, I'd be happy to send you the code. I am adding to something that someone else wrote, so I am not 100% sure how it all works. But you're still going to need to do something if they hit 'OK', right?Which would require you to 'call an external file'. You should really incorporate both the _javascript_ confirm and the handler for when they click 'OK'.Take a look at the page below (view source) to see what I am talking about. http://www.cvwp.com/test/form.html That help? Ray At 11:06 AM 9/14/2004, you wrote: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Null null error ARGHHH!
FYI - I'm only using session vars, not client vars.Below is a partial dump of the session var for when one of these errors occurred: cfid 349252 cftoken 68847985 contactid 0 firstname [empty string] sessionid PLP_349252_68847985 sitename [empty string] sitevisitedid 0 urltoken CFID=349252CFTOKEN=68847985 The custom session vars I'm using aren't filled in at but they should be. Dave _ From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 11:18 AM To: CF-Talk Subject: RE: Null null error ARGHHH! Same here, I get the Null Null error randomly on one of the 40 small sites we host on one sever. From what I can tell it *maybe* related to a bad session var.A user will get the error on the first page and what ever page they try to go to whey will still get the error. I have only experienced the error personally myself once last year. On another server and a much larger site I was using client vars and had the same Null Null problem.I switched over to session vars and the null null problem went way on that server. I also rewrote much of the code on the site in a major site update so I can not say for 100% sure it was the client vars. Anyone else have any ideas? Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com http://www.vividmedia.com/ 608.270.9770 _ From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 10:53 AM To: CF-Talk Subject: Null null error ARGHHH! Hi folks, I'm running CF MX 6.1 (with updater 3 installed) and every now and then, my users are getting the following error: null null brThe error occurred on line 64. The line number can be different.The file can be different.It's not consistent.In this case, the line number was the following: CFIF URL.SaveComplete OR URL.Questions Both URL.Savecomplete and URL.Questions are set up with default parameters of 0. These errors do NOT show up in the error logs.The only way I see them is because I have a custom error handling program that sends me a dump of all variables when an error occurs on the site.In this case, the URL.SaveComplete had a value of 5 and URL.Questions had a value of 0. There is no reason why this line of code should have errored out, nor is there any reason given (null null). Any ideas or anyone else who has experienced this AND gotten it resolved? FYI this was happening beofre updater 3 as well. Sincerely, Dave Phillips _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SOT: How to apply a style sheet to a file upload bottom.
Hi,
I am in the process of creatinga page for my endusers to upload files and
the first thing that they complained about is that the button is not the same
style as the rest of the buttons in the applications.All of the buttons are
usually a form of blue (We use IE6.0 only - internal), but the BROWSE button
will only show up
This is the color I would like the button to show:
.buttoncolor { color:#FF; background: #557799; FONT-FAMILY: Arial,
sans-serif; FONT-SIZE: 8pt; font-weight: bold;}
But I have tried to include the inline stylesheet but nothing works in the
code snippet below but all I get is the grey button.
Any ideas??
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN
html
head
titleUntitled/title
/head
body
form name=MyForm method=post action="">
enctype=multipart/form-data
It also needs to have a file selection control:
input type=file name=MyFile size=20
/body
/html
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: Incorporating Javascript to confirm into a document...
Okay.So your form handler page is the same as your regular page, just two different routes taken if they really want to press the button.Potato, Potaato. The real question is, did this finally work for you? Ray At 12:20 PM 9/14/2004, you wrote: Right, and that is the approach that I got to work. But, I really don't want to have to call an external file. Right now, it reloads the current page when a button is pressed and tests to see which button is pressed. I just need a way to block the reload if they didn't mean to press the button. So, all the script is on one page. But you're still going to need to do something if they hit 'OK', right?Which would require you to 'call an external file'. You should really incorporate both the _javascript_ confirm and the handler for when they click 'OK'.Take a look at the page below (view source) to see what I am talking about. http://www.cvwp.com/test/form.html That help? Ray At 11:06 AM 9/14/2004, you wrote: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT: How to apply a style sheet to a file upload bottom.
html
head
titleUntitled/title
style
.buttoncolor { color:#FF; background: #557799; FONT-FAMILY: Arial,
sans-serif; FONT-SIZE: 8pt; font-weight: bold;}
/style
/head
body
form name=MyForm method=post action="" enctype=multipart/form-data
It also needs to have a file selection control:
input name=MyFile type=file class=buttoncolor size=20
/body
/html
Hi,
I am in the process of creatinga page for my endusers to upload files and
the first thing that they complained about is that the button is not the same
style as the rest of the buttons in the applications.All of the buttons are
usually a form of blue (We use IE6.0 only - internal), but the BROWSE button
will only show up
This is the color I would like the button to show:
.buttoncolor { color:#FF; background: #557799; FONT-FAMILY: Arial,
sans-serif; FONT-SIZE: 8pt; font-weight: bold;}
But I have tried to include the inline stylesheet but nothing works in the
code snippet below but all I get is the grey button.
Any ideas??
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN
html
head
titleUntitled/title
/head
body
form name=MyForm method=post action="">
enctype=multipart/form-data
It also needs to have a file selection control:
input type=file name=MyFile size=20
/body
/html
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: SOT: How to apply a style sheet to a file upload bottom.
input type=file name=bla class=buttoncolour /
On Tue, 14 Sep 2004 12:28:10 -0400, Ciliotta, Mario
[EMAIL PROTECTED] wrote:
Hi,
I am in the process of creatinga page for my endusers to upload files and
the first thing that they complained about is that the button is not the same
style as the rest of the buttons in the applications.All of the buttons are
usually a form of blue (We use IE6.0 only - internal), but the BROWSE button
will only show up
This is the color I would like the button to show:
.buttoncolor { color:#FF; background: #557799; FONT-FAMILY: Arial,
sans-serif; FONT-SIZE: 8pt; font-weight: bold;}
But I have tried to include the inline stylesheet but nothing works in the
code snippet below but all I get is the grey button.
Any ideas??
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN
html
head
titleUntitled/title
/head
body
form name=MyForm method=post action="">
enctype=multipart/form-data
It also needs to have a file selection control:
input type=file name=MyFile size=20
/body
/html
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: Incorporating Javascript to confirm into a document...
INPUT TYPE=image NAME=delete SRC=""> ALT=Delete Presentation confirm(Do you really want to delete this presentation??); Pascal Thanks! That did it... FYI for archival purposes, I had to change the link to INPUT TYPE=image NAME=delete SRC="" ALT=Delete Presentation The double in onClick seemed to mess things up. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SOT: How to apply a style sheet to a file upload bottom.
All that does is turn the background of the field a color.CSS limitation,
this can't be done currently.
-Original Message-
From: Asim Manzur [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 11:33 AM
To: CF-Talk
Subject: Re: SOT: How to apply a style sheet to a file upload bottom.
html
head
titleUntitled/title
style
.buttoncolor { color:#FF; background: #557799; FONT-FAMILY: Arial,
sans-serif; FONT-SIZE: 8pt; font-weight: bold;}
/style
/head
body
form name=MyForm method=post action="">
enctype=multipart/form-data
It also needs to have a file selection control:
input name=MyFile type=file class=buttoncolor size=20
/body
/html
Hi,
I am in the process of creatinga page for my endusers to upload files and
the first thing that they complained about is that the button is not the
same
style as the rest of the buttons in the applications.All of the buttons
are
usually a form of blue (We use IE6.0 only - internal), but the BROWSE
button
will only show up
This is the color I would like the button to show:
.buttoncolor { color:#FF; background: #557799; FONT-FAMILY: Arial,
sans-serif; FONT-SIZE: 8pt; font-weight: bold;}
But I have tried to include the inline stylesheet but nothing works in the
code snippet below but all I get is the grey button.
Any ideas??
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN
html
head
titleUntitled/title
/head
body
form name=MyForm method=post action="">
enctype=multipart/form-data
It also needs to have a file selection control:
input type=file name=MyFile size=20
/body
/html
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: SOT: How to apply a style sheet to a file upload bottom.
I would recommend that you use your own graphics for the buttons. I usually use my own graphics button in place of the browse button.
All that does is turn the background of the field a color.CSS limitation,
this can't be done currently.
-Original Message-
From: Asim Manzur [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 11:33 AM
To: CF-Talk
Subject: Re: SOT: How to apply a style sheet to a file upload bottom.
html
head
titleUntitled/title
style
.buttoncolor { color:#FF; background: #557799; FONT-FAMILY: Arial,
sans-serif; FONT-SIZE: 8pt; font-weight: bold;}
/style
/head
body
form name=MyForm method=post action="">
enctype=multipart/form-data
It also needs to have a file selection control:
input name=MyFile type=file class=buttoncolor size=20
/body
/html
Hi,
I am in the process of creatinga page for my endusers to upload files and
the first thing that they complained about is that the button is not the
same
style as the rest of the buttons in the applications.All of the buttons
are
usually a form of blue (We use IE6.0 only - internal), but the BROWSE
button
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: Null null error ARGHHH!
I've only every seen this when using an invalid date, usually with dateAdd().I've also seen CFCHART error with the same message when using dates as the labels on one of the axes the first time any chart is requested after a reboot. cheers, barneyb On Tue, 14 Sep 2004 11:18:04 -0500, Mark W. Breneman [EMAIL PROTECTED] wrote: Same here, I get the Null Null error randomly on one of the 40 small sites we host on one sever. From what I can tell it *maybe* related to a bad session var.A user will get the error on the first page and what ever page they try to go to whey will still get the error. I have only experienced the error personally myself once last year. On another server and a much larger site I was using client vars and had the same Null Null problem.I switched over to session vars and the null null problem went way on that server. I also rewrote much of the code on the site in a major site update so I can not say for 100% sure it was the client vars. Anyone else have any ideas? -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SOT: How to apply a style sheet to a file upload bottom.
I would recommend that you use your own graphics for the buttons. I usually use my own graphics button in place of the browse button. How exactly do you do that [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT: How to apply a style sheet to a file upload bottom.
How does one do that?I know for regular buttons, but with the file type,
I thought you were locked in to the default form button.
Ray
At 12:43 PM 9/14/2004, you wrote:
I would recommend that you use your own graphics for the buttons. I
usually use my own graphics button in place of the browse button.
All that does is turn the background of the field a color.CSS limitation,
this can't be done currently.
-Original Message-
From: Asim Manzur [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 11:33 AM
To: CF-Talk
Subject: Re: SOT: How to apply a style sheet to a file upload bottom.
html
head
titleUntitled/title
style
.buttoncolor { color:#FF; background: #557799; FONT-FAMILY: Arial,
sans-serif; FONT-SIZE: 8pt; font-weight: bold;}
/style
/head
body
form name=MyForm method=post action="">
enctype=multipart/form-data
It also needs to have a file selection control:
input name=MyFile type=file class=buttoncolor size=20
/body
/html
Hi,
I am in the process of creatinga page for my endusers to upload files and
the first thing that they complained about is that the button is not the
same
style as the rest of the buttons in the applications.All of the buttons
are
usually a form of blue (We use IE6.0 only - internal), but the BROWSE
button
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: SOT: How to apply a style sheet to a file upload bottom.
Asim,
How do you actually do that?I have tried it before and it did not work.The
code was unable to actually do the upload.
I am assuming that you need to write a _javascript_ routine to do that?
Is it possible to post an example?
Thanks
Mario
-Original Message-
From: Asim Manzur [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 12:43 PM
To: CF-Talk
Subject: Re: SOT: How to apply a style sheet to a file upload bottom.
I would recommend that you use your own graphics for the buttons. I usually
use my own graphics button in place of the browse button.
All that does is turn the background of the field a color.CSS limitation,
this can't be done currently.
-Original Message-
From: Asim Manzur [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 11:33 AM
To: CF-Talk
Subject: Re: SOT: How to apply a style sheet to a file upload bottom.
html
head
titleUntitled/title
style
.buttoncolor { color:#FF; background: #557799; FONT-FAMILY: Arial,
sans-serif; FONT-SIZE: 8pt; font-weight: bold;}
/style
/head
body
form name=MyForm method=post action="">
enctype=multipart/form-data
It also needs to have a file selection control:
input name=MyFile type=file class=buttoncolor size=20
/body
/html
Hi,
I am in the process of creatinga page for my endusers to upload files and
the first thing that they complained about is that the button is not the
same
style as the rest of the buttons in the applications.All of the buttons
are
usually a form of blue (We use IE6.0 only - internal), but the BROWSE
button
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Timeout on files over 2mb using CFFILE
I have a situation where a server (on a military base that we don't have control over) will upload files fine that are under 2MB.As soon as you try uploading a file larger than 2MB the page thinks for about a second and goes immediately to a page not found error.We can do files that are 1.9MB and they work fine, it seems to be something with going over 2MB.The server is Windows 2000 Server with IIS as the web server and it was recently upgraded to MX 6.1 and then this problem was noticed. Is there some setting in CF that would effect the size of the upload allowed?Any suggestions or info to point me in the right direction would be great.Thanks! John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT: How to apply a style sheet to a file upload bottom.
Mario, I have seen that trick somewhere on web awhile ago, I am trying to find the link and will post. Asim, How do you actually do that?I have tried it before and it did not work.The code was unable to actually do the upload. I am assuming that you need to write a _javascript_ routine to do that? Is it possible to post an example? Thanks Mario -Original Message- From: Asim Manzur [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 12:43 PM To: CF-Talk Subject: Re: SOT: How to apply a style sheet to a file upload bottom. I would recommend that you use your own graphics for the buttons. I usually use my own graphics button in place of the browse button. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Incorporating Javascript to confirm into a document...
Yes it did, thanks for your help! Unfortunately, having them on the same page made it enough more difficult that it was beyond my introductory knowledge of _javascript_ (but I am taking a class!). :) I was having a hard time passing a variable from the _javascript_ to use in CFIF.. if I could have said script var confirm_delete = confirm (blah); /script and then cfif confirm_delete is true etc then I would have been set from the get go. But, I couldn't figure out how to get the variables from inside the script be available to the rest of the page. Okay.So your form handler page is the same as your regular page, just two different routes taken if they really want to press the button.Potato, Potaato. The real question is, did this finally work for you? Ray At 12:20 PM 9/14/2004, you wrote: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT: How to apply a style sheet to a file upload bottom.
I have seen that trick somewhere on web awhile ago, I am trying to find the link and will post. You can do the trick using CSS and _javascript_ and the GUI can be stylized as you want. The file upload function however won't work -- a 0 bit file is what's uploaded. That's due to a security measure built into the browser. I've gone down this road before as have others. It's been a while though. If you find a solution, which doesn't break the upload functionality, please post. I'd be interested to see it. Thanks. - Regards, Bob Haroche O n P o i n tS o l u t i o n s www.OnPointSolutions.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
COM Problem
I wonder if someone can write me the Coldfusion Code for the following VB Code. Sub CreateCall() Dim MyRecord As Object Set Axapta = CreateObject(AxaptaCOMConnector.Axapta) Axapta.Logon Set MyRecord = Axapta.CreateRecord(CCMCTIInbound) MyRecord.InitValue MyRecord.field(UserID) = gp1 MyRecord.field(Number) = MyRecord.Insert Axapta.Logoff End Sub I can only write the first line cfobject action="" class=#Attributes.ProgId# type=COM name= Axapta Thanks Shaz ** This email and any files transmitted with it are confidential and intended solely for use by the individual or entity to whom it is addressed. If you have received this e-mail in error, kindly notify [EMAIL PROTECTED] or call +44 1992 701 704. Unless stated otherwise, please note that any views or opinions expressed in this e-mail are solely that of the author and are not necessarily of JJ Fast Food Distribution Limited. The company can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. The company accepts no liability for any damage caused by this email. JJ Fast Food Distribution Limited reserves the right to monitor and or record e-mail without prior notification. ** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Null null error ARGHHH!
I am getting the same error except mine is pointing to a CFQUERY.I am running CFMX 6.1 Updater 3 on Solaris with Sybase 12.5 and jConnect 5.5. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Regex help
This is working ok in CF5 but apparently not in CFMX Malformed regular _expression_ \[[^\]*\]. Reason: Unmatched [] in _expression_.. REReplace(ThisTag.GeneratedContent, \[[^\]*\], , All) it's supposed to strip all [] with everyting inbetween the brackets [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT: How to apply a style sheet to a file upload bottom.
I couldn't find that link yet, but I still had an idea that what was mentioned in that article. I have posted the link for you guys to review and advise. in this link, i have play with a trick to swap the browse button, and then post it to the .cfm file, through _javascript_ I am putting the value in the field. Let me know if that make sense so, I will post the codes on my next thread. http://www.logikzone.com/temp/upload.cfm Thanks I have seen that trick somewhere on web awhile ago, I am trying to find the link and will post. You can do the trick using CSS and _javascript_ and the GUI can be stylized as you want. The file upload function however won't work -- a 0 bit file is what's uploaded. That's due to a security measure built into the browser. I've gone down this road before as have others. It's been a while though. If you find a solution, which doesn't break the upload functionality, please post. I'd be interested to see it. Thanks. - Regards, Bob Haroche O n P o i n tS o l u t i o n s www.OnPointSolutions.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Question about processing a CSV file.
I have done a lot of work with file imports, you can check out cfx_text2query: http://www.emerle.net/programming/display.cfm/t/cfx_text2query Though, your CSV seems simple enough to parse as a list, without anything fancy.. unless that file is huge.. -R On Mon, 13 Sep 2004 22:36:19 +0100, Ciliotta, Mario [EMAIL PROTECTED] wrote: Hi, I was wondering if anyone could help me out as I am stuck on this part.I have a csv file that I would like to read and then issue an update query based on the contents. Basically I would like to read the file and then loop over the file and issue and update query for each line (maybe I could convert it to stored procedure later). The file looks like this: 5388120,12345678IL 5388150,FDX123FD45 5388165,RT6789 5388198,12345HY890 5388204,123SEDFRT 5388205,1ASEFFBH6 5388209,12890HFS23 5388212,124300HGFS 5388231,123567UHJK 5388235,12WWE4DD45 5388281,1234RFGT76 5388284,313SFFS67 5388361,23DS45 5388366,4422442242 5388372,42242FDFSF 5388403,FDXUPSDELD 5388409,1234567890 5388414,ASWDERF455 5388415,123EDCVBH6 5388417,12WSED56YH 5388424,12WSC56HBN 5388428,123WSE456H 5388510,313DADDADA 5388511,HFH678947S 5388597,3131ADADAD 5388654,ADA5DFA5RD 5388655,AD4242DDAA 5388661,1331XSSA4D And what I want to do is loop over it and issue an update: PUSEDOCODE: CFLOOP over the file update table set track_nbr = '2345678il' where header_id = 5388120 /cfloop What is the best way to do this.I can process the file but I am lost as to what to do. This is what I have so far: cfset RecordDelimiter = Chr(10) Chr(13) / cfset ColumnDelimiter = chr(34) chr(44) chr(34) / cffile action = "" file = G:\inetpub\wwwroot\mario\fedex_input.csv variable = Variables.SourceFile cfloop index=index list=#Variables.SourceFile# delimiters=#RecordDelimiter# cfloop index=recordIndex list=#index# delimiters=#ColumnDelimiter# cfoutput#RecordIndex#br /cfloop hr /cfloop Thanks Mario [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Oracle Stored Procedures
We are using the Oracle drivers that ship with MX Enterprise so according to that technote we should be ok with ref cursors. Thanks for the info Janet, I'm currently looking into having the cursor defined along the lines of your last post. Scott -Original Message- From: Janet Schmitt [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 11:21 AM To: CF-Talk Subject: RE: Oracle Stored Procedures Scott - The other thing you might want to look at is what Oracle drivers are being used.I know there are issues with some of the drivers and Oracle stored procedures. Here isa technote regarding one Oracle driver that mentions support for Oracle refcursors: http://www.macromedia.com/support/coldfusion/ts/documents/tn18344.htm Janet. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: [Spam?] Re: Regex help
I think you are missing a ] REReplace(ThisTag.GeneratedContent, \[[^\]]*\], , All) Or maybe even \[[^]]*\] On cfmx, you could use non-greedy matches: \[.*?\] Pascal -Original Message- From: Dirk De Bock - Listclient [mailto:[EMAIL PROTECTED] Sent: 14 September 2004 19:14 To: CF-Talk Subject: [Spam?] Re: Regex help This is working ok in CF5 but apparently not in CFMX Malformed regular _expression_ \[[^\]*\]. Reason: Unmatched [] in _expression_.. REReplace(ThisTag.GeneratedContent, \[[^\]*\], , All) it's supposed to strip all [] with everyting inbetween the brackets [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Null null error ARGHHH!
See: http://www.talkingtree.com/blog/index.cfm?data=""> --- Alisa Thomson [EMAIL PROTECTED] wrote: I am getting the same error except mine is pointing to a CFQUERY.I am running CFMX 6.1 Updater 3 on Solaris with Sybase 12.5 and jConnect 5.5. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Oracle Stored Procedures
Janet, I have the snippet now from them.This is how it's currently defined (which looks like it's in line with what you posted aside from In Out): Type ReturnSet is ref cursor; Procedure testpckg(curReturnSet Out Returnset); They had switched it before to be In Out for me and I still had the same error.The one thing I did notice is they do not have it defined with a schema name, they just have: package Test01 is Type ReturnSet is ref cursor; Procedure testpckg(curReturnSet Out Returnset); Could that possible cause a permissions issue as Adam had alluded too? Thanks, Scott -Original Message- From: Janet Schmitt [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 11:11 AM To: CF-Talk Subject: RE: Oracle Stored Procedures It might be something to do with the way the refcursor is defined in the package.Would they be willing to change the package so the refcursor is defined like this? CREATE OR REPLACE PACKAGE schemaname.testpckg IS TYPE curreturnset_type_ref_cursor IS REF CURSOR; PROCEDURE testpckg( curreturnset IN OUT curreturnset_type_ref_cursor); END; At 10:57 AM 9/14/2004 -0400, you wrote: Here is the new specification: PROCEDURE TESTPCKG Argument NameTypeIN/OUT Default? CURRETURNSETREF CURSORIN/OUT The code I'm using to call it is: cfstoredproc procedure = Test01.TestPckg dataSource = #ds# cfprocresult name=rAcct /cfstoredproc _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
