Re: CFPROCPARAM behavior change with MX+Oracle?

[freddy]

Whenever I have used  ORACLE stored procs (and we use ORACLE and SPs 
eclusively here) with CF version 4, 4.5.1, 5  I have had to specify the 
params in order or I recieved the "wrong number of  calls or types" 
error. As far as I know this has always been the situation but I 
could always be wrong.

Frederic


[EMAIL PROTECTED] wrote:

>Hey all,
>
>I'm wondering if anybody else has noticed that CFStoredProc and
>CFProcParam behavior has changed (with Oracle) from Pre-MX to MX with
>respect to 'Named Notation' no longer working for Oracle in MX?  Or was
>everybody just smart and have their CFProcParams in the right order
>before?
>
>In Pre-MX, you didn't have to have your CFProcParams in the same order
>as the SP (in Oracle).
>
>In MX, you do - which is consistant with Oracle JDBC.
>
>Or am I crazy...
>


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

ORACLE refcursors in CFMX

[freddy]

What syntax do I use in cfmx to retrieve oracle ref cursors as cf 
recordsets?
The following is what I used in CF5 but it doesn't work in MX:




 



Thanks,

Frederic

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CF Developer Needed Immediately - crosspost

[Freddy]

The company I work for is currently looking for an experienced (mid-senior level)
ColdFusion developer.
 Other skills desirable are:
1) Oracle PL/SQL
2) Javascript
3) DHTML
4) Dreamweaver/Ultradev/Coldfusion Studio

This would be a 4 month contract. Onsite in Raleigh, NC. No relocation. The
candidate would be providing maintanance for our current web applications and
assisting on an extensive overhaul of our on-line store.

If you are interested please contact me offlist.
 Thank You,
 Frederic
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: [OT] Re: VTML Builder

[freddy]

If you had cared to read through the post you would have seen a legitimate question. 
Again if you don't want to read it
delete it.
Thank you,
 Frederic

Paul Giesenhagen wrote:

> Take your little disagreement offline.
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector - Commerce Builder
> - Original Message -
> From: "freddy" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, March 07, 2002 2:24 PM
> Subject: Re: [OT] Re: VTML Builder
>
> > I already get a ton of spam...I don't like it so I delete it.  And also I
> do not mind  filling out forms writing, or
> > deleting emails. Besides it seems I get so many more responses to any
> criticism I make on this list than I do to any of
> > the questions I have needed answered so I thought I'd do it again :-)
> > I am still waiting for a single response to my question about char fields
> returned via stored procedures in oracle being
> > padded to a length of 255 and whether it is a bug or there is a way around
> it.
> > Thanks in advance...
> >
> > Gyrus wrote:
> >
> > > > What difference does it make? If you want it fill out the info...
> > > > it is faster than writing an email to complain about it.
> > >
> > > Maybe I'm being too cynical, but to me *spam* makes the
> > > difference. I was just looking for some assurance that the
> > > download is actually *free*, and not paid for by allowing
> > > the people you give your info to to sell that info on for
> > > marketing (I couldn't see any assurance on the site).
> > >
> > > BTW, it would have been faster for you to not criticise
> > > my questioning than to do so (nod to Bill Hicks ;)
> > >
> > > - Gyrus
> > >
> > > 
> > > - [EMAIL PROTECTED]
> > > work: http://www.tengai.co.uk
> > > play: http://www.norlonto.net
> > > - PGP key available
> > > 
> > >
> >
> 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: [OT] Re: VTML Builder

[freddy]

They are padded all the time the char fields in question range in length from char(4) 
to char(10). Also a single trim()
doesn't work. I need to trim(trim()) or the length of the field is still 254. I have 
no control over how the data will
be stored in the database. I have requested they all be converted to varchar fields 
but it doesn't happen. If a single
trim would work I would not worry so much but again I am trying to compare values held 
in cf variables that are now 255
to database fields that are 4-10 chars long. A trim wouldn't help me there unless I 
have the oracle developers trim all
the values coming out of the database in the stored proc and trim(trim()) the char 
field. This has been going on since
version 4 and we are now on version 5 of cf.
Thanks

Jerry Johnson wrote:

> Are they padded to 255 all the time, or does that char field have a length
> or 255?
>
> My understanding is that the char would return a string with the entire
> length of the field. That is the main difference between a char and a
> varchar (which would return a string only as long as the data put into the
> field.)
>
> 1. change it to a varchar
> or
> 2. trim() it before use.
>
> Jerry Johnson
>
> >>> [EMAIL PROTECTED] 03/07/02 03:24PM >>>
> I already get a ton of spam...I don't like it so I delete it.  And also I
> do not mind  filling out forms writing, or
> deleting emails. Besides it seems I get so many more responses to any
> criticism I make on this list than I do to any of
> the questions I have needed answered so I thought I'd do it again :-)
> I am still waiting for a single response to my question about char fields
> returned via stored procedures in oracle being
> padded to a length of 255 and whether it is a bug or there is a way around
> it.
> Thanks in advance...
>
> Gyrus wrote:
>
> > > What difference does it make? If you want it fill out the info...
> > > it is faster than writing an email to complain about it.
> >
> > Maybe I'm being too cynical, but to me *spam* makes the
> > difference. I was just looking for some assurance that the
> > download is actually *free*, and not paid for by allowing
> > the people you give your info to to sell that info on for
> > marketing (I couldn't see any assurance on the site).
> >
> > BTW, it would have been faster for you to not criticise
> > my questioning than to do so (nod to Bill Hicks ;)
> >
> > - Gyrus
> >
> > 
> > - [EMAIL PROTECTED]
> > work: http://www.tengai.co.uk
> > play: http://www.norlonto.net
> > - PGP key available
> > 
> >
>
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: [OT] Re: VTML Builder

[freddy]

I already get a ton of spam...I don't like it so I delete it.  And also I do not mind  
filling out forms writing, or
deleting emails. Besides it seems I get so many more responses to any criticism I make 
on this list than I do to any of
the questions I have needed answered so I thought I'd do it again :-)
I am still waiting for a single response to my question about char fields returned via 
stored procedures in oracle being
padded to a length of 255 and whether it is a bug or there is a way around it.
Thanks in advance...

Gyrus wrote:

> > What difference does it make? If you want it fill out the info...
> > it is faster than writing an email to complain about it.
>
> Maybe I'm being too cynical, but to me *spam* makes the
> difference. I was just looking for some assurance that the
> download is actually *free*, and not paid for by allowing
> the people you give your info to to sell that info on for
> marketing (I couldn't see any assurance on the site).
>
> BTW, it would have been faster for you to not criticise
> my questioning than to do so (nod to Bill Hicks ;)
>
> - Gyrus
>
> 
> - [EMAIL PROTECTED]
> work: http://www.tengai.co.uk
> play: http://www.norlonto.net
> - PGP key available
> 
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: VTML Builder

[freddy]

What difference does it make? If you want it fill out the info... it is faster than 
writing an email to complain about
it.


Gyrus wrote:

> > I am proud to announce the availability of our VTML Builder tool for
> > both use on our site and download.
>
> Looks great!
>
> Can you download it without filling in all that info?
> Pretty pointless to fill in Mailing stuff, or anything really
> apart from email address, if it's free. Unless you've got
> some ulterior motives in collecting this info ;)
>
> - Gyrus
>
> 
> - [EMAIL PROTECTED]
> work: http://www.tengai.co.uk
> play: http://www.norlonto.net
> - PGP key available
> 
> 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Is this a known bug with cf and oracle?

[Freddy]

Ever since coming over to an ORACLE/Solaris envirionment I have had a
problem taking char(x) field and having it return with the right length. No
matter what length char field I use I get a length of 255 returned when
called from a pl/sql procedure.If the variable is not trimmed twice
trim(trim(#var#)) it will not go back into the database. This has been the
situation since version 4 of cfserver and version 7.3 of ORACLE we are now
on CF 5 and ORACLE 8i. Still the same problems.

Anyone else experience this?

Thanks,
 Frederic
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

crosspost:Oracle connection using native drivers

[freddy]

I have a question regarding the use of oracle native drivers with oracle 8i and cf 5.
We have a user account set up for coldfusion that allows 50 connections.
However at any given time even under extreme load only one connection is actively 
doing anything in oracle. The other
connections just sit idle. Durring this time we are also seeing huge numbers of 
timeouts and restarts. We have worked
with all the settings in cf administrator and have come to the conclusion (and 
confimed with our macromedia tech)  that
the problem is not  in the cfsettings or the application. If we set up a different 
datasource using another user account
and hit the database another
connection instantly becomes active. To me this suggests that although the account set 
up for cf has 50 available
connections to oracle, oracle is limiting processing to only a single connection at 
any one time.

 I have very little administrative experience in oracle so I cannot properly explain 
to our dba what may be going on or
how to fix it. Can anyone help me on this?
A: how is it possible that the issue I elude to above is actually happening.
B: what can be done to allow multiple connections to process simultaneously
in oracle.

thanks frederic
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: excessive server restarts

[Freddy]

We are currently getting an inordinant amount of restarts as well. We also see
alot (over 10,000) i/o errors a day due to clients not waiting for a response from
our bogged down oracle 8i database server. We also recieved over 7,000 timeouts
even after bumping the timeout up to 45 second and still get the restarts after
turning off the "restart after .. unresponsive threads" I have gone over this many
times with our dba's but it seems that our managment is unconcerned with a
horribily slow website compared to wanting to do test restores of a 14 tera-gig db
on our ecom database server durring peak usage times of our website. What I am
saying is check the database server for bottlenecks there. It is what brings our
cf server and apps crashing down regularly.
 Thanks,
 Frederic

Jennifer Knoblock wrote:

> My CF Server 4.5 SP2 Professional for Linux has restarted 11 times
> already today (11:30 am). Yesterday it restarted 30 times. A few
> days ago it was only 5 or 6 times. Can someone tell me why it's
> doing this and how to fix it?
>
> Thanks!
> Jen
> 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: oracle date/time

[freddy]

Thanks to everyone.
 I already had the date formatting correct.
I was using a  perl script to generate the  for some reason it didn't 
like the date datatype in oracle and
defaulted the cfsqltype to varchar. Changing the cfsqltype to date fixed the problem.

Thanks again,
 Frederic

Tony Schreiber wrote:

> Oracle needs to know exactly what date format your passing...
>
> You could use CF to format the date to default oracle format first:
>
> value="#DateFormat(date,'DD-MMM-')#"
>
> > I am using cf5 and  to insert a date/time into oracle 8i. I
> f I
> > pass only the date like this:
> >  >  dbvarname="in_DATE_EVENT_END"
> >  cfsqltype="cf_sql_varchar"
> >  value="03-Jan-2002"
> >  type="in">
> >  It works fine. but when I attempt to include the time as 03-Jan-2002 00:
> 00
> > I get the following error
> > ORA-01830: date format picture ends before converting entire input
> >  string ORA-06512: at line 1
> >  anyone have any idea as to what I can do to insert a complete datetime
> > value in oracle?
> >
> > Thanks in advance,
> >  Frederic
> >
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

oracle date/time

[freddy]

I am using cf5 and  to insert a date/time into oracle 8i. If I
pass only the date like this:

 It works fine. but when I attempt to include the time as 03-Jan-2002 00:00
I get the following error
ORA-01830: date format picture ends before converting entire input
 string ORA-06512: at line 1
 anyone have any idea as to what I can do to insert a complete datetime
value in oracle?

Thanks in advance,
 Frederic
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Stored procedures for queries

[Freddy]

I agree with this in most cases. However it is not currently possible to cache
oracle stored procs in cf (except by assigning the results to session or
application variables). Also on most simple selects I found that the time for
processing was faster using embedded cf queries that calling a stored procedure.

This was using oracle 8i on solaris.

thanks,
 Frederic

Jon Hall wrote:

> If you are concerned about performance, converting cfquery's to stored
> procedures is the best way to optimize an application. Even for selects.
>
> jon
>
> Stephen Hait wrote:
>
> >I've been wondering about using stored
> >procedures in templates instead of
> >embedding queries. Is there a good reason
> >for this if the queries are only select
> >statements?
> >
> >Stephen
> >
>
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: If anyone else needs zip codes just speak up.

[freddy]

No PITA  is a middle eastern bread.

Douglas Brown wrote:

> A PITA Isnt that mexican bread lol :)
>
> Doug
>
> - Original Message -
> From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, December 07, 2001 9:41 AM
> Subject: RE: If anyone else needs zip codes just speak up.
>
> > Sorry to be a PITA, but does this type of traffic REALLY need to go via
> > the CF-Talk list?
> >
> > Can't they be sent personally?
> >
> > There's enough traffic without this background-noise going on
> >
> > Thanks
> >
> > Philip Arnold
> > Technical Director
> > Certified ColdFusion Developer
> > ASP Multimedia Limited
> > T: +44 (0)20 8680 1133
> > F: +44 (0)20 8686 7911
> >
> > An ISO9001 registered company.
> >
> > **
> > 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.
> > **
> >
> >
> > > -Original Message-
> > > From: Kris Pilles [mailto:[EMAIL PROTECTED]]
> > > Sent: 07 December 2001 17:33
> > > To: CF-Talk
> > > Subject: RE: If anyone else needs zip codes just speak up.
> > >
> > >
> > > Me too
> > >
> > >
> > > Kris Pilles
> > > Website Manager
> > > Western Suffolk BOCES
> > > 507 Deer Park Rd., Building C
> > > Phone: 631-549-4900 x 267
> > > E-mail: [EMAIL PROTECTED]
> > >
> > >
> > > -Original Message-
> > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > > Sent: Friday, December 07, 2001 12:05 PM
> > > To: CF-Talk
> > > Subject: RE: If anyone else needs zip codes just speak up.
> > >
> > >
> > > Can I have a copy please?
> > >
> > > TIA
> > >
> > > Thanh
> > >
> > > -Original Message-
> > > From: Douglas L. Brown [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, November 29, 2001 1:39 PM
> > > To: CF-Talk
> > > Subject: If anyone else needs zip codes just speak up.
> > >
> > >
> > > Just though I would share the zip codes with whoever might need them.
> > > Just let me know
> > >
> > >
> > >
> > >
> > >  > > NAME="Douglas L. Brown"
> > > EMAIL="[EMAIL PROTECTED]"
> > > PHONE="714.538.6611"
> > > WEB="http://www.carnivorepc.com";>
> > >
> > >
> > >
> > >
> >
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Get PK value from Oracle table with AutoNumber Trigger (tds)?

[freddy]

I would use a stored procedure. Only because I have yet to learn how to connect to a 
function in oracle via cf. If this cane be done please let me know
what syntax to use.

Thanks,
 Frederic

Troy Simpson wrote:

> Freddy,
>
> I believe that using a stored procedure might be the way to go with this.
> Should I use a Procedure or a Function though?
>
> I was thinking that if I used a function, I could call it like this in a  
>statement:
>
> 
>SELECT
>  Add_Record( "My Name" ) AS PrimaryKey
>FROM
>  dual
> 
>
> Or would using a procedure with IN OUT variables be the better route?
>
> Thanks,
> Troy
>
> freddy wrote:
>
> > You could try:
> > 
> > 
> >   SELECT
> > tbl_seq.nextval as tbl_currval
> >   FROM
> > dual
> > 
> >
> > 
> >   Insert Into tbl( name )
> >   values( 'My Name' )
> > 
> > 
> >
> > I am not sure if this would work but it seems that it would get the nextval prior 
>to it being assingned using the
> > trigger.
> >
> > Alternately couldn't you also use a stored procedure to insert the the name and 
>return the curval?
> >
> > Thanks,
> >  Frederic
> >
> > Troy Simpson wrote:
> >
> > > Dave,
> > >
> > > Thanks for bring the CURRVAL pseudocolumn to light.
> > > I forgot to mention this part.
> > > I used the NEXTVAL pseudocolumn in the first  INSERT statement as
> > > follows:
> > >
> > >
> > >   Insert Into tbl( name )
> > >   values( 'My Name' )
> > > 
> > >
> > > I then use another  to get the value in the CURRVAL pseudocolumn as
> > > follow   
> > >   SELECT
> > > tbl_seq.currval as tbl_currval
> > >   FROM
> > > dual
> > > s:
> > >
> > >
> > > I get the following Oracle error:
> > >
> > > ORA-08002: sequence TBL_SEQ.CURRVAL is not yet defined in this session
> > >
> > > According to the documentation it say this (Pay close attention to the last
> > > sentence):
> > >
> > > When you create a sequence, you can define its initial value and the
> > > increment between its values. The first reference to NEXTVAL returns the
> > > sequence's initial value. Subsequent references to NEXTVAL increment the
> > > sequence value by the defined increment and return the new value. Any
> > > reference to CURRVAL always returns the sequence's current value, which is
> > > the value returned by the last reference to NEXTVAL. Note that before you
> > > use CURRVAL for a sequence in your session, you must first initialize the
> > > sequence with NEXTVAL.
> > >
> > > According to the last sentence, I can only assume that the reason CURRVAL is
> > > not available is because each  statement creates a new Oracle
> > > Session.  Therefore CURRVAL is never available.  Also since it is possible
> > > that ColdFusion maintains persistant connects for all web requests, this
> > > might introduce problems.
> > >
> > > I thought that I might be able to put two statements into one .
> > > I have not tried this, but I would assume that it is not possible.
> > >
> > > Any other ideas?
> > > Thanks for your input.
> > >
> > > Sincerely,
> > > Troy
> > >
> > > Dave Carabetta wrote:
> > >
> > > > Correct me if I'm wrong, but you should be able to get the current value
> > > > by using currval. For example, from your post, your sequence name is
> > > > tbl_seq. Therefore, you would just type "tbl_seq.currval" to get the
> > > > current value, which should also be the max id value. This is one of
> > > > those really nice feature of Oracle over SQL Server.
> > > >
> > > > Hope this helps,
> > > > Dave.
> > > >
> > > > -Original Message-
> > > > From: Troy Simpson [mailto:[EMAIL PROTECTED]]
> > > > Sent: Thursday, December 06, 2001 06:12 PM
> > > > To: CF-Talk
> > > > Subject: Get PK value from Oracle table with AutoNumber Trigger (tds)?
> > > >
> > > > All,
> > > >
> > > > I have read the the various postings about using the MAX() function to
> > > > get the last value entered into the Primary Key field.
> > &g

Re: Get PK value from Oracle table with AutoNumber Trigger (tds)?

[freddy]

You could try:


  SELECT
tbl_seq.nextval as tbl_currval
  FROM
dual



  Insert Into tbl( name )
  values( 'My Name' )



I am not sure if this would work but it seems that it would get the nextval prior to 
it being assingned using the
trigger.

Alternately couldn't you also use a stored procedure to insert the the name and return 
the curval?

Thanks,
 Frederic


Troy Simpson wrote:

> Dave,
>
> Thanks for bring the CURRVAL pseudocolumn to light.
> I forgot to mention this part.
> I used the NEXTVAL pseudocolumn in the first  INSERT statement as
> follows:
>
>
>   Insert Into tbl( name )
>   values( 'My Name' )
> 
>
> I then use another  to get the value in the CURRVAL pseudocolumn as
> follow   
>   SELECT
> tbl_seq.currval as tbl_currval
>   FROM
> dual
> s:
>
>
> I get the following Oracle error:
>
> ORA-08002: sequence TBL_SEQ.CURRVAL is not yet defined in this session
>
> According to the documentation it say this (Pay close attention to the last
> sentence):
>
> When you create a sequence, you can define its initial value and the
> increment between its values. The first reference to NEXTVAL returns the
> sequence's initial value. Subsequent references to NEXTVAL increment the
> sequence value by the defined increment and return the new value. Any
> reference to CURRVAL always returns the sequence's current value, which is
> the value returned by the last reference to NEXTVAL. Note that before you
> use CURRVAL for a sequence in your session, you must first initialize the
> sequence with NEXTVAL.
>
> According to the last sentence, I can only assume that the reason CURRVAL is
> not available is because each  statement creates a new Oracle
> Session.  Therefore CURRVAL is never available.  Also since it is possible
> that ColdFusion maintains persistant connects for all web requests, this
> might introduce problems.
>
> I thought that I might be able to put two statements into one .
> I have not tried this, but I would assume that it is not possible.
>
> Any other ideas?
> Thanks for your input.
>
> Sincerely,
> Troy
>
> Dave Carabetta wrote:
>
> > Correct me if I'm wrong, but you should be able to get the current value
> > by using currval. For example, from your post, your sequence name is
> > tbl_seq. Therefore, you would just type "tbl_seq.currval" to get the
> > current value, which should also be the max id value. This is one of
> > those really nice feature of Oracle over SQL Server.
> >
> > Hope this helps,
> > Dave.
> >
> > -Original Message-
> > From: Troy Simpson [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, December 06, 2001 06:12 PM
> > To: CF-Talk
> > Subject: Get PK value from Oracle table with AutoNumber Trigger (tds)?
> >
> > All,
> >
> > I have read the the various postings about using the MAX() function to
> > get the last value entered into the Primary Key field.
> > This will not do for me as you will see.
> > Plus I believe it is proned to errors.
> >
> > I have a table that is defined as follows:
> > create table tbl ( pk number(11) not null primary key, name varchar2(20)
> > )
> >
> > I have created a sequences as follows:
> > create sequence tbl_seq;
> >
> > The table has a trigger on the PK column for autonumbering and it is
> > defined as follows:
> > create trigger tbl_autonumber before insert on tbl for each row
> > begin
> >  select tbl_seq.nextval into :NEW.pk from dual;
> > end;
> >
> > After four people have inserted four seperate new records at the same
> > time, how can I find out the Primary Key that was assigned to my new
> > record?
> >
> > Here is a possible solution that I was thinking about but not sure if it
> > is the optimal solution.
> > Add an additional column to the table and use it as a stamp.
> > When I insert the new record I would put a unique number into this
> > column so that I can find the record in my next SELECT query.
> >
> > Ideally, I would like the INSERT statement to return the Primary Key
> > value to me.
> > Maybe an Oracle procedure or Oracle function would be the way to go.
> >
> > Sincerely,
> > Troy
> >
> > --
> > Troy Simpson | North Carolina State University
> > NCSU Libraries | Campus Box 7111 | Raleigh | North Carolina
> > ph.919.515.3855 | fax.919.513.3330
> >
> > It is better to be hated for what you are
> > than to be loved for what you are not.
> >   -- Andre Gide
> >
> >
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFToken and CFID not secure for ecommerce

[Freddy]

How would you do this on a solaris install?

Ken Wilson wrote:

> You just have to create it. Works great.
>
> Ken
>
> -Original Message-
> From: Douglas Brown [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 04, 2001 9:51 PM
> To: CF-Talk
> Subject: Re: CFToken and CFID not secure for ecommerce
>
> Well you were able to modify the registry in CF 4.5.1 and use the uuidToken
> which would be alphanumeric and identical in structure to a regular uuid. I
> looked in the registry for 5.0 and can no longer find the correct key.
>
> Doug
>
> - Original Message -
> From: "Ken Wilson" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, December 04, 2001 6:39 PM
> Subject: RE: CFToken and CFID not secure for ecommerce
>
> > Yeah, probably wasn't fair to use that example without explaining the
> > background. Are you aware of any drawbacks to using this rather than the
> > default method? Seems like it should be setup that way by default or at
> > least should be configurable via the CFAdmin given the ease of guessing
> the
> > other method.
> >
> > Ken
> >
> >
> >
> > -Original Message-
> > From: Dave Watts [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, December 04, 2001 9:27 PM
> > To: CF-Talk
> > Subject: RE: CFToken and CFID not secure for ecommerce
> >
> >
> > > Hmmm, interesting comment.
> > >
> > > What I assume to be my SessionID from my current Amazon.com
> > > sessions:
> > >
> > > IE Session:  104-8981534-3506318
> > > NS6 Session: 102-524-0108134
> > >
> > > CFTOKENs for my current sessions on my CF Server:
> > >
> > > IE Session:  3c154df-3b8b20b0-54b8-4cfa-8ebb-be0b2ac13e32
> > > NS6 Session: 3e97129-07682ed4-cd01-435a-959c-b70a06ebcb07
> > >
> > > My CFToken changes completely with each new session I create.
> > > Which seems more secure?
> >
> > By default, CFTOKEN values aren't UUIDs. You have to enable that by
> editing
> > the Registry. Unfortunately, this functionality isn't very well known - to
> > the best of my knowledge, it was mentioned in one set of
> > 4.5.something-or-other release notes, and that's it.
> >
> > To use UUIDs as CFTOKEN values, you have to create the registry key:
> >
> >
> HKEY_LOCAL_MACHINE\Software\Allaire\ColdFusion\CurrentVersion\Clients\UuidTo
> > ken
> >
> > and give it the value "1".
> >
> > Oddly enough, I'm covering this briefly in the "Securing ColdFusion
> Servers
> > on Windows" class, which is why it was fresh on my mind, I guess.
> >
> > Dave Watts, CTO, Fig Leaf Software
> > http://www.figleaf.com/
> > voice: (202) 797-5496
> > fax: (202) 797-5444
> >
> >
>
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Session and Client Variables

[Freddy]

Let me see. A scalable app that uses session vaiables? Try an application that
delivers personalized content. Store a cookie that logs the user in on entry to
the site. It then retrieves a list of links, images, and pertinent user info
that is stored in session variables. If the user moves to a different server on
the cluster it makes one more database call to repopulate the session variables.

No this isn't mission critical. However not all applications are. It is a large
application on a very busy site. It has worked flawlessly for the past year. One
critical application has had troubles and is in need of a major re-write (it
hasn't even been deployed yet). This was done by a contractor at my full time
workplace. They used over a hundred session variables. I told them not to do it
that way it was not a well thought out method but managment wouldn't listen,
they wanted it fast and the contractor was not very familiar with many other
methods to accomplish the requirments. (actually I recomended using wddx)

It seems to me there are many applications that are not going to have to scale.
It depends on the project. I always have tried to impress upon a client that
they may not want this (scalability) now they may in the future. It isn't
something you "add on" later. I have been told many times they are not going to
go to a server cluster so why spend the extra time and money building an
application for it? Some clients change their minds, but they are in the
minority.

Small shopping cart applications can use session variables to maintain state in
an application in association with cookies. I have built some very stable
applications that do just that and the client again has had no problems.

I am simply saying that session variables are not a horrible thing when used
correctly. They work "as advertised" it is up to the developer to know how and
when to use them. I look at  session variables like a motor scooter, great to go
down the street to the market and grab a coke and  some chips but I wouldn't try
to use it to go pick up a big screen tv. For that I'd use a van. The trick is to
know where your going before you choose how to get there.

Thanks,
 Frederic
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Session and Client Variables

[Freddy]

Kwang Suh wrote:

> > My heart goes out to you!  You sound like you've had a bad experience with
> a
> > session variable cult, or something.   But if used in its proper context,
> > session variables can change your (work) life.
>
> Yeah, but what's "proper context"?  Do people even bother to do enough
> analysis to say whether they should go client or session, or do people use
> session vars because that's what they've been using since they started using
> CF?

> I would think that any application should be built with a well thought out
> plan. Utilize whatever is best in a given situation. A proerly used session
> variable works better than an inproperly used client and vice versa.

>
> In your darkest hour, when
> > confronted with the need to pass queries of information, the number of
> rows
> > unbeknownst to you, from one page to another, over and over again in a
> > endless, vicious cycle, you might find that session variables are your
> only
> > hope.
>
> Hardly.  That's what WDDX is for.

WDDX is great for hanling large recordsets but it is not as fast to access as a
session scoped query on a seperate page. Again the method used is depoendent on
what you need to do.

>
>
> Yes, some people may have committed evil act in the name of session
> > variables, but don't let hypocrites turn you away from the tool that
> > delivered you from the hands of hidden form fields and time consuming
> > database calls.
>
> Why would I need hidden form fields and database calls when I'm using client
> variables?

Take a look at your database activity. Using client variables will generate a
database call. Also try holding a complex structure in a client variable.

I would say use what works for you. Do not rely on any one method overly much.
If you do you will find that you are not going to get the full benefits that
working a rich scripting language like cf can provide.

Just my 2cents worth
 Frederic
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Menu Custom Tags

[freddy]

Also check out http://www.akc.org  I used a reworked cf version of hiermenus to drive 
the dropdown lists on this site's
navigation menu.

Matt Robertson wrote:

> CF_Hiermenus.  Actually its a great script without the CF wrapper, albeit a
> tad slow.  Unmatched in its cross-browser compatibility, I think.  Go to
> palm.com to see one of its nicer iterations.  Also lucent.com; unisys.com;
> webtrends.com.  With a bit of serious elbow grease you can completely
> data-drive the thing (generating the controlling hmarrays.js via CF).
>
> -
> Matt Robertson  [EMAIL PROTECTED]
> MSB Designs, Inc. http://mysecretbase.com
> -
>
> - Original Message -
> From: "Michael T. Tangorre" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, October 31, 2001 9:26 PM
> Subject: Menu Custom Tags
>
> Can anyone reccomend a custom tag for Menus (DHTML, or anything else)???
>
> Thanks,
>
> Mike
>
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: JMAIL

[Freddy]

That is strange,
 We are currently running other server-side java and having no problems. It is
only giving us trouble through cf. I will relay this to the SA's and see what
happens.
 Thanks
 Frederic

Pete Freitag wrote:

> If the server is crashing when you click load jvm at startup, then you
> definitely have a problem with your JVM.  Goto http://java.sun.com and
> download the latest JRE and install it.  Have it point to the hotspot server
> libjvm.so
>
> 
> Pete Freitag ([EMAIL PROTECTED])
> CFDEV.COM
> ColdFusion Developer Resources
> http://www.cfdev.com/
>
> -Original Message-
> From: freddy [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 21, 2001 3:54 PM
> To: CF-Talk
> Subject: Re: JMAIL
>
> I am attempting to install the trial of cfx_jmail on a sun solaris box with
> cf 4.5.1 and after following the directions
> that came with the tag I have found that all that happens when I call the
> tag is cf crashes and restarts via the
> cfexecutive service. I have tried pointing the JVM path to /server/libjvm.so
> and the /client/libjvm.so niether worked.
>  Currently the class path is
> /opt/coldfusion/Java/classes:/opt/coldfusion/Java/classes/CFX_JMail.jar:/opt
> /coldfusion/Java/classes/cfx.jar.  and the
> CFX Jar Path /opt/coldfusion/Java/classes.
>
> If I attempt to load the jvm on startup cfserver will not run at all. We had
> to go into the registry file and manually
> change the java load option to get the server started agian. Any idea what I
> may be doing wrong?
>
> Thanks,
>  Frederic
>
> Gary Kraeger wrote:
>
> > Yes jmail will send 80,000 and more, it depends more on your server config
> > than anything.
> > We have discovered some ways in which we can improve jmail, which will
> make
> > it at least 10 times faster than it currently is and we are adding the
> > ability to do personalized emails, which has been the biggest request thus
> > far. We are adding these features very quickly, and they will be a free
> > upgrade when we are done with it. Hopefully this answers your question.
> >
> > Thanks
> >
> > Gary
> > Cfdev.com
> >
> > - Original Message -
> > From: "Darryl Lyons" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Wednesday, September 19, 2001 1:02 AM
> > Subject: JMAIL
> >
> > > Any ideas how many emails JMAIL can handle? Ie. Could it send 80,000? If
> > > not, most likely worth looking into a complete listserv/mailing list
> > system?
> > >
> > > ---
> > > Regards,
> > >
> > > Darryl Lyons
> > > Senior Systems Developer
> > > Fuzion: http://www.fuzion.com.au
> > >
> > > Email : [EMAIL PROTECTED]
> > > Phone : (07) 3620 1000
> > > Fax   : (07) 3620 1001
> > > Technical Support : 1300 888 480
> > >
> > > 'merging business + technology'
> > >
> >
>
> 
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: JMAIL

[freddy]

I am attempting to install the trial of cfx_jmail on a sun solaris box with cf 4.5.1 
and after following the directions
that came with the tag I have found that all that happens when I call the tag is cf 
crashes and restarts via the
cfexecutive service. I have tried pointing the JVM path to /server/libjvm.so and the 
/client/libjvm.so niether worked.
 Currently the class path is
/opt/coldfusion/Java/classes:/opt/coldfusion/Java/classes/CFX_JMail.jar:/opt/coldfusion/Java/classes/cfx.jar.
  and the
CFX Jar Path /opt/coldfusion/Java/classes.

If I attempt to load the jvm on startup cfserver will not run at all. We had to go 
into the registry file and manually
change the java load option to get the server started agian. Any idea what I may be 
doing wrong?

Thanks,
 Frederic

Gary Kraeger wrote:

> Yes jmail will send 80,000 and more, it depends more on your server config
> than anything.
> We have discovered some ways in which we can improve jmail, which will make
> it at least 10 times faster than it currently is and we are adding the
> ability to do personalized emails, which has been the biggest request thus
> far. We are adding these features very quickly, and they will be a free
> upgrade when we are done with it. Hopefully this answers your question.
>
> Thanks
>
> Gary
> Cfdev.com
>
> - Original Message -
> From: "Darryl Lyons" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, September 19, 2001 1:02 AM
> Subject: JMAIL
>
> > Any ideas how many emails JMAIL can handle? Ie. Could it send 80,000? If
> > not, most likely worth looking into a complete listserv/mailing list
> system?
> >
> > ---
> > Regards,
> >
> > Darryl Lyons
> > Senior Systems Developer
> > Fuzion: http://www.fuzion.com.au
> >
> > Email : [EMAIL PROTECTED]
> > Phone : (07) 3620 1000
> > Fax   : (07) 3620 1001
> > Technical Support : 1300 888 480
> >
> > 'merging business + technology'
> >
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Terrorism

[Freddy]

All I can say is "You idiot"

Freedom wrote:

> Truly think about this.  If even a few people on those planes could have
> been carrying a gun, none of this would have happened today.  Yes, something
> would happen sometime, but not this today!  The wrong thinking has directed
> the politically correct policies of this country for too long.  The innocent
> are suffering because of misguided logic.
>
> Justice, in this instance today, should be swift and sure!
>
> Freedom
>
> - Original Message -
> From: "Paris Lundis" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, September 11, 2001 3:23 PM
> Subject: RE: Terrorism
>
> > Yes in part Brian I agree.
> >
> > The question though the military/intelligence/feds need to answer in
> > such situations is what are the targets, what is in the proximity...
> > what is the likelihood of a destructive landing... can negotiations
> > occur... these are human lives Brian... humans.
> >
> > It seems clearly disturbing that no one tried to overcome the hijackers
> > on the plane. Clearly everyone knows the risk of dying in a crash.
> > Obviously, Americans aren't so aware that some people are on a mission
> > and the situation calls for whatever necessary. Really great that
> > someone managed in the Pittsburgh area crash to call 911 on their
> > cellphone.. unbelieveable isn't it... only because of that do we know
> > the aircraft was hijacked...
> >
> > Civilians need better trained and to step up in these times of needs...
> >
> > Big kudos and thanks to all the emergency workers who have perished in
> > rescuing other citiziens and the common people going beyond their call
> > today.
> >
> > Sure puts a lump in your stomach and a fist in your hand.
> >
> > -paris
> >
> > [finding the future in the past, passing the future in the present]
> > [connecting people, places and things]
> >
> >
> > -Original Message-
> > From: "Yager, Brian T Contractor/NCCIM" <[EMAIL PROTECTED]>
> > Date: Tue, 11 Sep 2001 13:41:50 -0500
> > Subject: RE: Terrorism
> >
> > > I would hope the US would shoot down a plane if it had terrorists on
> > > board.  No
> > > offense, but those people would be dead anyways.  I'm not going to
> > > voice my
> > > political views, but I do believe that to sacrifice 100 or so lives
> > > to save many
> > > thousands is a price I personally am willing to make.
> > >
> > >
> > >
> > > -Original Message-
> > > From: Paris Lundis [mailto:[EMAIL PROTECTED]]
> > > Sent: Tuesday, September 11, 2001 1:18 PM
> > > To: CF-Talk
> > > Subject: RE: Terrorism
> > >
> > >
> > > If the Pittsburgh area plane was intended for the white house they
> > > picked a good place to put it down...
> > >
> > > FEMA is one site and was there quick... there is a very big hole in
> > > the
> > > ground and people said the plane did a 45 degree dive... so could
> > > have
> > > happened... unlikely though..
> > >
> > > doubt the government wants to claim if so that they killed 300 of
> > > their
> > > citizens.
> > >
> > > I would love to know how many terrorists there were on each plane.
> > > People need to understand that in an airplane you are screwed if
> > > there
> > > is a problem. Your odds of dying in a crash as a result are far
> > > greater
> > > than dying due to violence.
> > >
> > > we are accountable as well for these incidents. Certainly someone or
> > > a
> > > larger group of people were not actively doing their jobs.
> > >
> > > [finding the future in the past, passing the future in the present]
> > > [connecting people, places and things]
> > >
> > >
> > > -Original Message-
> > > From: "Kevin Langevin" <[EMAIL PROTECTED]>
> > > Date: Tue, 11 Sep 2001 14:07:20 -0400
> > > Subject: RE: Terrorism
> > >
> > > > Yup...disgusting.  The US has some seriously negative sentiment
> > > > towards it
> > > > abroad.
> > > >
> > > > I was at a client's office earlier, two employees of which are
> > > > military.
> > > > One of them was on the phone with a woman whose husband works at
> > > the
> > > > Pentagon (also military) who said that supposedly the plane downed
> > > in
> > > > Pittsburgh was shot down by US forces.  THAT'S scary...could be
> > > just
> > > > rumor,
> > > > but based on the source, I think not.  There's been nothing said on
> > > > the news
> > > > yet, but I did hear a few minutes ago Peter Jennings say that it's
> > > > suspected
> > > > that that plane was targetting the White House.
> > > >
> > > > This truly is a modern day Pearl Harbor.  God rest the souls of the
> > > > victims
> > > > of the heinous act.
> > > >
> > > > Kevin Langevin
> > > > Web Guy in Charge
> > > > UsWebGuys
> > > > 954-327-5780
> > > > [EMAIL PROTECTED]
> > > >
> > > > > -Original Message-
> > > > > From: John Paitel [mailto:[EMAIL PROTECTED]]
> > > > > Sent: Tuesday, September 11, 2001 1:56 PM
> > > > > To: CF-Talk
> > > > > Subject: RE: Terrorism
> > > > >
> > > > >
> > > > > Anyone seen the reports that the Pa

Re: Terrorism

[Freddy]

Hm do religions that worship "a different god"  not count? Take a
count most wars have religious as well as polical motivations. Did I ever
say "be an athiest" all I said was that more atrocities are committed in the
name of "God".

Though wars do kill people and the results can be atrocious that does not make
them all atrocities. However if you look behind the scenes of some of the wars
you mention below you will see that organized religion had a hand in it.

I do not expect to change your mind I am just stating my opinion. You do not
have to imply my religion, or in your opinion, my lack of religion is coloring
my opinion. I am just an afficiado of history and can name a few atrocities that
were religious in their roots. The Holocost, the spanish inquisition, the
crusades, the persecution of christians by the Roman Empire to name those by
reletively "modern" religion. I am sure the atrocities commited by believers of
polytheism or  tribal religions were done in the name of their "gods" as well.

I did not mean to attack your "God" I am just stating that people will do almost
anything they believe is "right" in the eyes of their "God" and they rarely feel
any remorse or moral responsibility for the acts they have committed against the
innocents.

Tell me where are the morals of someone who has blown up an airplane full of
people while fighting their Jihad? Or the morals of someone who has killed an
abortion clinic doctor because they "kill babies".

Do not attempt to attack my spirtituality. It runs very deep. To my knowledge I
have never caused physical harm to any innocents nor backed down where it was my
duty to protect someone. Life is precious and worth protecting no matter what
"God" they believe in.

Thanks,
 Frederic

Brian Fox wrote:

> > If you look
> > throughout history you
> > will see that more atrocities have been perpetrated in the
> > name of God than
> > for any other reason.
>
> Who coined this statement?  It's been used, almost verbatim, so many times
> that it has to have some source.
>
> I'm really baffled by it.  Did someone count up the body counts of Vietnam,
> Stalingrad, Pearl Harbor, the US Civil War, the French Revolution, Alexander
> the Great's casualties, etc etc etc etc and find a common religious theme?
> What about atrocities that predated monotheism?  polytheism?  tribal
> religions?
>
> It seems to be a self defeating argument.  If religion is an opiate, then
> atheism is the truth.  But then how the heck do you introduce morals into
> the picture?  I mean, how do you define 'atrocity'?  Atheism after all boils
> down to 'shit happens.'
>
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Terrorism

[Freddy]

I beleive he means this looks to be the work of religious zealots. Hence the
reference to God being at the root of this. If you look throughout history you
will see that more atrocities have been perpetrated in the name of God than
for any other reason.

 Frederic

[EMAIL PROTECTED] wrote:

> i feel, as we all do, about todays happenings and wanted to keep quite but
> have to ask...,
>
> what is that supposed to mean?
>
> "Neil Clark" <[EMAIL PROTECTED]> on 09/11/2001 01:24:18 PM
>
> Please respond to [EMAIL PROTECTED]
>
> To:   CF-Talk <[EMAIL PROTECTED]>
> cc:
>
> Subject:  RE: Terrorism
>
>  I think "God" was one of the main reasons why things like this happen
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: ColdFusion license agreement

[freddy]

Was this on a win2000 apache install or IIS?
I had no trouble with IIS just apache.
Thanks,
Frederic

Andrew Scott wrote:

> Works here fine, never did anything to it but a normal install first
> time. I assume you mean through CF Admin?
>
> Regards,
> Andrew Scott
>
> -Original Message-
> From: Freddy [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 6 September 2001 9:20 AM
> To: CF-Talk
> Subject: Re: ColdFusion license agreement
>
> what did you do to get the browse function to work for setting up
> datasources et al? I have installed numerous times on multiple boxes
> (all
> with win 2000 pro) and can not get the browse applets functioning
> even
> with an service contract and numerous calls to our allaire support guy.
>
> Thanks,
>  GFrederic
>
> "DeVoil, Nick" wrote:
>
> > > Anything I should be aware of when installing CF Server
> > 5 on NT with Apache??
> >
> > No, I have that combination right here & it's fine.
> >
> > Nick
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: ColdFusion license agreement

[freddy]

Dave,
 I did that long before I attempted to contact my support rep on the issue. That 
didn't help at all they were running
already.

Dave Hannum wrote:

> Check to see if RDS is running  If not, start it then try again.
>
> Dave
>
> - Original Message -
> From: "Freddy" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, September 05, 2001 7:20 PM
> Subject: Re: ColdFusion license agreement
>
> > what did you do to get the browse function to work for setting up
> > datasources et al? I have installed numerous times on multiple boxes (all
> > with win 2000 pro) and can not get the browse applets functioning even
> > with an service contract and numerous calls to our allaire support guy.
> >
> > Thanks,
> >  GFrederic
> >
> > "DeVoil, Nick" wrote:
> >
> > > > Anything I should be aware of when installing CF Server
> > > 5 on NT with Apache??
> > >
> > > No, I have that combination right here & it's fine.
> > >
> > > Nick
> > >
> > > **
> > > Information in this email is confidential and may be privileged.
> > > It is intended for the addressee only. If you have received it in error,
> > > please notify the sender immediately and delete it from your system.
> > > You should not otherwise copy it, retransmit it or use or disclose its
> > > contents to anyone.
> > > Thank you for your co-operation.
> > > **
> > >
> > >
> >
>
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: ColdFusion license agreement

[Freddy]

what did you do to get the browse function to work for setting up
datasources et al? I have installed numerous times on multiple boxes (all
with win 2000 pro) and can not get the browse applets functioning even
with an service contract and numerous calls to our allaire support guy.

Thanks,
 GFrederic

"DeVoil, Nick" wrote:

> > Anything I should be aware of when installing CF Server
> 5 on NT with Apache??
>
> No, I have that combination right here & it's fine.
>
> Nick
>
> **
> Information in this email is confidential and may be privileged.
> It is intended for the addressee only. If you have received it in error,
> please notify the sender immediately and delete it from your system.
> You should not otherwise copy it, retransmit it or use or disclose its
> contents to anyone.
> Thank you for your co-operation.
> **
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

i/o error in cf admin browse function (was Macromedia strong arms developers into 5.0 upgrade)

[freddy]

Dave,
 Your fix for the cf admin and rds did not work for me. I no longer get the rds error 
404 I now get connection cannot be
established. I still get the same error in the administrator.
Thanks anyway,
 Frederic


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Studio 5.0 release date

[freddy]

Or maybe the upgrade should include ALL the functionality of the previous version. I 
DO NOT code 3 meg files I just
attempted to open them...

I did not expect that pointing out a deficiency would have you attacking me. Why not 
lighten up a bit?

If I were writing an app and I was making it better than my previous app I would not 
remove functionality for no reason.
ANd if someone pointed out to me that my new app was inferior in some way to the one I 
was attempting to improve I would
go back and re-think what I had done to lose that functionality.

That is GOOD coding practice in anyone's book.
 Thanks,
 Frederic

Thomas Chiverton wrote:

> > del out of cf 5 whenever I try to open large text files 3meg
> > +. Reported as a bug in the beta forum but no one ever responded.
>
> Maybe you should change your coding style :-)
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Studio 5.0 release date

[freddy]

I was opening the server.log
 However no matter the reason (for having the 3meg file) it opens fine in 4.5.x so me 
thinks it is a bug.
CF studio is my text editor of choice... so when I want to open a text file I use it.

Thanks
 Frederic

Neil Clark wrote:

> Maybe you should question why you have 3Meg text file?!
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Apache 1.3.20 and EAPI requirements? (was: MM strongarms)

[Freddy]

>If you're talking about security issues - worm vulnerabilities and buffer
>overflow exploits, for example - the fault generally lies with the person
>who installed IIS, and didn't follow IIS installation best practices (which
>are strikingly similar to those for installing any accessible network
>service - remove and disable features you don't use). It's the system
>administrator's job to install network services correctly, not Microsoft's.
>While they could certainly make the job easier, that's what system
>administrators are supposed to do.

Be that as it may, I will still use apache on my nt box until I can get my linux box 
up and running and move the
production server off  Windows for good.

 By the way my IIS setup was never hacked. I think I did a pretty good job of  keeping 
security locked down.
However I like the idea of Apache having a default install that starts off secure as 
opposed to the IIS "wide open"
method. Besides I will never be upgrading to XP as long as the licencing remains the 
way it is so I may as well
start moving to a reasonable alternative now.
Thanks,
 Frederic



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Macromedia strong arms developers into 5.0 upgrade

[Freddy]

Just as a point to note. I have not been able to get cf administrator in version 5 to 
work  correctly on my
win2k/apache install. The applet for browsing the server for a datasource (or any 
other function that uses that
applet) does not work. I continually get i/o errors. I have tried it on two seperate 
machines one that was a
totally clean install of the os and apache and cf were the only apps besides the 
browsers.

 I have spoken with my allaire/macromedia tech support contact  (we have the support 
contract) and we have yet to
get a resolution.

 Frederic

Justin Greene wrote:

> Hi All,
> I just had a very disturbing conversation with Macromedia.  We have been
> running CF/Apache on Windows for about 2.5 year now and developing on Cold
> Fusion since the 1.5 days (cgi only).  Version 1.3.20 of Apache for Win32
> (which has been available for over 6 months) is the first that Apache.org
> says is stable (not that there have been problems with the old versions).
> It has made available an enhanced API (EAPI) but modules need to be compiled
> with EAPI support.  Unfortunately the existing Cold Fusion module for Apache
> on Win32 uses the standard API.  I spoke with Macromedia in an effort to get
> an EAPI build of the module and was informed that they have no plans to
> compile an EAPI version of the module for Cold Fusion 4.x on Windows, but
> that it will be supported on Cold Fusion 5 and I should upgrade.
> Considering the amount of time Cold Fusion 5 has been out and the installed
> 4.x base (and the fact that I have a cluster of web servers and this upgrade
> is cost prohibitive and unnecessary), this strikes me as a blatant attempt
> to force upgrades.  I think that they have been going to Microsoft school.
>
> I now feel that I have no alternative but to investigate alternatives to
> Cold Fusion as I no longer have faith that Macromedia has any intention of
> providing the type of support it's developer community needs.  A far cry
> from the days that Allaire was compiling custom builds of 3.x for me while
> we tried to track down threading problems in the Cold Fusion Server service.
> This is annoying as we have a lot of code that will need to be re-written,
> but it will end up being cheaper in the long run if this is indicative of
> how Macromedia is going to respond.
>
> I hope that I am not the only one who is disturbed by this and that
> Macromedia will reconsider their position on this.
>
> Disappointed,
> Justin Greene
>
> p.s.  Allaire posted a resolution to the EXACT problem for Linux on August
> 7, 2000 in KB#  16303, however it requires the source for the module which I
> was told would not be made available for windows.
>
> --
> Justin Greene
> Co-Founder
> ClicVU, Inc. - Makers of the Spamex Disposable Email Address Service
> P: 212-242-0258
> http://www.clicvu.com
> http://www.spamex.com
>
> Spamex - Protect your real email address forever
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Studio 5.0 release date

[freddy]

I have continuosly had a problem with having to ctr + alt + del out of cf 5 whenever I 
try to open large text files 3meg
+. Reported as a bug in the beta forum but no one ever responded.
 Freddy

Mark Stewart wrote:

> I'll have to agree with the Access Violations - It's happened to me a
> few times, but not enough for me to determine a consistent scenario.
> Other than that, it works fine.
>
> I would be interested to hear about the scenario you're referencing and
> maybe I could try and duplicate it here.
>
> Mark
>
> -Original Message-
> From: Andrew Scott [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 28, 2001 8:53 AM
> To: CF-Talk
> Subject: RE: Studio 5.0 release date
>
> Well there are some major issues with it, I have beta tested Studio
> since 3.1 and I have not seen a buggier product. I use Studio for hours
> on end, which can be as much as 15 hours before I shut it down.
>
> Now when I did close it down the other night, I got about 20 Access
> Violations that Studio is known for throwing, while shutting down. I
> also had while I was ftp'ing through Studio's deployment it hang on me 5
> times in a row, causing me to alt+ctrl+del and kill the program. I was
> able to duplicate the problem and produce the scenario, but the problem
> is serious enough to know that it didn't work this way in 4.5. Otherwise
> I would say it is a good product, not much real cosmetic changes, except
> the unusual undocking of windows for no reason.
>
> Regards,
> Andrew Scott
>
> -Original Message-
> From: Will Swain [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 28 August 2001 8:30 PM
> To: CF-Talk
> Subject: RE: Studio 5.0 release date
>
> Agreed, I have found it fine, so far. Beta 1 was buggy, but beta 2 is a
> lot
> better.
>
> -Original Message-
> From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
> Sent: 24 August 2001 15:15
> To: CF-Talk
> Subject: RE: Studio 5.0 release date
>
> > Well there are some major problems with CF Studio 5 and Deployment,
> > if
> > it goes live with these bugs, don't use it, it crashes big time worse
> > than 4.5 ever did.
>
> Really ? I'm only using it on modorate sized projects, but it all seems
> fine.
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

cf 5 upgade

[freddy]

Has anyone experienced any major trouble with deployment of cf 4.5.1 applications on 
cf 5?
We are getting ready to upgrade and a few of the different dept heads would like to 
know how this may effect them
(currently it is only the dev box we are upgrading)


 / \__
Frederic Valone  ( @\___
Senior ColdFusion Developer /   O
American Kennel Club  /(_ /
   /_/ U



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: We've been assimilated...

[freddy]

Well it seems even if IE does end up "completely dominating the market" we will still 
be changing the code to comply with MS's changes to
the DOM in IE. 4 doesn't comply with 5, 5 doesn't comply with 5.5 and 6 probably 
doesn't comply with 5.5. My bet is unless we go to the
completely integrated desktop with exclusively MS products we will always be having to 
worry about "coding for xx browsers". Maybe if all
browsers would simply comply to the WC3 DOM we wouldn't have to worry about it but 
don't hold your breath.
Frederic

BEN MORRIS wrote:

> Actually the software has been released under the working title "Passport" with the 
>implant hardware to soon follow.
>
> Of course, speaking as a developer, I can't wait for complete MS domination of the 
>browser market. NN is a pain I could live without.
>
> >>> "Howie Hamlin" <[EMAIL PROTECTED]> 08/21/01 07:32PM >>>
> Don't go for the 1.0 release - wait for service pack 1.
>
> Howie
>
> - Original Message -
> From: "Kwang Suh" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, August 21, 2001 7:07 PM
> Subject: Re: We've been assimilated...
>
> > I'm still waiting for the Microsoft Neural Implant.
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Session vs. Cookies

[freddy]

Just for information purposes we use session variables exclusively to manage our 
personalization sessions and have not
yet gone up over 15% of memory usage. There are a minimum of actual variables used in 
a session (an array of link
values, name, breed and breed image, plus a few flag fields). We are on a sun es 5500 
quad with 3 gigs of memory so it
is a pretty hefty box but it is our only webserver.

We recieve anywhere from 300,000 to 500,000 page views and 2-3,000,000 "hits" a day  
and 30,000 to 40,000 "sessions.

This form of  personalization  is also scalable over a cluster as all the infomation 
that is stored in session variables
is extracted from the database on any hit to the website if there is not already a 
session created for the user.

If I were using many variables or variables that hold alot of data I would not 
recommend using this method. To tell the
truth I wanted to use client vars but the dba's did not want to allow that many hits 
to the database and also did not
want to create a table to hold them.

I do have to say this method works great as it is now.

Thanks,
 Frederic

Fuon See Tu wrote:

> hey guys, a friend of mine who is a pretty advanced CF programmer says that
> I should stay away from using sessions when developing sites that have a
> pretty good load of users, because sessions take up wa too much
> memory, and that I should resort to cookies or client cookies instead.  This
> makes me very sad, cuz i really like sessions a lot, and am about to develop
> a complex and lots-of-users site.  Sessions are really easy to work with for
> me!  Maybe he is wrong or is missing something?  Can one of yall make me
> happy again?  or gimme some suggestions?
>
> thanx
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: code red?

[freddy]

Thanks to everyone that responded I guess it's just an inconvienience and not any 
real trouble.
Thanks again,
 Fred

John Forrester wrote:

> Il giorno [DATA], [NOME], [INDIRIZZO] ha scritto:
>
> > I just looked again in my apache logs and I found an interesting entry. It
> > looks like all the other code red
> > entries I have but it is 1.78 megs of "code" can anyone tell me what this is?
> > should I be worried about being
> > infected? I was informed that only iis was susceptible to the worm but I have
> > been monitoring my server just the
> > same there are a ton of enties looking for default.ida? but only
> > one of these.
> > Please help
> > Frederic:
> >
> > "GET
> > /default.ida?X
> > XX
> > XX
> > XXX%u9090%u6858%ucbd3%u7801%u9090%u6858%ucbd3%u7801%u9090%u6858%ucbd3%u7801%u9
> > 090%u9090%u8190%u00c3%u0003%u8b00%u531b%u53ff%u0078%u%u00=a
> > HTTP/1.0" 404 279
> >
>
> We are getting the same on all of our Linux and Mac Servers. For now they
> just seem to be a bother - creates a bit of traffic. If you're lucky, they
> don't arrive that often.
>
> John Forrester
> Ancitel Spa
> Rome Italy
> [EMAIL PROTECTED]
> --
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

code red?

[Freddy]

I just looked again in my apache logs and I found an interesting entry. It looks like 
all the other code red
entries I have but it is 1.78 megs of "code" can anyone tell me what this is? should I 
be worried about being
infected? I was informed that only iis was susceptible to the worm but I have been 
monitoring my server just the
same there are a ton of enties looking for default.ida? but only one of 
these.
 Please help
 Frederic:

"GET
/default.ida?%u9090%u6858%ucbd3%u7801%u9090%u6858%ucbd3%u7801%u9090%u6858%ucbd3%u7801%u9090%u9090%u8190%u00c3%u0003%u8b00%u531b%u53ff%u0078%u%u00=a
HTTP/1.0" 404 279
   
   H T
M   .   ½—  sD  ¤ . 9 . H T M   .   .?  h<  ¢ . 4 0 . H T M   .   .?  ?;  ¤ . 1 . H T 
M   .   ȗ  d=  ¤ . 2 . H T
M   .   ӗ  xA  ¤ . 3 . H T M   .   ӗ  jA  ¤ . 4 . H T M   .   ޗ  ÏB  ¤ . 5 . H T M  
 .   é—  §<  ¤ . 6 . H T M
.   é—  3=  ¤ . 7 . H T M   .   ô—  +?  ¤ . 8 . H T M   .   ÿ—  ´>  ¤ . 9 . H T M   .  
 ÿ—  V=  ¢ . 5 0 . H T M   .

˜  ®<  ¤ . 1 . H T M   .   .˜  ›A  ¤ . 2 . H T M   .   .˜  ó>  ¤ . 3 . H T M   .˜  
+H  ¤ . 4 . H T M   .   +˜
çC  ¤ . 5 . H T M   .   +˜  MC  ¤ . 6 . H T M   .   6˜  .N  ¤ . 7 . H T M   .   A˜  ±V 
 ¤ . 8 . H T M   .   A˜  .A
¤ . 9 . H T M   .   L˜  €=  ¢ . 6 0 . H T M   .   W˜  ¨C  ¤ . 1 . H T M   .   W˜  É>  
¤ . 2 . H T M   .   b˜  ÉP  ¤
. 3 . H T M   .   b˜  õS  ¤ . 4 . H T M   .   m˜  .G  ¤ . 5 . H T M   .   x˜  )E  ¤ . 
6 . H T M   .   x˜  ßE  ¤ . 7
. H T M   .   ƒ˜  «D  ¤ . 8 . H T M   .   ƒ˜  @O  ¤ . 9 . H T M   .   Ž˜  µ\  ¢ . 7 0 
. H T M   .   Ž˜  äY  ¤ . 1 .
H T M   .   ™˜  ÏY  ¤ . 2 . H T M   .   ™˜  :V  ¤ . 3 . H T M   .   ¤˜  ¾H  ¤ . 4 . H 
T M   .   ¯˜  oE  ¤ . 5 . H T
M   .   ¯˜  .F  ¤ . 6 . H T M   .   º˜  ‹E  ¤ . 7 . H T M   .   º˜  ®E  ¤ . 8 . H T M  
 .   Ř  §E  ¤ . 9 . H T M
.   Ř  µE  ¢ . 8 0 . H T M   .   И  fB  ¤ . 1 . H T M   .   И  .=  ¤ . 2 . H T M   
.   ۘ  Ê<  ¤ . 3 . H T M
.   æ˜  ÀD  ¤ . 4 . H T M   .   æ˜  ¤D  ¤ . 5 . H T M   .   ñ˜  Ÿ>  ¤ . 6 . H T M   .  
 ñ˜  n@  ¤ . 7 . H T M   .
ü˜  ^D  ¤ . 8 . H T M   .   ü˜  GA  ¤ . 9 . H T M   .   .™  ?D  ¢ . 9 0 . H T M   .   
.™  ²D  ¤ . 1 . H T M   .
.™  .?    ° W W W R O O T \ D A T A B Y D E S I G N 1 \ C F D O C 
S \ C F M L _ L A N G U A G E
_ R E F E R E N C E \ 3 _ C O L D F U S I O N _ F U N C T I O N S \ L R 3 _ 0 9 2 . H 
T M   .   .™  bC  ¤ . 3 . H T
M   .   .™  ¯C  ¤ . 4 . H T M   .   .™  .B  ¤ . 5 . H T M   .   (™  CB  ¤ . 6 . H T M  
 .   3™  />  ¤ . 7 . H T M
.   3™  qA  ¤ . 8 . H T M   .   >™  ”A  ¤ . 9 . H T M   .   >™  ª=. 1 0 0 . H T M  
 .   I™  )<  ¤ . 1 . H T M
.   T™  .A  ¤ . 2 . H T M   .   T™  @?  ¤ . 3 . H T M   .   _™  ?D  ¤ . 4 . H T M   .  
 _™
D  ¤ . 5 . H T M   .   j™  Œ:  ¤ . 6 . H T M   .   j™  sK  ¤ . 7 . H T M   .   u™  9H  
¤ . 8 . H T M   .   u™  4K
¤ . 9 . H T M   .   €™  ‡=  ¢ . 1 0 . H T M   .   ‹™  K>  ¤ . 1 . H T M   .   ‹™  |>  
¤ . 2 . H T M   .   –™  r=  ¤
. 3 . H T M   .   –™  OF  ¤ . 4 . H T M   .   ¡™  øD  ¤ . 5 . H T M   .   ¡™  ×>  ¤ . 
6 . H T M   .   ¬™  .O  ¤ . 7
. H T M   .   ¬™  $Q  ¤ . 8 . H T M   .   ·™  _Y  ¤ . 9 . H T M   .   ™  ô<  ¢ . 2 0 
. H T M   .   ™  {B  ¤ . 1 .
H T M   .   ͙   C  ¤ . 2 . H T M   .   ͙  í<  ¤ . 3 . H T M   .   ؙ  />  ¤ . 4 . H 
T M   .   ؙ  ïA  ¤ . 5 . H T
M   .   㙢 . 4 0 . H T M   .   
;š  .D  ¤ . 1 . H T M   .
Fš  !@  ¤ . 2 . H T M   .   Qš   F  ¤ . 3 . H T M   .   Qš  ³B  ¤ . 4 . H T M   .   \š 
 žI  ¤ . 5 . H T M   .   \š
žB  ¤ . 6 . H T M   .   gš  õC  ¤ . 7 . H T M   .   rš  .I  ¤ . 8 . H T M   .   rš  ºB 
 ¤ . 9 . H T M   .   }š  ú@
¢ . 5 0 . H T M   .   }š  ?D  ¤ . 1 . H T M   .   ˆš  ðF  ¤ . 2 . H T M   .   ˆš  .@  
¤ . 3 . H T M   .   “š  ÌA  ¤
. 4 . H T M   .   “š  "E  ¤ . 5 . H T M   .   žš  \O  ¤ . 6 . H T M   .   ©š  °A  ¤ . 
7 . H T M   .   ©š  XI  ¤ . 8
. H T M   .   ´š  FJ  ¤ . 9 . H T M   .   ´š  å@  ¢ . 6 0 . H T M   .   ¿š  ¡J  ¤ . 1 
. H T M   .   ¿š  BK  ¤ . 2 .
H T M   .   ʚ  N?  ¤ . 3 . H T M   .   ՚  .C  ¤ . 4 . H T M   .   ՚  —B  ¤ . 5 . H 
T M   .   àš  $`  ¤ . 6 . H T
M   .   àš  DN  ¤ . 7 . H T M   .   ëš  ‘d  ¤ . 8 . H T M   .   ëš  ˜>  ¤ . 9 . H T M  
 .   öš  .?  ¢ . 7 0 . H T
M   .   öš  Ž=  ¤ . 1 . H T M   .   .›  gf  ¤ . 2 . H T M   .   .›  ™`  ¤ . 3 . H T M  
 .   .›  äR  ¤ . 4 . H T M
.   .›  ¢H  ¤ . 5 . H T M   .   .›  TC  ¤ . 6 . H T M   .   "›  üJ  ¤ . 7 . H T M   .  
 "›  Û=  ¤ . 8 . H T M   .
-›  ·?  ¤ . 9 . H T M   .   -›  .D  ¢ . 8 0 . H T M   .   8›  Ì?  ¤ . 1 . H T M   .   
8›  å>  ¤ . 2 . H T M   .
C›  ËC  ¤ . 3 . H T M   .



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusiona

Re: OT: apache error

[freddy]

I believe it means that the client has stopped waiting for the page to return and hit 
stop or moved to another page
prior to the page being returned.
Freddy

Mak Wing Lok wrote:

> did anyone know what caused this error?
>
> "Warning","08/14/01","11:11:04","(Apache) A network I/O error occurred while
> writing the reply back to the web server."
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Timeout while obtaining an Oracle statement lock

[freddy]

 Hello,
I am wondering if anyone out there running cf 4.5.1 sp2 and oracle 8i has run across 
this error in their application logs
Oracle Error Code = 0Timeout while obtaining an Oracle statement lock
We are getting a bunch of them on and off (some days 10 some days 60) They started 
showing up when we upgraded from oracle 7.4.3 to 8i.
Originally we were getting over 200 a day and it was bring cf server down alot. 
Through the work of the dba's and developers we brought the
numbers down but cannot seem to get rid of them completely any help I could get would 
be greatly appreciated.
Thanks,
 Frederic


 / \__
Frederic Valone  ( @\___
Senior ColdFusion Developer /   O
American Kennel Club  /(_ /
   /_/ U



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Oracle Stored Procedures

[freddy]

Here is what I use to access an oracle sp:



 

 

 




works fine for us.
Frederic

Alex Skinner wrote:

> I dont believe you can use output parameters with Oracle I may be wrong?
>
> Alex
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Clint
> Tredway
> Sent: 09 August 2001 13:32
> To: CF-Talk
> Subject: Oracle Stored Procedures
>
> Can anyone help me with the syntax of executing a stored procedure in
> Oracle?
> I have one input parameter(grpid) and one output parameter(tpcid) and they
> are both numeric.
>
> Here is what I am trying:
>  procedure="slct_topic_tpcid"
> datasource="#appDSN#"
> returncode="yes">
>
>  dbvarname="grpid"
> value="100"
> cfsqltype="CF_SQL_Numeric">
>
>  dbvarname="tpcid"
> cfvarname="newtpcid"
> cfsqltype="CF_SQL_NUMERIC">
>
> 
> 
>
> With the code about, I get a syntax error..
>
> Thanks!
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: help required -Interwoven !!

[freddy]

All I can say is it has taken me three years of persistant complaining to get 
interwoven's teamsite out of our shop. The
technical support they provided with a 16,000.00 yearly contract was horrendous. The 
product was never configured
correctly for our needs (even after an expensive onsite training and setup session) 
and to top it off they said they would
come in and help analyze our situation and configure our instalation for another 
80,000.00 dollars. I would suggest taking
a look at other products before using anything from interwoven. The products may be 
good (I'll never know. All we had was
trouble.) but the support isn't.
Thanks,
 Frederic

saravanan veerappan wrote:

> Hi,
> I am about to start a work with Interwoven product (converting cfcodes to 
>interwoven).I have no idea about interwoven.
> Any help/Tutorial would be helpful.
>
> Thx
> -Saro
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF 4.5 and pvcs

[freddy]

Thanks John.

John Cummings wrote:

> Frederic,
>
> The PVCS integration works pretty much the same way in Studio as VSS
> does/would except that you would choose a different source control
> provider when you first set up the project.
>
> J.
> [EMAIL PROTECTED]
>
> -Original Message-
> From: freddy [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 16, 2001 1:12 PM
> To: CF-Talk
> Subject: CF 4.5 and pvcs
>
> Along the same line as the VSS thread. What is the best way to integrate
> cf studio and merant pvcs? Is it a better idea to not integrate the two
> and just use cf studio as an editor and pcvs as a separate source
> control project? Thanks,  Frederic
>
>  / \__
> Frederic Valone  ( @\___
> Senior ColdFusion Developer /   O
> American Kennel Club  /(_ /
>/_/ U
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CF 4.5 and pvcs

[freddy]

Along the same line as the VSS thread. What is the best way to integrate cf studio and 
merant pvcs? Is it a better idea
to not integrate the two and just use cf studio as an editor and pcvs as a separate 
source control project?
Thanks,
 Frederic


 / \__
Frederic Valone  ( @\___
Senior ColdFusion Developer /   O
American Kennel Club  /(_ /
   /_/ U



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Important ColdFusion Security Patch Released Today

[freddy]

I have a fairly unique situation here. Our cf server has  very limited access rights. 
It cannot write any files at all
anywhere on our servers. In this case how would it be possible to exploit the security 
hole?  We have a subscription to
cf and are going to be upgrading asap but are currently in the process of a complete 
site personalization rollout that
will :
A: Put a much heavier load on the cf server than it already has. So adding a possible 
8% reduction in performance is not
an option.
B: Not allow me to upgrade untill it has been found to be working well enough in the 
current evironment.

I would like to wait till I can upgrade to 5.0 (about a month) before doing 
anything... does this sound safe?
Thanks,
 Frederic

Debbie Dickerson wrote:

> Michael,
>
> Your issue sounds more like a known bug with Studio. It was related to
> version Studio 4.5.0, and a hotfix was created for it. The fix is in the
> knowledge base at
> http://www.allaire.com/Handlers/index.cfm?ID=13852&Method=Full
>
> Debbie
> Macromedia
>
> -Original Message-
> From: Jackson Moore [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 12, 2001 8:40 AM
> To: CF-Talk
> Subject: Re: Important ColdFusion Security Patch Released Today
>
> Michael
>
> I don't know if it is related, but I (and a few other developers I
> know) have had the "0 byte file" issue hit us.  Here was the
> scenario:
>
> Edit a .cfm file in CF Studio.  Save file in CF Studio.  Refresh
> browser to verify updates.  Very, very seldom, we get an error from
> the CF Server that it can not read files that are 0 bytes in size.
> If I go back to studio, the file is still there.  However, if I close
> the file (won't get prompted to save since it was already saved), the
> file is lost and I have to restore from a backup.
>
> You can imagine that the first time this showed up, everyone thought
> I was crazy and told me I had just accidentally overwritten the file
> myself with an empty file.  These guys let me hear about it for
> weeks!
>
>  Then a few weeks later it happened again.  At first we blamed it on
> studio, then we blamed it on the network.  Then it happened to
> another developer.  You can imagine my relief (vindicated!) when I
> wasn't the only one who had been bit by this.
>
> Without more details from MM, I can't know for sure if this is the
> same issue addressed by their recent patch, but if it is, that means
> that CF Server was overwriting the file with a 0 byte file after I
> had successfully saved it from studio.
>
> Any thoughts?
>
> Jackson Moore
> [EMAIL PROTECTED]
>
> On Wed, 11 Jul 2001 15:35:45 -0400, Michael Dinowitz wrote:
> >Without going into details on my investigations yet, does anyone
> >know of
> >anyone being attacked by this hole? Has anyone found their documents
> >either
> >deleted or replaced with a 0 byte file? If so, please contact me. I
> >think I
> >know what the hole is and just need some extra 'leg work'.
> >
> >
> >>
> >> From: "Howie Hamlin" <[EMAIL PROTECTED]>
> >>
> >> >> 2) the nature of the security problem - obviously MM is going
> >>for
> >> >> security-thru-obscurity and is not going to describe the exact
> >>problem,
> >but
> >> >> some clue as to the possible effects, how to tell if the
> >>weakness has
> >been
> >> >> taken advantage of, etc would be helpful
> >> >>
> >> >
> >> >No idea...in a way it's better that they don't point out the
> >vulnerability.
> >>
> >> And in a way it is far worse - since while we are 'closing the
> >>door' on
> >> a bug, without more details, how can we tell if someone has taken
> >advantage
> >> of that open door on our system?
> >> --
> >> Never apply a Star Trek solution to a Babylon 5 problem.
> >> Larry W. Virden   >http://www.purl.org/NET/lvirden/>
> >> Even if explicitly stated to the contrary, nothing in this posting
> >>should
> >> be construed as representing my employer's opinions.
> >> -><-
> >>
> >>
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF Server parsing .js files...

[Freddy]

Remember if the js file is included lik this:

you have to wrap the include in a:
 
  

In the preceding instance the src directory is on the root of the site and the site 
has a coldfusion mapping of dd.

 Hope that helps.
 Frederic

Dave Hannum wrote:

> The only way I can think of would be to wrap it in a CFINCLUDE inside a .cfm
> page.
>
> Dave
>
> - Original Message -
> From: "Steve Reich" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, April 06, 2001 1:16 PM
> Subject: CF Server parsing .js files...
>
> > I have a single javascript file (*.js) that I want to include CF variables
> > with. I know how to set IIS up to allow CF Server to process a specific
> file
> > extension, but I don't neccessarily want it to process all .js files. My
> > question is
> >
> > Is there any command I can use to only process the single file or if  I
> want
> > CF Server to process one, it has to do them all?
> >
> > 
> >
> > ...js file contents.
> >
> > 
> >
> > Anything like that? I know I'm reaching here and am pretty positive I
> can't
> > do this, but I thought I'd ask anyway...
> >
> > Thanks,
> > Steve
> >
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: QUERY TROUBLE

[Freddy]

Thanks that did the trick.


"Howarth, Craig (IBK-NY)" wrote:

> Try this:
>
> I have added an additional column which test for the value of RMOTown and outputs a 
>0 if it matches otherwise a 1.  The same column is added to the order by.  This 
>should work in Access.
>
> 
> SELECT T.RMOTown, T.Cllustername
> FROM   RMOTownName T
> WHERE  T.RMOTown='#RMOTOWN#'
> 
>
> 
> SELECTiif(T.RMOTown='#RMOTOWN#',0,1) as FirstSort,
>   T.RMOTown as town, T.Chamberwebaddress as webad,
>   T.Cllustername, A.PrimaryName as pname,
>   A.Description as descipt,
>   a.PhysicalAddress +', '+a.City +', '+a.State +', '+a.ZipCode as 
>address,
>   a.Phone as phone, a.TollFreePhone as tfphone,
>   EMailAddress as email, a.WebSite as web
> FROM  RMOTownName T, Attractions A
> 
> WHERE Cllustername IN (SELECT Cllustername FROM RMOTownName
>  WHERE RMOTown='#RMOTOWN#')
>   AND A.RMOTown=T.RMOTown
> 
> WHERE T.RMOTown='#RMOTOWN#'
>   AND A.RMOTown=T.RMOTown
> 
> order by iif(T.RMOTown='#RMOTOWN#',0,1), T.rmotown, A.PrimaryName
> 
>
> > -Original Message-
> > From: Freddy [SMTP:[EMAIL PROTECTED]]
> > Sent: Monday, March 19, 2001 6:50 PM
> > To:   CF-Talk
> > Subject:  QUERY TROUBLE
> >
> > I have a query that returns a list of attractions in a certain town. If the town 
>is in  a "cluster" (a group of
> > related towns) it also needs to order  by the selected town first and then list 
>the rest of the towns
> > alphabetically.
> >  How would I get this output from the following queries?
> >
> > 
> > SELECT  T.RMOTown, T.Cllustername
> > FROM RMOTownName T
> > WHERE T.RMOTown='#RMOTOWN#'
> > 
> >
> > 
> > SELECT  T.RMOTown as town, T.Chamberwebaddress as webad,
> > T.Cllustername, A.PrimaryName as pname, A.Description as descipt
> > ,a.PhysicalAddress +', '+a.City +', '+a.State +', '+a.ZipCode as
> > address, a.Phone as phone, a.TollFreePhone as tfphone,EMailAddress
> > as
> > email, a.WebSite as web
> > FROM RMOTownName T, Attractions A
> > 
> > WHERE Cllustername IN (SELECT  Cllustername FROM RMOTownName
> > WHERE
> > RMOTown='#RMOTOWN#') AND A.RMOTown=T.RMOTown
> > 
> > WHERE T.RMOTown='#RMOTOWN# '  AND A.RMOTown=T.RMOTown
> > 
> > order by T.rmotown, A.PrimaryName
> >   
> >  Is there something I can do in the ORDER BY clause that will allow for this?
> > I know I can use an if statement in the output to  output the selected
> > town's info first but this will probibaly mess with the way my pagination through 
>the results works and is not the
> > most efficient
> > method.
> >  Thanks,
> >  Frederic.
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Query Trouble

[Freddy]

Bryan,
This works for returning two separate result sets (one for the selected town and 
another for the clustered towns if
available) The problem is that the client wants to be able to page through all the 
results of the clustered towns
query starting with the actual town selected no matter where  it falls alphabetically 
in the cluster. Then continue
though the rest of the towns in alphabetical order.
Unless I am missing something there is no way for me to actually page through a 
complete resultset here because if
I am using the  the first query the pagination will not continue after the last  entry 
for the seleted town and if
I page through the second resultset I will not be including the selected town 
information.
Thanks,
 Frederic

Bryan Love wrote:

> run two queries:
>
> The first one gets all info for the selected town and the second gets all
> info for towns of the same cluster (if it's not blank) but NOT for the
> selected town like so (set the select list to a variable so you don't have
> to mess with two queries later on):
>
> 
>
> 
> SELECT  #preserveSingleQuotes(selList)#
> FROM RMOTownName T
> WHERE T.RMOTown='#RMOTOWN#'
> 
>
> 
> 
> SELECT  #preserveSingleQuotes(selList)#
> FROM RMOTownName T, Attractions A
> WHERE A.RMOTown=T.RMOTown AND
>   T.RMOTown<>'#RMOTOWN#' AND
>   Cllustername IN (SELECT Cllustername FROM RMOTownName WHERE
> RMOTown='#RMOTOWN#')
> ORDER BY T.rmotown, A.PrimaryName
> 
> 
>
> Bryan Love ACP
> Internet Application Developer
> [EMAIL PROTECTED]
>
>
> -Original Message-
> From: Freddy [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 19, 2001 3:50 PM
> To: CF-Talk
> Subject: QUERY TROUBLE
>
> I have a query that returns a list of attractions in a certain town. If the
> town is in  a "cluster" (a group of
> related towns) it also needs to order  by the selected town first and then
> list the rest of the towns
> alphabetically.
>  How would I get this output from the following queries?
>
> 
> SELECT  T.RMOTown, T.Cllustername
> FROM RMOTownName T
> WHERE T.RMOTown='#RMOTOWN#'
> 
>
> 
> SELECT  T.RMOTown as town, T.Chamberwebaddress as webad,
> T.Cllustername, A.PrimaryName as pname, A.Description as descipt
> ,a.PhysicalAddress +', '+a.City +', '+a.State +', '+a.ZipCode as
> address, a.Phone as phone, a.TollFreePhone as tfphone,EMailAddress
> as
> email, a.WebSite as web
> FROM RMOTownName T, Attractions A
> 
> WHERE Cllustername IN (SELECT  Cllustername FROM RMOTownName
> WHERE
> RMOTown='#RMOTOWN#') AND A.RMOTown=T.RMOTown
> 
> WHERE T.RMOTown='#RMOTOWN# '  AND A.RMOTown=T.RMOTown
> 
> order by T.rmotown, A.PrimaryName
>   
>  Is there something I can do in the ORDER BY clause that will allow for
> this?
> I know I can use an if statement in the output to  output the selected
> town's info first but this will probibaly mess with the way my pagination
> through the results works and is not the
> most efficient
> method.
>  Thanks,
>  Frederic.
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: QUERY TROUBLE

[Freddy]

I am using Access as a database and it does not support the PATINDEX function. Any 
other thoughts?

Seva Petrov wrote:

> Frederic,
>
> You can try using PATINDEX to set a bit on the matching town and then order
> on the results of the PATINDEX, which will return the town with the bit set
> first:
>
> 
> SELECT PATINDEX('#RMOTOWN#', T.RMOTown) as pmatch,
> T.RMOTown as town, T.Chamberwebaddress as webad,
> T.Cllustername, A.PrimaryName as pname, A.Description as descipt
> ,a.PhysicalAddress +', '+a.City +', '+a.State +', '+a.ZipCode as
> address, a.Phone as phone, a.TollFreePhone as tfphone,EMailAddress
> as
> email, a.WebSite as web
> FROM RMOTownName T, Attractions A
> 
> WHERE Cllustername IN (SELECT  Cllustername FROM RMOTownName
> WHERE
> RMOTown='#RMOTOWN#') AND A.RMOTown=T.RMOTown
> 
> WHERE T.RMOTown='#RMOTOWN# '  AND A.RMOTown=T.RMOTown
> 
> order by pmatch DESC, by T.rmotown, A.PrimaryName
> 
>
> HTH,
> Seva Petrov
>
> > I have a query that returns a list of attractions in a certain
> > town. If the town is in  a "cluster" (a group of
> > related towns) it also needs to order  by the selected town first
> > and then list the rest of the towns
> > alphabetically.
> >  How would I get this output from the following queries?
> >
> > 
> > SELECT  T.RMOTown, T.Cllustername
> > FROM RMOTownName T
> > WHERE T.RMOTown='#RMOTOWN#'
> > 
> >
> > 
> > SELECT  T.RMOTown as town, T.Chamberwebaddress as webad,
> > T.Cllustername, A.PrimaryName as pname, A.Description as descipt
> > ,a.PhysicalAddress +', '+a.City +', '+a.State +', '+a.ZipCode as
> > address, a.Phone as phone, a.TollFreePhone as tfphone,EMailAddress
> > as
> > email, a.WebSite as web
> > FROM RMOTownName T, Attractions A
> > 
> > WHERE Cllustername IN (SELECT  Cllustername FROM RMOTownName
> > WHERE
> > RMOTown='#RMOTOWN#') AND A.RMOTown=T.RMOTown
> > 
> > WHERE T.RMOTown='#RMOTOWN# '  AND A.RMOTown=T.RMOTown
> > 
> > order by T.rmotown, A.PrimaryName
> >   
> >  Is there something I can do in the ORDER BY clause that will
> > allow for this?
> > I know I can use an if statement in the output to  output the selected
> > town's info first but this will probibaly mess with the way my
> > pagination through the results works and is not the
> > most efficient
> > method.
> >  Thanks,
> >  Frederic.
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

QUERY TROUBLE

[Freddy]

I have a query that returns a list of attractions in a certain town. If the town is in 
 a "cluster" (a group of
related towns) it also needs to order  by the selected town first and then list the 
rest of the towns
alphabetically.
 How would I get this output from the following queries?


SELECT  T.RMOTown, T.Cllustername
FROM RMOTownName T
WHERE T.RMOTown='#RMOTOWN#'



SELECT  T.RMOTown as town, T.Chamberwebaddress as webad,
T.Cllustername, A.PrimaryName as pname, A.Description as descipt
,a.PhysicalAddress +', '+a.City +', '+a.State +', '+a.ZipCode as
address, a.Phone as phone, a.TollFreePhone as tfphone,EMailAddress
as
email, a.WebSite as web
FROM RMOTownName T, Attractions A

WHERE Cllustername IN (SELECT  Cllustername FROM RMOTownName
WHERE
RMOTown='#RMOTOWN#') AND A.RMOTown=T.RMOTown

WHERE T.RMOTown='#RMOTOWN# '  AND A.RMOTown=T.RMOTown

order by T.rmotown, A.PrimaryName
  
 Is there something I can do in the ORDER BY clause that will allow for this?
I know I can use an if statement in the output to  output the selected
town's info first but this will probibaly mess with the way my pagination through the 
results works and is not the
most efficient
method.
 Thanks,
 Frederic.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: form to session

[Freddy]

How to stop worrying and learn to love the session. :-)

Don't forget to wrap a  around that code.

Bryan Love wrote:

> Why you would want to convert innocent, safe form fields into tricky,
> unstable session variables is beyond me, but here's the code...
>
> 
> 
> 
>
>
> Bryan Love ACP
> Internet Application Developer
> [EMAIL PROTECTED]
>
>
> -Original Message-
> From: Jay Wigginton [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 16, 2001 1:35 PM
> To: CF-Talk
> Subject: form to session
>
> Is there a simple way to take the values submitted from a form and setting
> session variables with the same name... example:
>
> form submits variables Form.FirstName and Form.LastName... I need to
> set... Session.FirstName = Form.FirstName and Session.LastName =
> Form.LastName...
>
> I know I can use... 
>
> But, I want to do this  looping over the fieldnames... something
> like...
>
> 
> 
> 
> 
> 
>
> The above produces an error... :(
>
> thanks in advance
> Jay
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL Server data type question...

[Freddy]

Couldn't you use Permissions.PermissionID IN " '4','5' "

Tim Fields wrote:

> I have a client that has an existing SQL Server database which includes a
> table used as part of a permissions framework. The problem is that whoever
> created the table was clever enough to create a column for permissions id's
> as a varchar rather than creating a join table. So I may a situation where
> Permissions.PermissionID =
>
> They have been using a statement in SQL Server7 that is something like:
>
> Select p.FName, p.LName
> >From Permissions p
> Where p.PermissionID <> 1
>
> That worked in 7, but not in 2000 which correctly sees it as a data type
> error ( cannot convert...)
>
> They won't let me rebuild that part of the database properly right now for
> reasons that are debatable, but anyway I have to work with this structure.
> Their internal person came up with:
>
> Where p.PermissionID NOT LIKE '%1%'
>
> but I pointed out that it had some serious holes in it such as it would fail
> 11 or 21. I've fixed it temporarily by using a series of AND NOT LIKE
> statements with wildcards to fail '1', '1,' or ',1' but pass everything
> else. It's a pretty damned ugly statement though if I do say so myself.
>
> Does anyone know of a more elegant solution? I can't quite get my arms
> around sp_executesql to see if that could help.
>
> Any help would be appreciated.
>
> Tim
>
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 02, 2001 11:50 AM
> To: CF-Talk
> Subject: RE: Stored Procedures and HTML form List
>
> > > To the best of my knowledge, you can't do this. What you can
> > > do to get the same effect, though, is to execute a string
> > > containing your SQL statement ...
> > > ...
> > > Of course, this isn't an optimal solution.
> >
> > Thanks!  That's almost exactly what I was looking for. I'll
> > try it today. Why would it not be an optimal solution? Is it
> > slower or can that function only be used in certain situations?
>
> It's slower, because it can't take advantage of existing query plans as
> well.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: configuring sql server native drivers

[Freddy]

Hmmm seems strange there is no native driver available for sql server... anyway I am 
still having alot of trouble
configuring the ole driver. I went ahead and registered all the components as I read 
on the allaire knowledge base
and then configured the datasource as specified and I still cannot get it to verify 
correctly. Any ideas?

Deb Dickerson wrote:

> What are you specifically referring to? There aren't any SQL Server native
> drivers with ColdFusion, only ODBC drivers.
>
> Debbie
>
> - Original Message -
> From: "Freddy" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, February 23, 2001 7:27 PM
> Subject: configuring sql server native drivers
>
> > Could someone please point me in the right direction to get information on
> configuring sql server native drivers? I
> > have searched the allaire knowledge base and found nothing and cannot find
> anything in the documentation the goes
> > through the whole process.
> > Thanks
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

configuring sql server native drivers

[Freddy]

Could someone please point me in the right direction to get information on configuring 
sql server native drivers? I
have searched the allaire knowledge base and found nothing and cannot find anything in 
the documentation the goes
through the whole process.
Thanks

Andrew Scott wrote:

> Yes I have
>
> This is the reason why I suggested to the beta team to fix this, but they
> wouldn't listen:-)
>
> Anyway the thing that is missing is that when you setup a deployment, you
> need to go into the properties of the project and enter a deployment path
> before it will work
>
> I suggest sending another email to [EMAIL PROTECTED] to make this more
> intuitive for their next release or patch:-)
>
> -Original Message-
> From: j p [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, 24 February 2001 6:58 AM
> To: CF-Talk
> Subject: Studio Project Deployment - Help
>
> Has anyone EVER been successful in getting CF Studio Projects to 'deploy'
> either directly or via scripts...
>
> If so please help me out..I keep getting "No Deployment Path specified"  for
> every sub-folder, even though I specify create new folders.
>
> jp
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

OT-Access to server on NT

[Freddy]

I am having a problem I hope someone here can help with. I have a client that I work 
for remotely. Currently for
some reason I cannot access their website or connect via ftp, telnet, or as an rds 
from any of my NT based
machines.
1: NT 4 SP 6
2: Win 2000 professional

 I have no trouble using my win 98 machine on the same network (DSL connection) to 
connect to the site in any
fashion.
Has anyone got any ideas? I hate trying to find anything on the MS site and knowledge 
base so I thought Id check
here first.
 Thanks



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: PL/SQL

[Freddy]

Sorry can't help you there.

Jeff Britts wrote:

> Basically, we're working on a tool to generate the pl/sql script on the fly
> so we
> cant use a stored proc.  Any ideas?
>
> -Original Message-
> From: C Frederic Valone [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 08, 2000 9:54 AM
> To: CF-Talk
> Subject: Re: PL/SQL
>
> We use cf and pl/sql stored procs extensively. What exactly are you trying
> to do?
>
> Jeff Britts wrote:
>
> > Anyone have any luck running PL/SQL through ColdFusion?  The simple stuff
> > seems to work ok, but if you throw it something complex it chokes.
> >
> >
> > Jeff Britts
> > ColdFusion Engineer
> > e-Dialog
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists