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 \
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,
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
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
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
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
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
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
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.
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
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
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
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.
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.
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.
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
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
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
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:
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
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
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
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
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?
24 matches
Mail list logo