Yes, that's the one. It's quite good, although it isn't a TOAD-killer
(but there again what is?).
On 10/8/06, Dave Watts [EMAIL PROTECTED] wrote:
Because Oracle has a Free tool now that does a lot of
the same work.
What Free tool from Quest does the same thing as TOAD?
I think James
Teddy Payne wrote:
I typically don't make my UUIDs my primary keys are I prefer database to
perform binary searchings on numbers and 35 character strings.
A UUID/GUID is a number. Its string representation may be a bit funky, but it
is still just a 128 bit number.
Jochem
That'll work fine.
Out of interest, why can't you get TOAD to manage your Oracle DB? Too
expensive or some other reason? Because Oracle has a Free tool now
that does a lot of the same work.
On 10/7/06, daniel kessler [EMAIL PROTECTED] wrote:
alright, I'm gonna try to get the number from DUAL
Subject: Re: locking, I think
That'll work fine.
Out of interest, why can't you get TOAD to manage your Oracle DB? Too
expensive or some other reason? Because Oracle has a Free tool now that does
a lot of the same work.
On 10/7/06, daniel kessler [EMAIL PROTECTED] wrote:
alright, I'm gonna try
Because Oracle has a Free tool now that does a lot of
the same work.
What Free tool from Quest does the same thing as TOAD?
I think James is referring to Oracle's new free SQL Developer:
http://www.oracle.com/technology/software/products/sql/index.html
Dave Watts, CTO, Fig Leaf Software
://www.reedexpo.com
-Original Message-
From: James Holmes
To: CF-Talk
Sent: Fri Oct 06 06:23:34 2006
Subject: Re: locking, I think
Yes, but then we are back to the original question of how to get that
last ID from the DB so the code can use it.
To be completely safe, there are two
Because we are using Oracle.
On 10/6/06, Robertson-Ravo, Neil (RX)
[EMAIL PROTECTED] wrote:
Not sure why you would need a trigger when SCOPE_IDENTITY would do the trick
(or @@identity depending on your needs)
--
CFAJAX docs and other useful articles:
http://www.bifrost.com.au/blog/
Message-
From: James Holmes
To: CF-Talk
Sent: Fri Oct 06 10:34:33 2006
Subject: Re: locking, I think
Because we are using Oracle.
On 10/6/06, Robertson-Ravo, Neil (RX)
[EMAIL PROTECTED] wrote:
Not sure why you would need a trigger when SCOPE_IDENTITY would do the
trick
(or @@identity depending
On Friday 06 October 2006 06:23, James Holmes wrote:
2) Get the value from the sequence first and then do the insert,
remembering the value that was obtained from the sequence. This can be
done in a stored procedure or in CF code.
We did this in CF, and it worked fine.
--
Tom Chiverton
of it, and some Oracle specific features (connect
by...prior comes to mind) can be really valuable to know. The reverse,
of course, is also true.
-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 05, 2006 4:46 PM
To: CF-Talk
Subject: Re: locking, I think
: locking, I think
For people who are used to SQL server, the best thing to do would be
to
setup a trigger and that trigger in Oracle could grab the next
sequence
value and insert it when new data is being inserted into the table.
On 10/5/06, Doug Bezona [EMAIL PROTECTED] wrote
this
communication are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com
-Original Message-
From: Teddy Payne
To: CF-Talk
Sent: Fri Oct 06 14:29:37 2006
Subject: Re: locking, I think
scope_identity and @@identity are one type of solution. Primary Keys
scope_identity and @@identity are one type of solution. Primary Keys
that
are autoincremented are hard to follow soemtimes and are a bit tricky
to
retrieve sometimes on high transactional systems.
Which is exactly why I prefer Oracle's (and PostgreSQL as well,
incidentally) method - you grab
alright, I'm gonna try to get the number from DUAL and insert that.
I'd like to try triggers, but the last time I tried to make them, I had
problems. We aren't allowed to use a GUI (managing tool) to work with the DB.
Admittedly, I was pretty much a complete novice at the time. So when I
I have an oracle database and I set the ID of a database entry using:
unique_repair_ticket_s.NEXTVAL - which is basically a counter
I then need to get that ID and send it to the user. Is the process
for this to then query the database for the last entry? If so, do I
surround it with a
05, 2006 2:01 PM
To: CF-Talk
Subject: locking, I think
I have an oracle database and I set the ID of a database entry using:
unique_repair_ticket_s.NEXTVAL - which is basically a counter
I then need to get that ID and send it to the user. Is the process
for this to then query the database
-Talk cf-talk@houseoffusion.com
Sent: Thursday, October 05, 2006 12:01 PM
Subject: locking, I think
I have an oracle database and I set the ID of a database entry using:
unique_repair_ticket_s.NEXTVAL - which is basically a counter
I then need to get that ID and send it to the user
quirky Oracle things. Personally, I really like
sequences, but if you're used to SQL Server, it's an odd beast.
-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 05, 2006 3:46 PM
To: CF-Talk
Subject: Re: locking, I think
Here is a little snippet
For people who are used to SQL server, the best thing to do would be to
setup a trigger and that trigger in Oracle could grab the next sequence
value and insert it when new data is being inserted into the table.
On 10/5/06, Doug Bezona [EMAIL PROTECTED] wrote:
You can access the sequence in a
Yes, but then we are back to the original question of how to get that
last ID from the DB so the code can use it.
To be completely safe, there are two alternatives:
1) Use a trigger on the table to perform an autoincrement operation
with the sequence. Wrap the INSERT and the subsequent SELECT
20 matches
Mail list logo