Or in the stored procedure you could save the @@IDENTITY in a variable and
return it at the end... i.e:
/*Do an insert here*/
INSERT BLAH BLAH
DECLARE StoredId INT
SELECT StoredId = @@IDENTITY
/*Do 2nd Insert Statement*/
INSERT BLAH BLAH
SELECT @StoreId
This still doesn't require the need
> > wrong. It's the last identity value used by that connection.
>
> i was previously told on this list that @@IDENTITY is per connection per
> table.
no, its per connection. if you insert a table that has a trigger that fires
an insert into another table w/identity, then @@IDENTITY will contai
>Might want to ammend that :
>http://shroom.dv8.org/bmp/crypt.cgi
>(the other link gives a 404)
Just checking you were awake ;-)
Rob Keniger
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe
Might want to ammend that :
http://shroom.dv8.org/bmp/crypt.cgi
(the other link gives a 404)
Jared.
[EMAIL PROTECTED] wrote:
> http://shroom.dv8.org/bmp/cfdecrypt
>
>
> Rob Keniger
--
Archives: http://www.eG
Yes, thanks for that insight Jeff. However, in 7 years of building
international intranets I have never had the opportunity or occasion to even
consider its use. Unfortunately, I need to store images in a database for
security and migration purposes, not necessarily for web ready imaging. I
app
Hi Sean,
It's almost never useful to store an image in a database. You can't sort on
it, or search on it, and it takes up a lot of room. Most people store the
path to the file, and whatever other info they may need for searching and
sorting, etc. Is there any reason you need to store the image
http://shroom.dv8.org/bmp/cfdecrypt
Rob Keniger
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
messa
> I just read the recent discussion on the forums
>
(http://forums1.allaire.com/DevConf/Thread.cfm?&&Message_ID=504660&_#Message
504660)
> about this. I had the impression the @@IDENTITY function returned the
> last identity value used by the SQL server, regardless of user. This was
> wrong. It
aye. thanks for the info :-)
- Original Message -
From: "pan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, July 02, 2000 7:08 PM
Subject: Re: UPS CHECK DIGIT -Pan
>
> From: Sean Renet <[EMAIL PROTECTED]>
>
>
>
> > I went through there myups account and coundn't find anything
Forgive me if this is redundant or "stupid" but I have a problem. I have
some encrypted code left by a contract programmer. The fact that he
encrypted it is bad enough but another story. However, this code works fine
on CF4.0 but on the 4.5 box, the crpyted code displays instead of the CF
exec
From: Chris Giminez <[EMAIL PROTECTED]>
>
> How can I detect the size of the file prior to upload to prevent someone
> from maliciously uploading a 100MB file (or worse!). I know I can see it
> with #file.filesize# but this is only after the upload, right?
>
As Seth mentioned, you are going t
From: Sean Renet <[EMAIL PROTECTED]>
> I went through there myups account and coundn't find anything useful. That
> is why I posted here to see if anyone could think of anything faster than
> what I came up with.
>
I understood what you were looking for; what you listed didn't look familiar
>I want to not upload at all if the file is bigger than 1MB. How can this be
>done?
I can't think of a way to do this, but while I was looking around for a solution
I found this page about file upload fields which is quite informative:
http://www.hut.fi/u/jkorpela/forms/file.html
I hope this
Zachary thanks for hipping me to the ASCII check, I forgot all about that
possibility. Other than that both are the same speed so I just added that
acsii check to my tagified first version. Thanks for the help
--
Archi
> I've never tried it, but you might be able to use JavaScript to do some
sort
> of test on the file data before the upload completes. This has peaked my
> interest, so I'm going to look into it... I'll post a follow up if I find
> anything useful.
I did some searching of the comp.lang.javascrip
Can someone show me an example of a CFQUERY that enters an image into a
database? I am using SQL 7.0, I just can't seem to get the syntax right
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
h
I went through there myups account and coundn't find anything useful. That
is why I posted here to see if anyone could think of anything faster than
what I came up with.
Where did you get your examples from? The manual I am reading is completely
contrary to what you provided.
What I have is
1)
> How can I detect the size of the file prior to upload to prevent someone
> from maliciously uploading a 100MB file (or worse!). I know I can see it
> with #file.filesize# but this is only after the upload, right?
I'm afraid you really can't do this with any server side programming (such
as CF).
>This might be a little off topic: I am wondering if anyone knows how to
>specify field properties when using the Create TABLE or Alter TABLE SQL
>statements in MS Access. I am writing some code to create a few tables on
>the fly, and it would be very handy to be able to specify things like
>
Hi Folks,
This might be a little off topic: I am wondering if anyone knows how to
specify field properties when using the Create TABLE or Alter TABLE SQL
statements in MS Access. I am writing some code to create a few tables on
the fly, and it would be very handy to be able to specify things li
I am permitting a user to upload their resume as an option when inquiring
for employment. This file should never exceed 1Mb and will usually be much
less. I'm using cffile to write the file to the server, then attaching it
with cfmail to go to my client.
How can I detect the size of the file prio
I'll deal with it directly. As a side question, do you have more than one
email account or are they all to the same one? I se you down for about 7
accounts. I removed all but one.
>
> Somehow, I am subscribed to multiple issues of the Fusion Authority =
> Weekly News Letter. I have tried unsub
I figured out what I was doing stupid. Never mind and thanks anyway. :)
On 7/1/00, Bud penned:
>Hi all. Anyone seen this when trying to upload with cffile?
>
>501 Not Implemented
>
>Cannot do POST is supported via CGI/API programs only. with this URL
>/tropical/admin/.
>
>Most likely, this was an
Helge,
Check that everywhere (in Apache, in ColdFusion, in Oracle) NLS_LANG is set
to American_CIS.WE8ISO8859P1. If it will be different - it will show
question marks instead of normal 8bit characters.
stas@
- Original Message -
From: "Helge Hetland" <[EMAIL PROTECTED]>
To: <[EMAIL PROT
> I am using the access 2000 interface to convert and upload my access
> 2000 database into sql via the upsize wizard inside access 2000
>
> however when I attempt to upsize the uploads terminate with an error
> report saying that either there were errors in the conversion of certain
> table or el
Didn't work..
Tried
AMERICAN_AMERICA.WE8ISO8859P1
AMERICAN_CIS.WE8ISO8859P1
Same result
Your character set is wery different from the one we're using, Allaire
probably tested that more than the more "common" character sets..
Helge
-Original Message-
From: Stanislav Maximov [mailto:[EM
From: Sean Renet <[EMAIL PROTECTED]>
> anyone have a tag to calcualte the ever annoying UPS CHECK DIGIT?
>
UPS Tracking Numbers appear in the following formats:
1Z 999 999 99 999 9
999
T999 999
(0123456789A~Z)
You can also use reference numbers to track a shipment (shippe
Helge,
We succeeded with NLS_LANG=American_CIS.C8MSWIN1251 for russian language
support.
Is there something similar? Maybe something like American_CIS.WE8ISO8859P1?
stas@
- Original Message -
From: "Helge Hetland" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, July 02, 2000 1
Yes:
NLS_LANG=NORWEGIAN_NORWAY.WE8ISO8859P1
in the environment, this is verified by our DBA and Allaire, but it could be
possible that it's the wrong value?
Did you do anything else?
It could be interesting to test your solution on our server, what NLS_LANG
value did you use?
And what characters
Helge,
We've solved the problem by setting NLS_LANG in CF's environment into our
charset value.
Have you tried this?
stas@
- Original Message -
From: "Helge Hetland" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, July 02, 2000 7:05 PM
Subject: RE: CF / Oracle / Solaris locale
This is a multi-part message in MIME format.
--=_NextPart_000_0007_01BFE42E.EC943E30
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi All,
Could you point me to an example of a 'Log Off" routine that I could =
use. I would like to thank t
This is a multi-part message in MIME format.
--=_NextPart_000_0060_01BFE409.04993010
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Somehow, I am subscribed to multiple issues of the Fusion Authority =
Weekly News Letter. I have tried unsu
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> Just a comment, that's the kind of thing I would have written
> that as a
> block. It would be a little faster and less bulky
> looking
>
> ~Justin MacCarthy
Very true! That was a quick & dirty hack that I haven't got around
to rewriting
What would life be without surprises :)
We got the message that it was a bug just before closing time friday, but
until then they were taking it very seriously and worked hard finding it out
for us.
I just hope that their relocation goes smootly and that they're ready to
help us fix it as soon
Hello,
What is really funny, is that we had the same July 1st as a deadline and MS
SQL as a development DB before we tried Oracle... :))
Have you got any estimations from Allaire?
stas@
- Original Message -
From: "Helge Hetland" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday,
Hello!
It works perfectly on MS SQL and CF Enterprise Solaris 4.51
(Solaris har Merant MSSQL drivers, not sure if Linux has?)
We haven't tried other solutions since the HW/SW Specs is already set, will
try to get a fix from Allaire to make it work until SP1 is released.
Our problem is that our
Hello,
Actually, I have no idea how could I help to speed it up on Allaire's side.
I think to workaround this problem this ways:
1. Try Sybase instead of Oracle on that machine - it is pain due to many SQL
statements to be rewritten. It will be nice to hear from someone on this
list who tried CF+
Just a comment, that's the kind of thing I would have written that as a
block. It would be a little faster and less bulky looking
~Justin MacCarthy
- Original Message -
From: Zachary Bedell <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, July 02, 2000 2:36 PM
Subject: R
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> This is what I came up with. Anyone have anything any faster?
I'm not sure if this is any faster, but I think it's a little easier
to grok.
It's not in tag form, but should be easy enough to tagify...
Hope this helps.
Best regards,
Zachary Bede
This is what I came up with. Anyone have anything any faster?
The variable cdigit start is a concatenation of a bunch of UPS code
numbers
#checkdigit#
--
Archives: http://www.eGroups.co
anyone have a tag to calcualte the ever annoying UPS CHECK DIGIT?
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
m
41 matches
Mail list logo