Re: return value of Identity Column

[Nick Slay]

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 for any additional triggers to be
written and maintained.



> From: [EMAIL PROTECTED] (Paul Hastings)
> Organization: TEI
> Reply-To: [EMAIL PROTECTED]
> Date: Mon, 3 Jul 2000 13:40:09 +0700
> To: <[EMAIL PROTECTED]>
> Subject: Re: return value of Identity Column
> 
>>> 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 contain
> the 2nd table's value. in these cases its easy enough to re-write the
> triggers to grab the 1st @@IDENTITY & hold it in a local var
> to send back to the caller.
> 
> --
> 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 message to [EMAIL PROTECTED] with 'unsubscribe' in the
> body.

--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: return value of Identity Column

[Paul Hastings]

> > 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 contain
the 2nd table's value. in these cases its easy enough to re-write the 
triggers to grab the 1st @@IDENTITY & hold it in a local var
to send back to the caller.

--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: encrypted code

[rkeniger]

>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 visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: encrypted code

[Jared Clinton]

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.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: IMAGES and Database entry

[Sean Renet]

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
appreciate your thoughts, asI have already offered several other secure
solutions other than storing the images in a database.  Mostly because I
couldn't figure out how to do it.  So yes, there is a specific reason I need
to store the images in a database.
- Original Message -
From: "Jeff Beer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, July 02, 2000 7:46 PM
Subject: RE: IMAGES and Database entry


> 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 images in the db?
>
>
>
> -Original Message-
> From: Sean Renet [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, July 02, 2000 9:25 PM
> To: [EMAIL PROTECTED]
> Subject: IMAGES and Database entry
>
>
> 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
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --

> 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 message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: IMAGES and Database entry

[Jeff Beer]

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 images in the db?



-Original Message-
From: Sean Renet [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 02, 2000 9:25 PM
To: [EMAIL PROTECTED]
Subject: IMAGES and Database entry


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
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: encrypted code

[rkeniger]

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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: return value of Identity Column

[Ken M. Mevand]

> 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's the last identity value used by that connection.

i was previously told on this list that @@IDENTITY is per connection per
table.

-ken





--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: UPS CHECK DIGIT -Pan

[Sean Renet]

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 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
> so I offered what I knew of as the MOD 10 check digit algorithm. I
mentioned
> the UPS third party developer tools because it seemed that you were
writing
> a cf app that could take advantage of all that UPS has already prepared.
> You know - not reinventing the wheel and all that. I didn't mean to lead
you
> astray. I still think it would be worthwhile for you to do a more detailed
> checkout of the UPS tools. With that thought in mind here is this ...
>
> After logging in to your myUPS account you go to OnLine Tools
> and read the tech faqs - you want to end up with a url like
>
> http://www.ups.com/ecommerce/techdocs/e5c1%5fwelcome.html
> and
> http://www.ups.com/ecommerce/techdocs/e5c7%5ftrackdata.html
>
> That's part of the tech documentation for using the
> datastreaming or inline html tools. There is a *lot* of info there.
> If you try to go there direct you'll get the log-in page.
>
> It was clear to me that it is possible to connect to their validation
> cgi from a cf template just from those two pages listed above.
>
> I got to the tools through my myUPS account but you can go directly to
> the 3rd party tool section with
>
> http://www.ec.ups.com/ecommerce/gettools/gtools_intro.html
> http://www.ec.ups.com/ecommerce/gettools/gtools_e2_thrdpty_lic.html
>
>
> > Where did you get your examples from?  The manual I am reading is
completely
> > contrary to what you provided.
> >
> > What I have is
> > 1)sum all the odds
> > 2)sum all the evens and multiply by 2
> > 3)add results of 1) and 2) together
> > 4) subtract 3) from the next multiple of 10
> > 5 The remainder of 4 is your checkdigit.
> >
> > Is yours just a different spin on this?  Or am I reading some manual
from
> > the 20's?
> >
>
> The one I wrote is the UPC-A version.  It's what I've always known as the
> MOD 10 check digit alogorithm. It's applied by maxicode to their
> barcode products, it's the mod 10 used for cc and chk validations
> and I am fairly sure it is the one used by UPS.
>
> Here is a random sample of web pages that mention the MOD 10 check
> digit algorithm.
>
> http://www.windat.org/rkives/clippings/9601/art4.htm
> http://www.loftware.com/support/knowledgebase/0009240.htm
> http://hypertising.com/DnDCGI/cd/scripts/perlshop/perlshop.txt
> http://www.faqts.com/knowledge-base/view.phtml/aid/3103/fid/330/lang
>
> Hope all that is helpful.
>
> Pan
>
>
>
>
> --

> 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 message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

encrypted code

[Skip Ogden]

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 
executing.

Is this just the way it is with 4.5, do I need to change the server setup, 
or am I hallucinating? I don't think it's the later. Not today, at least.

Skip Ogden
Wilson, NC
--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: limiting upload file size

[pan]

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 to do this client-side.

There is a product for sale at http://www.infomentum.com/
called AppletFile that works very nicely. 

Here's an URL to their online docs.
http://www.infomentum.com/appletfile/doc/

Appletfile goes for about $200 US

They have online demos and an applet set to download and experiment 
with. Worked o.k. for me.


Pan



--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: UPS CHECK DIGIT -Pan

[pan]

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
so I offered what I knew of as the MOD 10 check digit algorithm. I mentioned
the UPS third party developer tools because it seemed that you were writing
a cf app that could take advantage of all that UPS has already prepared.
You know - not reinventing the wheel and all that. I didn't mean to lead you
astray. I still think it would be worthwhile for you to do a more detailed
checkout of the UPS tools. With that thought in mind here is this ...

After logging in to your myUPS account you go to OnLine Tools
and read the tech faqs - you want to end up with a url like

http://www.ups.com/ecommerce/techdocs/e5c1%5fwelcome.html
and
http://www.ups.com/ecommerce/techdocs/e5c7%5ftrackdata.html  

That's part of the tech documentation for using the
datastreaming or inline html tools. There is a *lot* of info there.
If you try to go there direct you'll get the log-in page.

It was clear to me that it is possible to connect to their validation
cgi from a cf template just from those two pages listed above.

I got to the tools through my myUPS account but you can go directly to
the 3rd party tool section with 

http://www.ec.ups.com/ecommerce/gettools/gtools_intro.html
http://www.ec.ups.com/ecommerce/gettools/gtools_e2_thrdpty_lic.html


> Where did you get your examples from?  The manual I am reading is completely
> contrary to what you provided.
> 
> What I have is
> 1)sum all the odds
> 2)sum all the evens and multiply by 2
> 3)add results of 1) and 2) together
> 4) subtract 3) from the next multiple of 10
> 5 The remainder of 4 is your checkdigit.
> 
> Is yours just a different spin on this?  Or am I reading some manual from
> the 20's?
>
 
The one I wrote is the UPC-A version.  It's what I've always known as the 
MOD 10 check digit alogorithm. It's applied by maxicode to their
barcode products, it's the mod 10 used for cc and chk validations
and I am fairly sure it is the one used by UPS.

Here is a random sample of web pages that mention the MOD 10 check 
digit algorithm.

http://www.windat.org/rkives/clippings/9601/art4.htm
http://www.loftware.com/support/knowledgebase/0009240.htm
http://hypertising.com/DnDCGI/cd/scripts/perlshop/perlshop.txt
http://www.faqts.com/knowledge-base/view.phtml/aid/3103/fid/330/lang

Hope all that is helpful.

Pan




--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: limiting upload file size

[rkeniger]

>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 is of some interest.


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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: UPS CHECK DIGIT

[Sean Renet]

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


--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: limiting upload file size

[Seth Petry-Johnson]

> 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.javascript newsgroup on Deja.com, and
I couldn't find a solution.  One of the posts I saw mentioned that there are
security issues involved, which makes sense to a point: the browser really
shouldn't have permission to go all over the user's local hard drive getting
file info.

I'm not sure if there is a solution or not, but its almost certainly going
to have to be client-based.  Anyone else have any ideas?

Regards,
Seth Petry-Johnson
Argo Enterprise and Associates

--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

IMAGES and Database entry

[Sean Renet]

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 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: UPS CHECK DIGIT -Pan

[Sean Renet]

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)sum all the odds
2)sum all the evens and multiply by 2
3)add results of 1) and 2) together
4) subtract 3) from the next multiple of 10
5 The remainder of 4 is your checkdigit.

Is yours just a different spin on this?  Or am I reading some manual from
the 20's?


- Original Message -
From: "pan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, July 02, 2000 12:22 PM
Subject: Re: UPS CHECK DIGIT


>
> 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 (shipper
> created).
>
> UPS uses MOD 10 check digits 
>
> As an example, we will use 01234567890 as our first 11 digits
> Step 1. Sum all digits in the ODD positions.
> Example: 0 + 2 + 4 + 6 + 8 + 0 = 20
> Step 2. Multiply this SUM by 3.
> Example: 20 x 3 = 60
> Step 3. Sum all digits in the EVEN positions.
> Example: 1 + 3 + 5 + 7 + 9 = 25
> Step 4. Add the SUM from Step 3 to the PRODUCT in Step 2.
> Example: 25 + 60 = 85
> Step 5. The CHECKSUM value is the smallest number which when added
> to the SUM of Step 4 produces a multiple of 10
> Example: The smallest number which, when added to 85, produces a multiple
> of 10 is 5 (85 + 5 = 90). Therefore, our checkdigit for the number above
is 5.
>
> There are numerous sample implementations on the net. a cursory search
> found perl scripts, a javascript validator ... etc. etc.
>
> UPS provides a boat load of free software for developers ... sign up for a
> myUPS account and go to online tools. They have a very complete collection
> with lots of interfacing solutions/data formatting routines/error message
> return control algorithms/fully prepped datastreaming modules 
> You can get inline html codings, datastream cgi access, or full blown
> third party developer utilities and documentation.
>
> Seems it would be easier to just use their tools and, if you need to do
any
> tracking number checking independent of their online system, all your
answers
> (specially prepped for their methods) are contained in the open source
code
> of their developer packages. I would be more confident of any CF tags that
> are based on UPS documentation - besides you'll be able to develop
templates
> that take advantage of all the UPS services besides just tracking.
>
> UPS doesn't call their developer tool set a SDK, but if you think of it as
> being that, you won't go wrong.
>
> Pan
>
>
> --

> 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 message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: limiting upload file size

[Seth Petry-Johnson]

> 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).  You see, when you attach files to a form through the FILE input
type the file is basically added to the form as a big blob of binary data.
Thus, the file data itself isn't available to the server until AFTER the
upload completes.

You can check the filesize AFTER the upload and then delete the file if its
too big, but this doesn't avoid wasted bandwidth and CPU cycles dealing with
overly large files.

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.

Regards,
Seth Petry-Johnson
Argo Enterprise and Associates

--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Create TABLE in MS Access

[rkeniger]

>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
>"required" and "Allow Zero Length strings", etc... when creating the tables
>or altering them.

You should check out Jose's guide to using Jet SQL at
http://www.citilink.com/~jgarrick/vbasic/database/jetsql.html

I have a feeling that you can't set field properties such as "allow zero length"
etc using jet SQL - although I may be mistaken.


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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Create TABLE in MS Access

[Eron Cohen]

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 like
"required" and "Allow Zero Length strings", etc... when creating the tables
or altering them.

So far my SQL statements for MS Access 2000 look like:



Alter Table #prefix#_customer_table
ADD #prefix#_customer_id Counter NOT NULL primary key,
#prefix#_customer_description memo,
#prefix#_customer_name text



I've looked around, but can't find the secret.  Anyone know?

Thanks,


Eron

--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

limiting upload file size

[Chris Giminez]

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 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 want to not upload at all if the file is bigger than 1MB. How can this be
done?

Thanks!

--

Chris Giminez



--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Fusion Authority Weekly News Letter

[Michael Dinowitz]

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 unsubscribing, but all that does is =
> add another issue.  Does anyone know how to reduce this to one issue per =
> week?
>
> Gary Groomer
>
> --=_NextPart_000_0060_01BFE409.04993010
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> 
> 
>  http-equiv=3DContent-Type>
> 
> 
> 
> 
> Somehow, I am subscribed to multiple =
> issues of the=20
> Fusion Authority Weekly News Letter.  I have tried unsubscribing, =
> but all=20
> that does is add another issue.  Does anyone know how to reduce =
> this to one=20
> issue per week?
>  
> Gary Groomer
>
> --=_NextPart_000_0060_01BFE409.04993010--
>
> --

> 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 message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: File Upload problem and O'Reilly

[Bud]

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 attempt to execute a CGI program located in
>an area not configured to hold
>executable CGI programs.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CF / Oracle / Solaris locale

[Stanislav Maximov]

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 PROTECTED]>
Sent: Sunday, July 02, 2000 11:26 PM
Subject: RE: CF / Oracle / Solaris locale


> 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:[EMAIL PROTECTED]]
> Sent: Saturday, July 01, 2000 8:57 PM
> To: [EMAIL PROTECTED]
> Subject: Re: CF / Oracle / Solaris locale
>
>
> 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 10:35 PM
> Subject: RE: CF / Oracle / Solaris locale
>
>
> > 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 didn't work before this? We cannot use Norwegian
> > characters among others (ÆØÅ: AE ligature, O Slash, A ring) can you
insert
> > this chars into your system?
> >
> > Helge Hetland
> >
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar
>

--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Help With Upgrading From Access 2000 to SQL for my cf site

[Philip Arnold - ASP]

> 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 else the tables were skipped
>
> has anyone experienced this before and if so any ideas as to the cause
> and solution to the problem I am running on win 98

OK, firstly, if I was you, I'd use the SQL Enterprise Manager to do the
upload, not the Access one - SQL Enterprise Manager knows SQL Server a LOT
better than Access does, so it understands the imports a lot better

A couple of other things you'll meet on the way up;
The Import routine naturally drops AutoNumbers (known as Identity in SQL
Server), but if you use any sort of Normalised or Denormalised data, -=DO
NOT=- convert them to Identity during the import... this will renumber the
field and screw your existing data. Convert them to Identity AFTER they are
imported into the SQL Server databases

Also, once you've converted to SQL Server, Text (from Access) will become
nVarchar and Memo will become nText - DO NOT keep them as the "n" variants -
these are UNICODE fields, and take up twice the space - also, older MDACs
(v2.1 I think) doesn't allow CF to read UNICODE fields - remove the "n" so
they become Varchar and Text

Oh, and one last thing - If you don't mind losing the Seconds from DateTime
fields, you can use SmallDateTime, this will save you 4 bytes per record,
but it does remove the Seconds and fractions...

Hope this all helps

Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**


--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: CF / Oracle / Solaris locale

[Helge Hetland]

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:[EMAIL PROTECTED]]
Sent: Saturday, July 01, 2000 8:57 PM
To: [EMAIL PROTECTED]
Subject: Re: CF / Oracle / Solaris locale


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 10:35 PM
Subject: RE: CF / Oracle / Solaris locale


> 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 didn't work before this? We cannot use Norwegian
> characters among others (ÆØÅ: AE ligature, O Slash, A ring) can you insert
> this chars into your system?
>
> Helge Hetland
>
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: UPS CHECK DIGIT

[pan]

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 (shipper
created).

UPS uses MOD 10 check digits 

As an example, we will use 01234567890 as our first 11 digits
Step 1. Sum all digits in the ODD positions.
Example: 0 + 2 + 4 + 6 + 8 + 0 = 20
Step 2. Multiply this SUM by 3.
Example: 20 x 3 = 60
Step 3. Sum all digits in the EVEN positions.
Example: 1 + 3 + 5 + 7 + 9 = 25
Step 4. Add the SUM from Step 3 to the PRODUCT in Step 2. 
Example: 25 + 60 = 85 
Step 5. The CHECKSUM value is the smallest number which when added
to the SUM of Step 4 produces a multiple of 10
Example: The smallest number which, when added to 85, produces a multiple 
of 10 is 5 (85 + 5 = 90). Therefore, our checkdigit for the number above is 5.

There are numerous sample implementations on the net. a cursory search
found perl scripts, a javascript validator ... etc. etc.

UPS provides a boat load of free software for developers ... sign up for a
myUPS account and go to online tools. They have a very complete collection
with lots of interfacing solutions/data formatting routines/error message
return control algorithms/fully prepped datastreaming modules 
You can get inline html codings, datastream cgi access, or full blown
third party developer utilities and documentation.

Seems it would be easier to just use their tools and, if you need to do any
tracking number checking independent of their online system, all your answers
(specially prepped for their methods) are contained in the open source code
of their developer packages. I would be more confident of any CF tags that
are based on UPS documentation - besides you'll be able to develop templates
that take advantage of all the UPS services besides just tracking.

UPS doesn't call their developer tool set a SDK, but if you think of it as
being that, you won't go wrong.

Pan


--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CF / Oracle / Solaris locale

[Stanislav Maximov]

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 10:35 PM
Subject: RE: CF / Oracle / Solaris locale


> 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 didn't work before this? We cannot use Norwegian
> characters among others (ÆØÅ: AE ligature, O Slash, A ring) can you insert
> this chars into your system?
>
> Helge Hetland
>
> -Original Message-
> From: Stanislav Maximov [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, July 01, 2000 8:14 PM
> To: [EMAIL PROTECTED]
> Subject: Re: CF / Oracle / Solaris locale
>
>
> 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
>
>
> >
> > 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 as they start again after their long weekend.
Will
> > keep you posted if/when we get a solution.
> >
> > Helge
> >
> >
> >
> > -Original Message-
> > From: Stanislav Maximov [mailto:[EMAIL PROTECTED]]
> > Sent: Saturday, July 01, 2000 5:03 PM
> > To: [EMAIL PROTECTED]
> > Subject: Re: CF / Oracle / Solaris locale
> >
> >
> > 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, July 02, 2000 6:41 PM
> > Subject: RE: CF / Oracle / Solaris locale
> >
> >
> > > 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 application is overdue (July 1st was the
release
> > > date)
> > > The hardware/software is already installed, waiting for our
application.
> > >
> > > With about 35 000 potential users waiting for this you can imagine the
> > > stress
> > >
> > > We should of course have tested it on Oracle earlier, but since it was
> > > running so smoothly on MSSQL we believed it was just a matter of
> changing
> > > the SQL to work also in Oracle as soon as the DBA's finished setting
up
> > the
> > > Oracle solution...
> > >
> > > Helge
> > >
> > > -Original Message-
> > > From: Stanislav Maximov [mailto:[EMAIL PROTECTED]]
> > > Sent: Saturday, July 01, 2000 4:10 PM
> > > To: [EMAIL PROTECTED]
> > > Subject: Re: CF / Oracle / Solaris locale
> > >
> > >
> > > 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+Sybase on Linux.
> > > 2. Try WinNT instead of Linux - not very stable, but thus we can work
> for
> > > the weeks till SP1 will be released.
> > >
> > > Helge, have you tried any successfull workarounds?
> > >
> > > Best wishes,
> > > Stanislav Maximov
> > >
> > > - Original Message -
> > > From: "Helge Hetland" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Saturday, July 01, 2000 8:30 PM
> > > Subject: RE: CF / Oracle / Solaris local
> > >
> > >
> > > > Hello!
> > > >
> > > > We've had it confirmed from Allaire that this is a bug in 4.51 and
> that
> > it
> > > > will be fixed in SP1..
> > > >
> > > > We tried SP1 Alpha with no luck and we have case open at Allaire on
> > this.
> > > >
> > > > Maybe we could work together on this to speed the process of getting
> it
> > > > fixed?
> > > >
> > > > Helge
> > > > WebSite AS
> > > >
> > > >
> > >
> >
>
> --
> > 
> > > Archives: http://www.eGroups.com/list/cf-talk
> > > To Unsubscribe visit
> > http://www.houseoffusion.c

RE: CF / Oracle / Solaris locale

[Helge Hetland]

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 didn't work before this? We cannot use Norwegian
characters among others (ÆØÅ: AE ligature, O Slash, A ring) can you insert
this chars into your system?

Helge Hetland

-Original Message-
From: Stanislav Maximov [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 01, 2000 8:14 PM
To: [EMAIL PROTECTED]
Subject: Re: CF / Oracle / Solaris locale


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


>
> 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 as they start again after their long weekend. Will
> keep you posted if/when we get a solution.
>
> Helge
>
>
>
> -Original Message-
> From: Stanislav Maximov [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, July 01, 2000 5:03 PM
> To: [EMAIL PROTECTED]
> Subject: Re: CF / Oracle / Solaris locale
>
>
> 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, July 02, 2000 6:41 PM
> Subject: RE: CF / Oracle / Solaris locale
>
>
> > 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 application is overdue (July 1st was the release
> > date)
> > The hardware/software is already installed, waiting for our application.
> >
> > With about 35 000 potential users waiting for this you can imagine the
> > stress
> >
> > We should of course have tested it on Oracle earlier, but since it was
> > running so smoothly on MSSQL we believed it was just a matter of
changing
> > the SQL to work also in Oracle as soon as the DBA's finished setting up
> the
> > Oracle solution...
> >
> > Helge
> >
> > -Original Message-
> > From: Stanislav Maximov [mailto:[EMAIL PROTECTED]]
> > Sent: Saturday, July 01, 2000 4:10 PM
> > To: [EMAIL PROTECTED]
> > Subject: Re: CF / Oracle / Solaris locale
> >
> >
> > 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+Sybase on Linux.
> > 2. Try WinNT instead of Linux - not very stable, but thus we can work
for
> > the weeks till SP1 will be released.
> >
> > Helge, have you tried any successfull workarounds?
> >
> > Best wishes,
> > Stanislav Maximov
> >
> > - Original Message -
> > From: "Helge Hetland" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Saturday, July 01, 2000 8:30 PM
> > Subject: RE: CF / Oracle / Solaris local
> >
> >
> > > Hello!
> > >
> > > We've had it confirmed from Allaire that this is a bug in 4.51 and
that
> it
> > > will be fixed in SP1..
> > >
> > > We tried SP1 Alpha with no luck and we have case open at Allaire on
> this.
> > >
> > > Maybe we could work together on this to speed the process of getting
it
> > > fixed?
> > >
> > > Helge
> > > WebSite AS
> > >
> > >
> >
>
> --
> 
> > 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 message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
>
> --
--
> --
> 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 message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 

Re: CF / Oracle / Solaris locale

[Stanislav Maximov]

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


>
> 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 as they start again after their long weekend. Will
> keep you posted if/when we get a solution.
>
> Helge
>
>
>
> -Original Message-
> From: Stanislav Maximov [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, July 01, 2000 5:03 PM
> To: [EMAIL PROTECTED]
> Subject: Re: CF / Oracle / Solaris locale
>
>
> 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, July 02, 2000 6:41 PM
> Subject: RE: CF / Oracle / Solaris locale
>
>
> > 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 application is overdue (July 1st was the release
> > date)
> > The hardware/software is already installed, waiting for our application.
> >
> > With about 35 000 potential users waiting for this you can imagine the
> > stress
> >
> > We should of course have tested it on Oracle earlier, but since it was
> > running so smoothly on MSSQL we believed it was just a matter of
changing
> > the SQL to work also in Oracle as soon as the DBA's finished setting up
> the
> > Oracle solution...
> >
> > Helge
> >
> > -Original Message-
> > From: Stanislav Maximov [mailto:[EMAIL PROTECTED]]
> > Sent: Saturday, July 01, 2000 4:10 PM
> > To: [EMAIL PROTECTED]
> > Subject: Re: CF / Oracle / Solaris locale
> >
> >
> > 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+Sybase on Linux.
> > 2. Try WinNT instead of Linux - not very stable, but thus we can work
for
> > the weeks till SP1 will be released.
> >
> > Helge, have you tried any successfull workarounds?
> >
> > Best wishes,
> > Stanislav Maximov
> >
> > - Original Message -
> > From: "Helge Hetland" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Saturday, July 01, 2000 8:30 PM
> > Subject: RE: CF / Oracle / Solaris local
> >
> >
> > > Hello!
> > >
> > > We've had it confirmed from Allaire that this is a bug in 4.51 and
that
> it
> > > will be fixed in SP1..
> > >
> > > We tried SP1 Alpha with no luck and we have case open at Allaire on
> this.
> > >
> > > Maybe we could work together on this to speed the process of getting
it
> > > fixed?
> > >
> > > Helge
> > > WebSite AS
> > >
> > >
> >
>
> --
> 
> > 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 message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
>
> --
--
> --
> 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 message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --

> 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 message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Log Off Routine

[Paige Chandler]

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 the user for using my web site and update my =
log record.  Is there sonething like a 'Submit' or 'Reset' procedure =
that exits the user from the site and returns him/her to the browser? =
TIA.

Regards,

Paige

--=_NextPart_000_0007_01BFE42E.EC943E30
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Hi All,
 
Could you point me to an example of a =
'Log Off"=20
routine that I could use. I would like to thank the user for using my =
web site=20
and update my log record.  Is there sonething like a 'Submit' or =
'Reset'=20
procedure that exits the user from the site and returns him/her to the =
browser?=20
TIA.
 
Regards,
 
Paige

--=_NextPart_000_0007_01BFE42E.EC943E30--

--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Fusion Authority Weekly News Letter

[Gary J. Groomer]

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 unsubscribing, but all that does is =
add another issue.  Does anyone know how to reduce this to one issue per =
week?

Gary Groomer

--=_NextPart_000_0060_01BFE409.04993010
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Somehow, I am subscribed to multiple =
issues of the=20
Fusion Authority Weekly News Letter.  I have tried unsubscribing, =
but all=20
that does is add another issue.  Does anyone know how to reduce =
this to one=20
issue per week?
 
Gary Groomer

--=_NextPart_000_0060_01BFE409.04993010--

--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: UPS CHECK DIGIT

[Zachary Bedell]

-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 yet.  Thanks for the reminder, tho!

Best regards,
Zac Bedell

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.2 for non-commercial use 
Comment: Please use PGP!!!

iQA/AwUBOV9vewraVoMWBwRBEQINiQCg8kKYoJOdcsPxm/mOJ28iDhRPG0gAoMnO
811ToasMV4VtDwsVcSqdICfO
=ZktW
-END PGP SIGNATURE-
--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: CF / Oracle / Solaris locale

[Helge Hetland]

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 as they start again after their long weekend. Will
keep you posted if/when we get a solution.

Helge



-Original Message-
From: Stanislav Maximov [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 01, 2000 5:03 PM
To: [EMAIL PROTECTED]
Subject: Re: CF / Oracle / Solaris locale


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, July 02, 2000 6:41 PM
Subject: RE: CF / Oracle / Solaris locale


> 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 application is overdue (July 1st was the release
> date)
> The hardware/software is already installed, waiting for our application.
>
> With about 35 000 potential users waiting for this you can imagine the
> stress
>
> We should of course have tested it on Oracle earlier, but since it was
> running so smoothly on MSSQL we believed it was just a matter of changing
> the SQL to work also in Oracle as soon as the DBA's finished setting up
the
> Oracle solution...
>
> Helge
>
> -Original Message-
> From: Stanislav Maximov [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, July 01, 2000 4:10 PM
> To: [EMAIL PROTECTED]
> Subject: Re: CF / Oracle / Solaris locale
>
>
> 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+Sybase on Linux.
> 2. Try WinNT instead of Linux - not very stable, but thus we can work for
> the weeks till SP1 will be released.
>
> Helge, have you tried any successfull workarounds?
>
> Best wishes,
> Stanislav Maximov
>
> - Original Message -
> From: "Helge Hetland" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, July 01, 2000 8:30 PM
> Subject: RE: CF / Oracle / Solaris local
>
>
> > Hello!
> >
> > We've had it confirmed from Allaire that this is a bug in 4.51 and that
it
> > will be fixed in SP1..
> >
> > We tried SP1 Alpha with no luck and we have case open at Allaire on
this.
> >
> > Maybe we could work together on this to speed the process of getting it
> > fixed?
> >
> > Helge
> > WebSite AS
> >
> >
>
> --

> 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 message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>


--
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 message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CF / Oracle / Solaris locale

[Stanislav Maximov]

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, July 02, 2000 6:41 PM
Subject: RE: CF / Oracle / Solaris locale


> 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 application is overdue (July 1st was the release
> date)
> The hardware/software is already installed, waiting for our application.
>
> With about 35 000 potential users waiting for this you can imagine the
> stress
>
> We should of course have tested it on Oracle earlier, but since it was
> running so smoothly on MSSQL we believed it was just a matter of changing
> the SQL to work also in Oracle as soon as the DBA's finished setting up
the
> Oracle solution...
>
> Helge
>
> -Original Message-
> From: Stanislav Maximov [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, July 01, 2000 4:10 PM
> To: [EMAIL PROTECTED]
> Subject: Re: CF / Oracle / Solaris locale
>
>
> 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+Sybase on Linux.
> 2. Try WinNT instead of Linux - not very stable, but thus we can work for
> the weeks till SP1 will be released.
>
> Helge, have you tried any successfull workarounds?
>
> Best wishes,
> Stanislav Maximov
>
> - Original Message -
> From: "Helge Hetland" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, July 01, 2000 8:30 PM
> Subject: RE: CF / Oracle / Solaris local
>
>
> > Hello!
> >
> > We've had it confirmed from Allaire that this is a bug in 4.51 and that
it
> > will be fixed in SP1..
> >
> > We tried SP1 Alpha with no luck and we have case open at Allaire on
this.
> >
> > Maybe we could work together on this to speed the process of getting it
> > fixed?
> >
> > Helge
> > WebSite AS
> >
> >
>
> --

> 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 message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: CF / Oracle / Solaris locale

[Helge Hetland]

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 application is overdue (July 1st was the release
date)
The hardware/software is already installed, waiting for our application. 

With about 35 000 potential users waiting for this you can imagine the
stress

We should of course have tested it on Oracle earlier, but since it was
running so smoothly on MSSQL we believed it was just a matter of changing
the SQL to work also in Oracle as soon as the DBA's finished setting up the
Oracle solution...

Helge

-Original Message-
From: Stanislav Maximov [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 01, 2000 4:10 PM
To: [EMAIL PROTECTED]
Subject: Re: CF / Oracle / Solaris locale


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+Sybase on Linux.
2. Try WinNT instead of Linux - not very stable, but thus we can work for
the weeks till SP1 will be released.

Helge, have you tried any successfull workarounds?

Best wishes,
Stanislav Maximov

- Original Message -
From: "Helge Hetland" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, July 01, 2000 8:30 PM
Subject: RE: CF / Oracle / Solaris local


> Hello!
>
> We've had it confirmed from Allaire that this is a bug in 4.51 and that it
> will be fixed in SP1..
>
> We tried SP1 Alpha with no luck and we have case open at Allaire on this.
>
> Maybe we could work together on this to speed the process of getting it
> fixed?
>
> Helge
> WebSite AS
>
>

--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CF / Oracle / Solaris locale

[Stanislav Maximov]

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+Sybase on Linux.
2. Try WinNT instead of Linux - not very stable, but thus we can work for
the weeks till SP1 will be released.

Helge, have you tried any successfull workarounds?

Best wishes,
Stanislav Maximov

- Original Message -
From: "Helge Hetland" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, July 01, 2000 8:30 PM
Subject: RE: CF / Oracle / Solaris locale


> Hello!
>
> We've had it confirmed from Allaire that this is a bug in 4.51 and that it
> will be fixed in SP1..
>
> We tried SP1 Alpha with no luck and we have case open at Allaire on this.
>
> Maybe we could work together on this to speed the process of getting it
> fixed?
>
> Helge
> WebSite AS
>
>
> > -Original Message-
> > From: Stanislav Maximov [mailto:[EMAIL PROTECTED]]
> > Sent: 30. juni 2000 18:34
> > To: [EMAIL PROTECTED]
> > Subject: Re: CF / Oracle / Solaris locale
> >
> >
> > looks like i'm having the same problem on linux. any help
> > from the list?
> >
> > stas@
> >
> > - Original Message -
> > From: "Helge Hetland" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Friday, June 30, 2000 3:52 PM
> > Subject: CF / Oracle / Solaris locale
> >
> >
> > > I'm inserting a 8 bit character into an Oracle db,
> > selecting the same data
> > > gets 7bit characters.
> > >
> > >
> > > The system is:
> > >
> > > CF 4.51 Enterprise Solaris
> > > Solaris 2.6 / SUN HW
> > > Oracle 8.1.6.0.0
> > >
> > > The locale environment variables:
> > > LANG=no
> > > LC_CTYPE=iso_8859_1
> > > LC_NUMERIC=no
> > > LC_TIME=no
> > > LC_COLLATE=no
> > > LC_MONETARY=no
> > > LC_MESSAGES=C
> > > LC_ALL=
> > >
> > > (It's quite possible that both Oracle and CF was installed
> > with other
> > locale
> > > variables, but that shouldn't be a problem?)
> > >
> > > Helge
> > >
> > --
> > 
> > 
> > > Archives: http://www.eGroups.com/list/cf-talk
> > > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> s/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
>
> --
--
> --
> 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 message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --

> 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 message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: UPS CHECK DIGIT

[Justin v0.9 MacCarthy]

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: RE: UPS CHECK DIGIT


> -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 Bedell
>
> 
>
> 
> 
>  Len(TrackingNumber) - 2)>
> 
>
> 
> 
> 
> 
> 
> 
> 
>
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>
>
> -BEGIN PGP SIGNATURE-
> Version: PGPfreeware 6.5.3 for non-commercial use 
>
> iQA/AwUBOV9FWAraVoMWBwRBEQI5LwCgij+D/1gd5yYg3gaawmpfeeyFaJoAn0AM
> qIetaKh9+3recuB2SXkNgehD
> =C8gi
> -END PGP SIGNATURE-
> --

> 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 message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
>

--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: UPS CHECK DIGIT

[Zachary Bedell]

-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 Bedell









  
 



 







 








-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.3 for non-commercial use 

iQA/AwUBOV9FWAraVoMWBwRBEQI5LwCgij+D/1gd5yYg3gaawmpfeeyFaJoAn0AM
qIetaKh9+3recuB2SXkNgehD
=C8gi
-END PGP SIGNATURE-
--
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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: UPS CHECK DIGIT

[Sean Renet]

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.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

UPS CHECK DIGIT

[Sean Renet]

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 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.