Long story ... but it serves a purpose. :)
On 1/31/08, Deanna Schneider <[EMAIL PROTECTED]> wrote:
>
> Um, why would you want to do that?
>
>
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Um, why would you want to do that?
On Jan 31, 2008 10:15 AM, Erika L. Walker wrote:
> hidey ho neighbors.
>
> today in la la land, we're inserting data into two tables.
>
> First table holds name and email from a registration table.
> Second table holds the ID created by the insertion into the fi
On Jan 31, 2008 12:15 PM, William Bowen <[EMAIL PROTECTED]> wrote:
> You're most welcome.
>
> I took a SQL Server 2005 performance tuning and optimization class
> right before Christmas and many of the lessons were simple little
> exercises like that... nice to get a chance to exercise them :-)
>
You're most welcome.
I took a SQL Server 2005 performance tuning and optimization class
right before Christmas and many of the lessons were simple little
exercises like that... nice to get a chance to exercise them :-)
On Jan 31, 2008 10:03 AM, Erika L. Walker <[EMAIL PROTECTED]> wrote:
> got t
Erika,
Can you make this process a stored procedure? If so you can make use of the
@@identity variable in SQL Server. This will give you the unique index of
the value that was just inserted, so you wouldn't have to requery the
database at all.
I don't know if you can use this variable outside of
got to be CF then .. because like I said, it's a simple select statement.
there's nothing to work on.
I'll go take a looksee in CFAdmin ...
Thanks!
On 1/31/08, William Bowen <[EMAIL PROTECTED]> wrote:
>
> Run your SQL in Query Analyzer and see if it times out.
>
> If it doesn't time out then the
Run your SQL in Query Analyzer and see if it times out.
If it doesn't time out then the issue is probably a CF setting. If it
does time out, then you'll need to work on the query a bit...
HTH
On Jan 31, 2008 9:43 AM, Erika L. Walker <[EMAIL PROTECTED]> wrote:
> CF Code
>
> On 1/31/08, William Bo
CF Code
On 1/31/08, William Bowen <[EMAIL PROTECTED]> wrote:
>
>
>
> when you run the query, are you running it from CF? or Enterprise
> Manager? or Query Analyzer?
>
~|
Adobe® ColdFusion® 8 software 8 is the most important and
> Runny a query on the table keeps timing out. I know ive run queries on
> bigger datasets before... is there something sommewhere I can "fiddle with"
> to stop this from timing out? Seems a bit silly that it's doing this but not
> sure where to start looking for the bottleneck.
when you run the q
The table I am pulling this info from has just over 11,000 records and will
continue growing.
MSSQL 2000.
Runny a query on the table keeps timing out. I know ive run queries on
bigger datasets before... is there something sommewhere I can "fiddle with"
to stop this from timing out? Seems a bit si
Well, it hasnt errored yet ... :D
Thanks for the help by the way ... gotta go look at my data and see if it
worked
On 1/31/08, G Money <[EMAIL PROTECTED]> wrote:
>
> Okee...lemme know how it goes.
>
> On Jan 31, 2008 10:38 AM, Erika L. Walker <[EMAIL PROTECTED]> wrote:
>
> > I dont know if you
Okee...lemme know how it goes.
On Jan 31, 2008 10:38 AM, Erika L. Walker <[EMAIL PROTECTED]> wrote:
> I dont know if you are missing something or not, I simply didnt know how
> to
> go about it.
>
> I shall try it :)
>
>
> On 1/31/08, G Money <[EMAIL PROTECTED]> wrote:
> >
> > Query the record y
I dont know if you are missing something or not, I simply didnt know how to
go about it.
I shall try it :)
On 1/31/08, G Money <[EMAIL PROTECTED]> wrote:
>
> Query the record you just inserted, get the new ID, multiply it by -1,
> insert into the second table.
>
> Or am i missing something.
Query the record you just inserted, get the new ID, multiply it by -1,
insert into the second table.
Or am i missing something.?
On Jan 31, 2008 10:15 AM, Erika L. Walker <[EMAIL PROTECTED]> wrote:
> hidey ho neighbors.
>
> today in la la land, we're inserting data into two tables.
>
> First
hidey ho neighbors.
today in la la land, we're inserting data into two tables.
First table holds name and email from a registration table.
Second table holds the ID created by the insertion into the first table, but
in negative format.
How do I do that? been searching googledom but not having an
15 matches
Mail list logo
