Baffled by Lost Session

2009-10-31 Thread Randy Adkins
I am baffled on this and probably something tremendously simple that I am overlooking. First the layout: Windows Vista (IIS 7) ColdFusion 9 (Developers Edition) Database: MySQL Internet Explorer 8.0 File Structure: webroot \ (application.cfm and other files) webroot \ admin webroot \ admin \

Oracle 10g insert question

2009-10-31 Thread Victor Moore
Hi, I'm trying to migrate a MS-SQL db to oracle and when trying to load the database I get the following error: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly ended the script I'm running is: cfquery name=q datasource=db_ora insert into user_access values (3,

Re: Baffled by Lost Session

2009-10-31 Thread Mike Chabot
See if the problem goes away in Firefox. That will help identify whether it is a browser setting you are overlooking, like cookies being disabled. It is likely that the session is still active on the server, but it is no longer linked to the browser because the session token is different. If you

Re: Oracle 10g insert question

2009-10-31 Thread James Holmes
If you want to run multiple statements in a single cfquery tag in oracle you need to write PL/SQL. An anonymous block would do the trick. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/10/31 Victor Moore victor.mo...@gmail.com: Hi, I'm trying to

Re: Oracle 10g insert question

2009-10-31 Thread Victor Moore
Hi James, Thank you for the quick response I'm a newbie when it comes to PL/SQL. Can you please show me how would i do it considering the previous example, or at least a link where would explain it. Thanks Victor On Sat, Oct 31, 2009 at 10:56 AM, James Holmes james.hol...@gmail.com wrote: If

Re: Oracle 10g insert question

2009-10-31 Thread James Holmes
Wrapping BEGIN and END around the statements should be enough. http://docstore.mik.ua/orelly/oracle/prog2/ch15_03.htm http://www.orafaq.com/wiki/Anonymous_block etc mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/10/31 Victor Moore

SQL / mySQL Datasource

2009-10-31 Thread Chuka Anene
Well i need step by step procedure of creating datasource of any of these two databases on my localhost. Its cracy how i still dont know how... ~| Want to reach the ColdFusion community with something they want? Let them know

Re: SQL / mySQL Datasource

2009-10-31 Thread Matt Quackenbush
I'm rather curious here. Have you ever heard of documentation? The questions you are asking are things that a first-day ColdFusion developer has no trouble with because they are the first basic things that one learns, and it literally takes about 3 minutes to read and implement. Sent

Re: Oracle 10g insert question

2009-10-31 Thread Victor Moore
It doesn't work either. I need to run multiple sql statements in one cfquery/cfquery tag. It appears an Oracle limitation. Thanks On Sat, Oct 31, 2009 at 11:38 AM, James Holmes james.hol...@gmail.com wrote: Wrapping BEGIN and END around the statements should be enough.

Re: Oracle 10g insert question

2009-10-31 Thread Seth Stone
It appears the second insert statement in your cfquery is missing a single-quote (') around Partner. That might be causing a problem. Seth On Sat, Oct 31, 2009 at 11:16 AM, Victor Moore victor.mo...@gmail.comwrote: It doesn't work either. I need to run multiple sql statements in one

Re: Oracle 10g insert question

2009-10-31 Thread Victor Moore
Sorry, that was just an omission when I typed it. The actual code is fine. On Sat, Oct 31, 2009 at 12:24 PM, Seth Stone seth.st...@gmail.com wrote: It appears the second insert statement in your cfquery is missing a single-quote (') around Partner.  That might be causing a problem. Seth

Re: Oracle 10g insert question

2009-10-31 Thread Dave Watts
It doesn't work either. I need to run multiple sql statements in one cfquery/cfquery tag. It appears an Oracle limitation. Many JDBC drivers turn this functionality off by default, to prevent potential security problems I suppose. You may have to look into your JDBC driver settings. Or, run

Re: Oracle 10g insert question

2009-10-31 Thread Victor Moore
I think that's the case, which is a bummer because I have thousands of statements which are logically grouped in cfquery/cfquery tags I'm using the Oracle driver that comes with CF 8. Thanks Victor On Sat, Oct 31, 2009 at 1:05 PM, Dave Watts dwa...@figleaf.com wrote: It doesn't work either.

Re: SQL / mySQL Datasource

2009-10-31 Thread Jide Aliu
Well i need step by step procedure of creating datasource of any of these two databases on my localhost. Its cracy how i still dont know how... Hi Chuka, It's quite straightforward to set up, see the link below, it is a step by step instruction on how to set up any datasource in CF 8.

Re: SQL / mySQL Datasource

2009-10-31 Thread Jide Aliu
Hi Chuka, Not sure what was wrong with my last posting, here I go again.. It's quite straightforward to set up, see the link below, it is a step by step instruction on how to set up any datasource in CF 8.

Re: SQL / mySQL Datasource

2009-10-31 Thread Anene Isioma Wealth
nice sarcasm. do u think i havent gone through documentation? Sincerely, Chuka I.W. Anene Chief Software Eng./CEO Quorium Solutions www.quorium.org 07029609185,07032696113 From: Matt Quackenbush quackfu...@gmail.com To: cf-talk cf-talk@houseoffusion.com

Re: SQL / mySQL Datasource

2009-10-31 Thread Matt Quackenbush
Since you asked, yes, I am convinced that you have not gone through the documentation. On Sat, Oct 31, 2009 at 1:05 PM, Anene Isioma Wealth wrote: nice sarcasm. do u think i havent gone through documentation? ~| Want to

Re: SQL / mySQL Datasource

2009-10-31 Thread Anene Isioma Wealth
i use cf 7 and pls dont ask me to upgrade Sincerely, Chuka I.W. Anene Chief Software Eng./CEO Quorium Solutions www.quorium.org 07029609185,07032696113 From: Jide Aliu jide_a...@hotmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Sat, October 31, 2009

Re: SQL / mySQL Datasource

2009-10-31 Thread Anene Isioma Wealth
u annoy me. If u don't know how to spell out advisory sentences, the coil up in your shell. Sincerely, Chuka I.W. Anene Chief Software Eng./CEO Quorium Solutions www.quorium.org 07029609185,07032696113 From: Matt Quackenbush quackfu...@gmail.com To:

Re: SQL / mySQL Datasource

2009-10-31 Thread Matt Quackenbush
Apparently my advisory sentence was not clear enough, so I shall cut it down to the simplest of words for you... Read the documentation. ~| Want to reach the ColdFusion community with something they want? Let them know on the

Re: SQL / mySQL Datasource

2009-10-31 Thread Dominic Watson
http://tinyurl.com/ya9xqbb 2009/10/31 Anene Isioma Wealth anene.quor...@yahoo.com i use cf 7 and pls dont ask me to upgrade Sincerely, Chuka I.W. Anene Chief Software Eng./CEO Quorium Solutions www.quorium.org 07029609185,07032696113 From: Jide

Re: Baffled by Lost Session

2009-10-31 Thread Jerry Barnes
Try relocating to another page while passing the cfid and cftoken on the url just to see if the session stays active. This may help with tracking down where the problem is. ~| Want to reach the ColdFusion community with

Re: Oracle 10g insert question

2009-10-31 Thread Dave Watts
I think that's the case, which is a bummer because I have thousands of statements which are logically grouped in cfquery/cfquery tags I'm using the Oracle driver that comes with CF 8. I don't use Oracle often enough to have encountered this before, so I can't really provide any detailed

Re: SQL / mySQL Datasource

2009-10-31 Thread Dave Watts
nice sarcasm. do u think i havent gone through documentation? I, like Matt, would guess that you have not, because if you had, you would have more specific questions. Have you, in fact, read the CF 7 MySQL datasource information here?