SQL Question

[Srimanta B]

Hello,

Can someone please help me.
I wish to delete part of a text in "student" field keeping part of the text in the same field intact.

Database: Access.
Table name is: TopStudents
The field names are: studentid, studentdetails, percentage, grade.
The contents of the rows in the "studentdetails" field are similar to this:

Student Name1 - Year 1950
Student Name2 - Year 1953
Student Name3 - Year 1953
Student Name4 - Year 1953
Student Name5 - Year 1954

I have about 500 rows of data in the table.
What I wish to do is to keep the student names in the rows intact and delete
everything on the righthand side from the -.

Any help would be much appreciated.

Regards
SB
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: dancing 'round the mullberry bush

[Srimanta]

Hi,
CF Schedule is most probably the most unreliable tag in CF.
Like you, we have never been able to make much use of it on CF5.

Srimanta
- Original Message -
From: Owens, Howard <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Wednesday, January 22, 2003 3:04 PM
Subject: dancing 'round the mullberry bush


> I first tried long ago to get CFSchedule to actually, like, you know, run
a
> scheduled task.
>
> I've tried many times over the years on all kinds of different machines,
> different versions, different tasks to get the damn thing to work.
>
> Ain't never worked for me.
>
> Just got a new CFMX server ... first code I put on it was a simple little
> scheduled task.  It's executed faithfully twice now.
>
> So I'm dancing a little jig.
>
> Just wanted to share.
>
> H.\
>
>
> ~~
> Howard Owens
> Internet Operations Coordinator
> InsideVC.com/Ventura County Star
> [EMAIL PROTECTED]
> AIM: GoCatGo1956
> ~~
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Help with Search Engine

[Srimanta]

Hello Forum.

I have been askedby an Internet Retailer (Computer products)  to develop a
template that would accomplish the following:

1. Search several URL's /Websites (those of competing internet retrailers)
(Upto 20) and grab info on pricing, models and stock.on consumer items eg
cameras, laptops etc.on a daily basis.

2. Update my clients database so that its prices are the lowest. (provided
my clients sp is not less than pp)

Well.. Part 2 is easy.

However I am not sure how to implement Part 1. I have not done Search Engine
stuff before  except for queries that
search databases.
Can someone please guide me in the right direction.
Any help would be much appreciated...
Kind Regards,

Srimanta



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Cannot convert to number.

[Srimanta]

Yes,
I have had similar errors. Its usually when your query does not return a
numerical data  where a number is expected.
Check your database--specially the rows in numerical  columns. Replacing
null/empty numerical cells with 0 (zero) might solve your problem
HTH

Srimanta


htttp://www.digitalshop.co.nz

- Original Message -
From: Jillian Carroll <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Sunday, January 12, 2003 10:15 PM
Subject: Cannot convert to number.


> I am having a really weird problem... I do some calculations in CF, they
> work on my development machine (Windows XP Home/Apache) but when I
> upload them to my host (Windows 2000/IIS) they don't work.  I get this
> error... anybody able to help me on this one?
>
> *** *** ***
>
> Error Diagnostic Information
>
> An error occurred while evaluating the expression:
> EndRow = StartRow + OnEachPage - 1
>
> Error near line 39, column 8.
>
> Cannot convert to number.
> Please, check the ColdFusion manual for the allowed conversions between
> data types
> The error occurred while processing an element with a general identifier
> of (CFSET), occupying document position (39:2) to (39:43).
> Date/Time: 01/12/03 23:33:29
> Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
> Remote Address: 207.195.97.118
>
> *** *** ***
>
> My code is below:
>
> 
>
>  password="cds337">
> SELECT jubileeid, globalnumber, nanumber, rotundanumber, binlocation,
> name
> FROM tools
> ORDER BY name ASC
> 
>
> 
>
> 
>
>  
>  
>
>  
>  
>  
>
>  
>  
>
>  
>  
>   
>   
>
>  
>  
>   
>   
>
>   
>
>   
>   
>  
>
>  
>  
>   
>
>  
>   
>  
>   
>  
>
>  
>  
>  
>
> 
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Redirection based on IP address.

[Srimanta]

Yup. Thanks.
How do I  reliably determine the country from the IP address realtime.
I think that the tricky part.
Is there a CF tag that will do that for me?

Srimanta
- Original Message -
From: Scott Brady <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Tuesday, December 10, 2002 4:01 PM
Subject: Re: Redirection based on IP address.


> Assuming you can reliably determine which IP addresses go with which
country, it should be fairly easy using CGI.remote_addr (which gives you
their IP address).
>
> Of course, what if an Australian user is on vacation in the US and wants
to see the Australian page?
>
> I'd suggest still giving the users the option to go to other country pages
(so the aforementioned Aussie will initially get the US page but can switch
go the Australian pages [and keep the preference with a cookie/session
variable]).
>
> Scott
> 
> Scott Brady
> http://www.scottbrady.net/
>
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Redirection based on IP address.

[Srimanta]

Hello Forum,

I have been asked to create a template which will redirect viewers to their
respective country page depending on their IP address/location. The client
has a website where there are seperate pages for countries eg Australia, UK,
New Zealand US.
What the client wants is visitors from each of these countries should be
automatically redirected to country specific home page when they visit the
website.
What would be the best approach to achieve this?
Any help would be much appreciated.

Regards,

Srimanta

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

OT: Australian & NZ Stock Quotes

[Srimanta]

Hi Forum,

Can anyone recommend a custom tag / Java Script code to display Australian
and/or New Zealand stock quotes?

Any help would be much appreciated.


Cheers

Srimanta

http://www.digitalshop.co.nz

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Re: Preventing URL Display in Status bar

[Srimanta]

Thanks Steve.

Srimanta

http://www.digitalshop.co.nz
- Original Message -
From: "Steve Reich" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, November 17, 2002 8:38 PM
Subject: RE: Preventing URL Display in Status bar


> > Is there a way to stop the status bar from displaying the URL / path
when
> > the pointer is over a hypertext link on a website.
>
> Use JavaScript
>
> Home
>
>
> . this will put the text 'Click for home page...' in the status bar
instead
> of the URL.
>
>
> HTH,
> Steve
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

OT: Preventing URL Display in Status bar

[Srimanta]

Hello Forum,

Is there a way to stop the status bar from displaying the URL / path when
the pointer is over a hypertext link on a website.

I remember reading an article somewhere (probably in this forum) some time
back but now cant find it.
Any Help would be much appreciated.


Regards,

Srimanta

http://www.digitalshop.co.nz


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Re: Email authentication

[Srimanta]

Thanks Matthew,
Very helpful info.

Kind Regards,
Srimanta
- Original Message -
From: "Matthew Walker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 13, 2002 4:24 PM
Subject: RE: Email authentication


> Hi Srimanta,
>
> We use HexValidEmail form hexillion.com for this. It's pretty easy to
> use although the docs are a bit confusing. Ask if you need help.
>
> Matthew Walker
> http://www.matthewwalker.net.nz/
>
>
> > -Original Message-
> > From: Srimanta [mailto:mail@;designshop.co.nz]
> > Sent: Friday, 15 November 2002 2:32 a.m.
> > To: CF-Talk
> > Subject: OT: Email authentication
> >
> >
> > Hello Forum.
> >
> > Is there a tool or utility or script capeable of checking
> > email addresses
> > real time?
> >  I am trying to create  a CF application which will allow
> > visitors to browse
> > certain section(s)
> > in the website depending on whether the email address
> > provided by the user
> > is valid and functional.
> > Any help would be much appreciated.
> > Thanks
> > Srimanta
> >
> > http://www.digitalshop.co.nz
> >
> >
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

OT: Email authentication

[Srimanta]

Hello Forum.

Is there a tool or utility or script capeable of checking email addresses
real time?
 I am trying to create  a CF application which will allow visitors to browse
certain section(s)
in the website depending on whether the email address provided by the user
is valid and functional.
Any help would be much appreciated.
Thanks
Srimanta

http://www.digitalshop.co.nz

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Re: Query size

[Srimanta]

Would be happy to get a CF solution to the problem.
Dont really want to work at db end for the solution.
What about other platforms-- ASP--PHP?
(Iam probably going off the track.)

Thanks
Srimanta
- Original Message -
From: "Srimanta" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, November 08, 2002 6:21 PM
Subject: Re: Query size


> Thanks,
> I am using MS SQL.
>
> Srimanta
> - Original Message -
> From: "Jeff" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, November 07, 2002 9:13 PM
> Subject: RE: Query size
>
>
> > What database are you using?  Does this have to be a ColdFusion
> > solution? Or can you work it on the Database end?
> >
> > Jeff
> >
> > -Original Message-
> > From: Srimanta [mailto:mail@;designshop.co.nz]
> > Sent: Friday, November 08, 2002 6:34 PM
> > To: CF-Talk
> > Subject: Re: Query size
> >
> >
> > Thanks,
> > The best solution would have been to get the exact query size.
> > Unfortunately average values will not do the job in this case. Dont
> > think writing it to a file and then using CF directory to get the file
> > size will work either as more than one user can run multiple queries
> > simultaneously. Locking is an option. Will have to experiment and see
> > how it works. Would be happy to see Macromedia provide a function to get
> > query size in the future versions of CF. I think I am in trouble as I
> > promsed my client that it can be easily done...
> >
> > Kind Regards,
> > Srimanta
> >
> > - Original Message -
> > From: "Mosh Teitelbaum" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, November 07, 2002 3:26 PM
> > Subject: RE: Query size
> >
> >
> > > Well, it's not in KBs or MBs, but you can use queryName.RecordCount to
> >
> > > determine the number of results in the record.  Multiply that by some
> > > multiple and you have an "average" (perhaps?) size.  Sort of.  8^)
> > >
> > > --
> > > Mosh Teitelbaum
> > > evoch, LLC
> > > Tel: (301) 625-9191
> > > Fax: (301) 933-3651
> > > Email: [EMAIL PROTECTED]
> > > WWW: http://www.evoch.com/
> > >
> > >
> > > > -Original Message-
> > > > From: Srimanta [mailto:mail@;designshop.co.nz]
> > > > Sent: Friday, November 08, 2002 2:56 PM
> > > > To: CF-Talk
> > > > Subject: Query size
> > > >
> > > >
> > > > Hi Forum,
> > > >
> > > > I need a way to display the query size (in Kb or Mb) in a Cold
> > > > Fusion application and then use it to bill a client. Unusual
> > > > requirement. Had a quick look through the list of Cf
> > > > functions ... didnt seem to find one or did I miss ?
> > > > Is there a cold fusion function to get the size of  query
> > resultsets? I
> > > > need to be able to display / output the size and then use it  for
> > billing
> > > > purposes.
> > > > I know one can know the query size and time in the debugging
> > environment,
> > > > but this is for the client to view.
> > > >
> > > > any Help would be much appreciated.
> > > >
> > > > Thanks
> > > > Srimanta
> > > > - Original Message -
> > > > From: "Michael Dinowitz" <[EMAIL PROTECTED]>
> > > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > > Sent: Thursday, November 07, 2002 2:22 PM
> > > > Subject: Re: sorry if repost
> > > >
> > > >
> > > > > Someone said that the HoF server was hitting them with what
> > > > looked like a
> > > > > DoS attack. I couldn't find the problem and took the server down
> > > > > to
> > look
> > > > > more. I havn't heard back from the guy to know if the problem
> > > > was fixed or
> > > > > not (I think it was a change in his anti-spam routing, but)
> > > > >
> > > > > As for the question, look at these functions:
> > > > >
> > > > > From bin to dec (converts a string to a decimal integer using
> > > > the radix -
> > > > > second attribute)
> > > > > #InputBaseN(1010, 2)#
> > > > >
> > > > > from dec 

Re: Query size

[Srimanta]

Thanks,
I am using MS SQL.

Srimanta
- Original Message -
From: "Jeff" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 07, 2002 9:13 PM
Subject: RE: Query size


> What database are you using?  Does this have to be a ColdFusion
> solution? Or can you work it on the Database end?
>
> Jeff
>
> -Original Message-
> From: Srimanta [mailto:mail@;designshop.co.nz]
> Sent: Friday, November 08, 2002 6:34 PM
> To: CF-Talk
> Subject: Re: Query size
>
>
> Thanks,
> The best solution would have been to get the exact query size.
> Unfortunately average values will not do the job in this case. Dont
> think writing it to a file and then using CF directory to get the file
> size will work either as more than one user can run multiple queries
> simultaneously. Locking is an option. Will have to experiment and see
> how it works. Would be happy to see Macromedia provide a function to get
> query size in the future versions of CF. I think I am in trouble as I
> promsed my client that it can be easily done...
>
> Kind Regards,
> Srimanta
>
> - Original Message -
> From: "Mosh Teitelbaum" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, November 07, 2002 3:26 PM
> Subject: RE: Query size
>
>
> > Well, it's not in KBs or MBs, but you can use queryName.RecordCount to
>
> > determine the number of results in the record.  Multiply that by some
> > multiple and you have an "average" (perhaps?) size.  Sort of.  8^)
> >
> > --
> > Mosh Teitelbaum
> > evoch, LLC
> > Tel: (301) 625-9191
> > Fax: (301) 933-3651
> > Email: [EMAIL PROTECTED]
> > WWW: http://www.evoch.com/
> >
> >
> > > -Original Message-
> > > From: Srimanta [mailto:mail@;designshop.co.nz]
> > > Sent: Friday, November 08, 2002 2:56 PM
> > > To: CF-Talk
> > > Subject: Query size
> > >
> > >
> > > Hi Forum,
> > >
> > > I need a way to display the query size (in Kb or Mb) in a Cold
> > > Fusion application and then use it to bill a client. Unusual
> > > requirement. Had a quick look through the list of Cf
> > > functions ... didnt seem to find one or did I miss ?
> > > Is there a cold fusion function to get the size of  query
> resultsets? I
> > > need to be able to display / output the size and then use it  for
> billing
> > > purposes.
> > > I know one can know the query size and time in the debugging
> environment,
> > > but this is for the client to view.
> > >
> > > any Help would be much appreciated.
> > >
> > > Thanks
> > > Srimanta
> > > - Original Message -
> > > From: "Michael Dinowitz" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Thursday, November 07, 2002 2:22 PM
> > > Subject: Re: sorry if repost
> > >
> > >
> > > > Someone said that the HoF server was hitting them with what
> > > looked like a
> > > > DoS attack. I couldn't find the problem and took the server down
> > > > to
> look
> > > > more. I havn't heard back from the guy to know if the problem
> > > was fixed or
> > > > not (I think it was a change in his anti-spam routing, but)
> > > >
> > > > As for the question, look at these functions:
> > > >
> > > > From bin to dec (converts a string to a decimal integer using
> > > the radix -
> > > > second attribute)
> > > > #InputBaseN(1010, 2)#
> > > >
> > > > from dec to bin (converts a decimal integer to a string using
> > > the radix -
> > > > second attribute)
> > > > #formatbaseN(10, 2)#
> > > >
> > > >
> > > >
> > > > > sorry if this is a repost for some of you, however I didn't get
> > > > > my postreally, I hardly ever get my post, I get it like an
> > > > > hour later or sobut never on time?  mike?
> > > > >
> > > > >
> > > > > does anyone know of an easy method of transforming
> > > > > a binary number to a decimal number?
> > > > >
> > > > > 
> > > > >
> > > > > something that would look like that :)
> > > > >
> > > > > ..tony
> > > > >
> > > > > Tony Weeg
> > > > > Senior Web Developer
> > > > > Information System Design
> > > > > Navtrak, Inc.
> > > > > Fleet Management Solutions
> > > > > www.navtrak.net
> > > > > 410.548.2337
> > > > >
> > > > >
> > > >
> > >
> >
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Re: Query size

[Srimanta]

Thanks,
The best solution would have been to get the exact query size.
Unfortunately average values will not do the job in this case.
Dont think writing it to a file and then using CF directory to get the file
size will work either
as more than one user can run multiple queries  simultaneously. Locking is
an option.
Will have to experiment and see how it works.
Would be happy to see Macromedia provide a function to get query size in the
future versions of CF.
I think I am in trouble as I promsed my client that it can be easily done...

Kind Regards,
Srimanta

- Original Message -
From: "Mosh Teitelbaum" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 07, 2002 3:26 PM
Subject: RE: Query size


> Well, it's not in KBs or MBs, but you can use queryName.RecordCount to
> determine the number of results in the record.  Multiply that by some
> multiple and you have an "average" (perhaps?) size.  Sort of.  8^)
>
> --
> Mosh Teitelbaum
> evoch, LLC
> Tel: (301) 625-9191
> Fax: (301) 933-3651
> Email: [EMAIL PROTECTED]
> WWW: http://www.evoch.com/
>
>
> > -Original Message-
> > From: Srimanta [mailto:mail@;designshop.co.nz]
> > Sent: Friday, November 08, 2002 2:56 PM
> > To: CF-Talk
> > Subject: Query size
> >
> >
> > Hi Forum,
> >
> > I need a way to display the query size (in Kb or Mb) in a Cold Fusion
> > application and then use it to
> > bill a client. Unusual requirement. Had a quick look through the
> > list of Cf
> > functions ... didnt seem to find one or did I miss ?
> > Is there a cold fusion function to get the size of  query  resultsets? I
> > need to be able to display / output the size and then use it  for
billing
> > purposes.
> > I know one can know the query size and time in the debugging
environment,
> > but this is for the client to view.
> >
> > any Help would be much appreciated.
> >
> > Thanks
> > Srimanta
> > - Original Message -
> > From: "Michael Dinowitz" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, November 07, 2002 2:22 PM
> > Subject: Re: sorry if repost
> >
> >
> > > Someone said that the HoF server was hitting them with what
> > looked like a
> > > DoS attack. I couldn't find the problem and took the server down to
look
> > > more. I havn't heard back from the guy to know if the problem
> > was fixed or
> > > not (I think it was a change in his anti-spam routing, but)
> > >
> > > As for the question, look at these functions:
> > >
> > > From bin to dec (converts a string to a decimal integer using
> > the radix -
> > > second attribute)
> > > #InputBaseN(1010, 2)#
> > >
> > > from dec to bin (converts a decimal integer to a string using
> > the radix -
> > > second attribute)
> > > #formatbaseN(10, 2)#
> > >
> > >
> > >
> > > > sorry if this is a repost for some of you, however I didn't
> > > > get my postreally, I hardly ever get my post, I get it like
> > > > an hour later or sobut never on time?  mike?
> > > >
> > > >
> > > > does anyone know of an easy method of transforming
> > > > a binary number to a decimal number?
> > > >
> > > > 
> > > >
> > > > something that would look like that :)
> > > >
> > > > ..tony
> > > >
> > > > Tony Weeg
> > > > Senior Web Developer
> > > > Information System Design
> > > > Navtrak, Inc.
> > > > Fleet Management Solutions
> > > > www.navtrak.net
> > > > 410.548.2337
> > > >
> > > >
> > >
> >
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

QUERY SIZE.

[Srimanta]

Hi Forum,

I need a way to display the query size (in Kb or Mb) in a Cold Fusion
application and then use it to
bill a client. Unusual requirement. Had a quick look through the list of Cf
functions ... didnt seem to find one or did I miss ?
Is there a cold fusion function to get the size of  query  resultsets? I
need to be able to display / output the size and then use it  for billing
purposes.
I know one can know the query size and time in the debugging environment,
but this is for the client to view.

Help would be much appreciated.

Thanks

Srimanta

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Query size

[Srimanta]

Hi Forum,

I need a way to display the query size (in Kb or Mb) in a Cold Fusion
application and then use it to
bill a client. Unusual requirement. Had a quick look through the list of Cf
functions ... didnt seem to find one or did I miss ?
Is there a cold fusion function to get the size of  query  resultsets? I
need to be able to display / output the size and then use it  for billing
purposes.
I know one can know the query size and time in the debugging environment,
but this is for the client to view.

any Help would be much appreciated.

Thanks
Srimanta
- Original Message -
From: "Michael Dinowitz" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 07, 2002 2:22 PM
Subject: Re: sorry if repost


> Someone said that the HoF server was hitting them with what looked like a
> DoS attack. I couldn't find the problem and took the server down to look
> more. I havn't heard back from the guy to know if the problem was fixed or
> not (I think it was a change in his anti-spam routing, but)
>
> As for the question, look at these functions:
>
> From bin to dec (converts a string to a decimal integer using the radix -
> second attribute)
> #InputBaseN(1010, 2)#
>
> from dec to bin (converts a decimal integer to a string using the radix -
> second attribute)
> #formatbaseN(10, 2)#
>
>
>
> > sorry if this is a repost for some of you, however I didn't
> > get my postreally, I hardly ever get my post, I get it like
> > an hour later or sobut never on time?  mike?
> >
> >
> > does anyone know of an easy method of transforming
> > a binary number to a decimal number?
> >
> > 
> >
> > something that would look like that :)
> >
> > ..tony
> >
> > Tony Weeg
> > Senior Web Developer
> > Information System Design
> > Navtrak, Inc.
> > Fleet Management Solutions
> > www.navtrak.net
> > 410.548.2337
> >
> >
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

CF & Currency Conversion

[Srimanta]

Hi All,
Is there a CF tag availabe that can convert currency values depending on
user selection (country)?
I have a CF application which requires displaying currency values depending
on the exchange rates.
The default currency is Australian Dollars. However users  need to see other
values eg NZ Dollars,
UK Pounds, HKDollars, US dollars etc. Changes have to be real time.
I have seen similar in some ASP run websites.
Any ideas as to how to implement it in CF  ?

Thanks

Srimanta


- Original Message -
From: "Jochem van Dieten" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, October 10, 2002 12:25 PM
Subject: Re: OT: SQL Question


> Tony Carcieri wrote:
> > Hi all,
> >
> > Here's what I want to do:
> > UPDATE tablename
> > SET column = 0
> > WHERE ID = ???
> >
> > I want to specify a range of numbers (like 100-200) and increment it by
2.
> > So, 100, 102,104etc would only be updated and the rest wouldn't.
>
> WHERE
> ID BETWEEN 100 AND 200
> AND MOD(ID, 2) = 0
>
> Jochem
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

OT: Browser Usage

[Srimanta]

Hi All,

Does any one know what percentage of users use/ prefer 
Netscape 4.5 or 6  over IE.

Thanks







~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Re: Time Required for Updating DB

[Srimanta]

Its OK
No attitude problems with me.

Srimanta
- Original Message -
From: "Ryan Sabir" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, October 08, 2002 8:41 PM
Subject: RE: Time Required for Updating DB


> The code is missing  tags around the SQL code...
>
> Maybe if you tried to understand what the code was doing instead of
> blindly pasting it in you would see these problems first.
>
> No hard feelings, its just that we'd all like to see you become a
> better CF coder so we can help you with more interesting problems!
>
> bye!
>
>
> ---
> Ryan Sabir
> Newgency Pty Ltd
> 2a Broughton St
> Paddington 2021
> Sydney, Australia
> Ph (02) 9331 2133
> Fax (02) 9331 5199
> Mobile: 0411 512 454
> http://www.newgency.com/index.cfm?referer=rysig
>
> > -Original Message-
> > From: Srimanta [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, 8 October 2002 5:40 PM
> > To: CF-Talk
> > Subject: Re: Time Required for Updating DB
> >
> >
> > Mosh,
> >
> > Tried the codes. Still no luck.
> > The query runs for about 8 to 10 minutes and then the
> > screen shows hundreds of lines of the SQL and no data is updated.
> >
> > Srimanta
> > - Original Message -
> > From: "Mosh Teitelbaum" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Tuesday, October 08, 2002 8:03 PM
> > Subject: RE: Time Required for Updating DB
> >
> >
> > > > Thanks Mosh
> > >
> > > Yup. 8^)
> > >
> > > > I am trying to update price field in Table named
> > Product with values
> > from
> > > > field newprice in Table named New. The primary key in
> > both the tables is
> > > > dealerpart no (Text) which is unique.
> > > > Note: All the records need to be updated
> > > > 
> > > > Select New.newprice,New.dealerpartno,New.publisher,
> > > > Product.publisher,Product.dealerpartno,Product.price
> > > > >From New,Product
> > > > 
> > > >
> > > >
> > > > 
> > > > Update Product
> > > > SET Product.price= #UpdatePrice.newprice#
> > > > WHERE Product.dealerpartno = #UpdatePrice.dealerpartno#
> > > >
> > > > 
> > > >
> > > > Note: There are 2 records in both the tables.
> > >
> > > Srimanta:
> > >
> > > There are a few problems here.  The first is with your
> > SELECT query:
> > > Select
> > > New.newprice,
> > > New.dealerpartno,
> > > New.publisher,
> > > Product.publisher,
> > > Product.dealerpartno,
> > > Product.price
> > > From
> > > New,
> > > Product
> > >
> > > This query (aside from producing two "dealerpartno"
> > columns) does not
> > > specify how to join the two tables.  It therefore creates
> > (if I remember
> > the
> > > terminology correctly) a Cartesian Product of the two
> > tables.  This is,
> > > essentially, a result set of every single possible
> > combination of the
> > > records from each table.  For example, if your 2 tables
> > had the following
> > > data:
> > > New.newPrice Product.price
> > >  =
> > > a 1
> > > b 2
> > >
> > > the result set would be:
> > > newPrice price
> > >  =
> > > a 1
> > > a 2
> > > b 1
> > > b 2
> > >
> > > So, since both of your tables have 20,000 records, your
> > SELECT query is
> > > returning a result set with 20,000 x 20,000 records
> > (400,000,000 records).
> > > Looping 400 million times is probably what's taking so long 8^).
> > >
> > > Instead, your query should look something like:
> > > SELECT
> > > New.newprice,
> > > New.dealerpartno AS newDealerPartNo,
> > > New.publisher AS newPublisher,
> > > Product.publisher AS oldPublisher,
> > > Product.dealerpartno AS oldDealerPartNo,
> > > Product.price
> > > FROM
> > > New,
> > > Product
> > > WHERE
> > > New.dealerPartNo = Product.dealerPartNo
> > >
> > > This query will produce a result set with only 20,000
> > records (assuming
> > > there's a 1-to-1 match of the part numbers in the 2 tables).
> > >
> > > All that said, I don't think you need the join in the
> > SELECT query.  It
> > > might be enough to change your code to the following:
> > >
> > > 
> > > SELECT
> > > newprice,
> > > dealerpartno
> > > FROM
> > > New
> > > 
> > >
> > > 
> > > 
> > > UPDATE Product
> > > SET price= #newprice#
> > > WHERE dealerpartno = #dealerpartno#
> > > 
> > > 
> > >
> > > --
> > > Mosh Teitelbaum
> > > evoch, LLC
> > > Tel: (301) 625-9191
> > > Fax: (301) 933-3651
> > > Email: [EMAIL PROTECTED]
> > > WWW: http://www.evoch.com/
> > >
> > >
> >
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Re: Time Required for Updating DB

[Srimanta]

Mosh,

Tried the codes. Still no luck.
The query runs for about 8 to 10 minutes and then the
screen shows hundreds of lines of the SQL and no data is updated.

Srimanta
- Original Message -
From: "Mosh Teitelbaum" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, October 08, 2002 8:03 PM
Subject: RE: Time Required for Updating DB


> > Thanks Mosh
>
> Yup. 8^)
>
> > I am trying to update price field in Table named Product with values
from
> > field newprice in Table named New. The primary key in both the tables is
> > dealerpart no (Text) which is unique.
> > Note: All the records need to be updated
> > 
> > Select New.newprice,New.dealerpartno,New.publisher,
> > Product.publisher,Product.dealerpartno,Product.price
> > >From New,Product
> > 
> >
> >
> > 
> > Update Product
> > SET Product.price= #UpdatePrice.newprice#
> > WHERE Product.dealerpartno = #UpdatePrice.dealerpartno#
> >
> > 
> >
> > Note: There are 2 records in both the tables.
>
> Srimanta:
>
> There are a few problems here.  The first is with your SELECT query:
> Select
> New.newprice,
> New.dealerpartno,
> New.publisher,
> Product.publisher,
> Product.dealerpartno,
> Product.price
> From
> New,
> Product
>
> This query (aside from producing two "dealerpartno" columns) does not
> specify how to join the two tables.  It therefore creates (if I remember
the
> terminology correctly) a Cartesian Product of the two tables.  This is,
> essentially, a result set of every single possible combination of the
> records from each table.  For example, if your 2 tables had the following
> data:
> New.newPrice Product.price
>  =
> a 1
> b 2
>
> the result set would be:
> newPrice price
>  =
> a 1
> a 2
> b 1
> b 2
>
> So, since both of your tables have 20,000 records, your SELECT query is
> returning a result set with 20,000 x 20,000 records (400,000,000 records).
> Looping 400 million times is probably what's taking so long 8^).
>
> Instead, your query should look something like:
> SELECT
> New.newprice,
> New.dealerpartno AS newDealerPartNo,
> New.publisher AS newPublisher,
> Product.publisher AS oldPublisher,
> Product.dealerpartno AS oldDealerPartNo,
> Product.price
> FROM
> New,
> Product
> WHERE
> New.dealerPartNo = Product.dealerPartNo
>
> This query will produce a result set with only 20,000 records (assuming
> there's a 1-to-1 match of the part numbers in the 2 tables).
>
> All that said, I don't think you need the join in the SELECT query.  It
> might be enough to change your code to the following:
>
> 
> SELECT
> newprice,
> dealerpartno
> FROM
> New
> 
>
> 
> 
> UPDATE Product
> SET price= #newprice#
> WHERE dealerpartno = #dealerpartno#
> 
> 
>
> --
> Mosh Teitelbaum
> evoch, LLC
> Tel: (301) 625-9191
> Fax: (301) 933-3651
> Email: [EMAIL PROTECTED]
> WWW: http://www.evoch.com/
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Re: Time Required for Updating DB

[Srimanta]

Many Thanks Mosh,

Thanks for the time taken to look into my problem and for the codes.
Will try .

Srimanta

- Original Message -
From: "Mosh Teitelbaum" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, October 08, 2002 8:03 PM
Subject: RE: Time Required for Updating DB


> > Thanks Mosh
>
> Yup. 8^)
>
> > I am trying to update price field in Table named Product with values
from
> > field newprice in Table named New. The primary key in both the tables is
> > dealerpart no (Text) which is unique.
> > Note: All the records need to be updated
> > 
> > Select New.newprice,New.dealerpartno,New.publisher,
> > Product.publisher,Product.dealerpartno,Product.price
> > >From New,Product
> > 
> >
> >
> > 
> > Update Product
> > SET Product.price= #UpdatePrice.newprice#
> > WHERE Product.dealerpartno = #UpdatePrice.dealerpartno#
> >
> > 
> >
> > Note: There are 2 records in both the tables.
>
> Srimanta:
>
> There are a few problems here.  The first is with your SELECT query:
> Select
> New.newprice,
> New.dealerpartno,
> New.publisher,
> Product.publisher,
> Product.dealerpartno,
> Product.price
> From
> New,
> Product
>
> This query (aside from producing two "dealerpartno" columns) does not
> specify how to join the two tables.  It therefore creates (if I remember
the
> terminology correctly) a Cartesian Product of the two tables.  This is,
> essentially, a result set of every single possible combination of the
> records from each table.  For example, if your 2 tables had the following
> data:
> New.newPrice Product.price
>  =
> a 1
> b 2
>
> the result set would be:
> newPrice price
>  =
> a 1
> a 2
> b 1
> b 2
>
> So, since both of your tables have 20,000 records, your SELECT query is
> returning a result set with 20,000 x 20,000 records (400,000,000 records).
> Looping 400 million times is probably what's taking so long 8^).
>
> Instead, your query should look something like:
> SELECT
> New.newprice,
> New.dealerpartno AS newDealerPartNo,
> New.publisher AS newPublisher,
> Product.publisher AS oldPublisher,
> Product.dealerpartno AS oldDealerPartNo,
> Product.price
> FROM
> New,
> Product
> WHERE
> New.dealerPartNo = Product.dealerPartNo
>
> This query will produce a result set with only 20,000 records (assuming
> there's a 1-to-1 match of the part numbers in the 2 tables).
>
> All that said, I don't think you need the join in the SELECT query.  It
> might be enough to change your code to the following:
>
> 
> SELECT
> newprice,
> dealerpartno
> FROM
> New
> 
>
> 
> 
> UPDATE Product
> SET price= #newprice#
> WHERE dealerpartno = #dealerpartno#
> 
> 
>
> --
> Mosh Teitelbaum
> evoch, LLC
> Tel: (301) 625-9191
> Fax: (301) 933-3651
> Email: [EMAIL PROTECTED]
> WWW: http://www.evoch.com/
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: Time Required for Updating DB

[Srimanta]

Thanks Mosh

This is what I am using:

This update Query is not working. After seven hours of hard work my hard
drive has stopped making the horrible grinding sound.

The Result:   None of the records were updated. Can someone please help.

I am trying to update price field in Table named Product with values from
field newprice in Table named New. The primary key in both the tables is
dealerpart no (Text) which is unique.
Note: All the records need to be updated

Select New.newprice,New.dealerpartno,New.publisher,
Product.publisher,Product.dealerpartno,Product.price
>From New,Product




Update Product
SET Product.price= #UpdatePrice.newprice#
WHERE Product.dealerpartno = #UpdatePrice.dealerpartno#



Note: There are 2 records in both the tables.

Thanks
Srimanta
- Original Message -
From: "Mosh Teitelbaum" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, October 08, 2002 7:28 PM
Subject: RE: Time Required for Updating DB


> Like (I think) Isaac said, there's probably something wrong with the code,
> but it's kind of hard to tell for sure without looking at the code.
>
> I apologize if this is obvious, but since you didn't really explain the
> particulars of the situation, I wanted to make sure that you weren't
> inadvertently making this harder than need be.  Does the situation allow
for
> you to update the column via a single UPDATE query as in:
>
> UPDATE fooTable
> SET barColumn = barColumn + 1
>
> If so, this will be infinitely quicker than having to perform 1 UPDATE
query
> per record.
>
> --
> Mosh Teitelbaum
> evoch, LLC
> Tel: (301) 625-9191
> Fax: (301) 933-3651
> Email: [EMAIL PROTECTED]
> WWW: http://www.evoch.com/
>
>
> > -Original Message-
> > From: Srimanta [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, October 07, 2002 8:47 PM
> > To: CF-Talk
> > Subject: Time Required for Updating DB
> >
> >
> > Hi
> > I am having trouble updating a fairly small size database with
> > approx 2
> > records.
> > Size in MB is approx 18 MB. Type Access 2000.
> >
> > I am updating one particular column, in all the rows with CF
> > Query and Loop
> > tags.
> > First the program generates : Bad Allocation Error complaining of
Virtual
> > memory shortage.
> > I have 256 MB Ram Windows 2000 Server Pentium III 999 MZ Processor.
> >
> > When I increased the Virtual memory size the update seems to be
> > going on for
> > ever!!!
> > Its exactly 5 hours plus now its running.
> > How much time does similar updates take?? Any ideas ??
> > I have not done this before.
> >
> > Srimanta
> >
> >
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Time Required for Updating DB

[Srimanta]

Hi
I am having trouble updating a fairly small size database with approx 2
records.
Size in MB is approx 18 MB. Type Access 2000.

I am updating one particular column, in all the rows with CF Query and Loop
tags.
First the program generates : Bad Allocation Error complaining of Virtual
memory shortage.
I have 256 MB Ram Windows 2000 Server Pentium III 999 MZ Processor.

When I increased the Virtual memory size the update seems to be going on for
ever!!!
Its exactly 5 hours plus now its running.
How much time does similar updates take?? Any ideas ??
I have not done this before.

Srimanta

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Re: Primary Keys & Duplicate Values

[Srimanta]

Thanks.
Yes I understand.
What I could do is to combine both modelno and the name of the manufacturer
and use them in updates. That should prevent updating the wrong records
should the model number not be unique.
The problem with using an additional field (perhaps with auto number) is
that the table to be updated
and the table from which the new values (price etc) will be sourced may not
have the same auto number id. Also my table(Table1) will have product data
from multiple vendors.
Different vendors will have tables where Id values might clash.

Srimanta
- Original Message -
From: "Andy Ousterhout" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, October 08, 2002 8:34 AM
Subject: RE: Primary Keys & Duplicate Values


> I highly recommend that you don't make Model number your primary key.  Add
a
> new field, numeric, and make your primary key a meaningless number that
will
> never change.  I've used several products that lock model number and for
> newer companies where their numbering system evolves, this has been an
> incredible and preventable pain in the back side.
>
> What does everyone else recommend?
>
> Andy
>
> -Original Message-
> From: Srimanta [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 07, 2002 1:48 PM
> To: CF-Talk
> Subject: Re: Primary Keys & Duplicate Values
>
>
> Thanks
> Field 1 represents model number of products which should be unique.
However
> due to some error in data entry some of the records are duplicate. I can
> safely delete those records.
>
> Srimanta
> - Original Message -
> From: "Robertson-Ravo, Neil (REC)" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, October 07, 2002 10:52 PM
> Subject: RE: Primary Keys & Duplicate Values
>
>
> > Yep, your problem is that you have dupes in the column you want to tag
as
> a
> > PK.   is Field 1 the only field which is uses dupe values?  are the
> records
> > technically unique or can you safely delete them?
> >
> >
> >
> > -Original Message-
> > From: Srimanta [mailto:[EMAIL PROTECTED]]
> > Sent: 07 October 2002 10:43
> > To: CF-Talk
> > Subject: OT: Primary Keys & Duplicate Values
> >
> >
> > Hi,
> > Once again its me.
> >
> > I have a table with 18000 records.
> > There are three fields say field1, field2 and field3.
> > There are no primary keys at the moment.
> >
> > I want to delegate field1 as the primary key in the modified table.
> > When I try to create field1 as the primary key, an error is generated as
> > there are duplicate values in the records in field1.
> > How do I find which values are duplicate in field1.
> > I cannot use the Find and replace function as I do not know which values
> to
> > look for. Also manually it is impossible as there are too many records
to
> > search through.
> > Is there a Cold Fusion custom tag or function  or SQL syntax I can use?
> > Any help will be much appreciated.
> >
> > Thanks
> > Srimanta
> > - Original Message -
> > From: "Kola Oyedeji" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Monday, October 07, 2002 9:38 PM
> > Subject: RE: Variable locking
> >
> >
> > > Hi
> > >
> > > I'm joining this thread late. Can I just confirm what you guys are
> > > saying: In CFMX named locks should be used in place of scoped locks
and
> > > locks are only needed
> > > When a possible race condition could occur?
> > >
> > > Thanks
> > >
> > > Kola
> > >
> > > -Original Message-
> > > From: Sean A Corfield [mailto:[EMAIL PROTECTED]]
> > > Sent: 04 October 2002 22:53
> > > To: CF-Talk
> > > Subject: Re: Variable locking
> > >
> > > On Friday, Oct 4, 2002, at 12:07 US/Pacific, Gaulin, Mark wrote:
> > > > Actually, that using NAME is not a better practice... the SCOPE
> > > > attribute is
> > > > safer and is also what MM support advised us to use (when
applicable).
> > >
> > > Pre-MX.
> > >
> > > > Sure, the scope of a NAME-based lock will be tighter than using
SCOPE,
> > >
> > > > but
> > > > SCOPE will be safer and, as a bonus, you can use CF 5's (and prior)
> > > > auto-checking for missing locks...
> > >
> > > Which is no longer available in MX because it is no longer needed.
> > >
> > > > Basically

Re: Primary Keys & Duplicate Values

[Srimanta]

Thanks
Field 1 represents model number of products which should be unique. However
due to some error in data entry some of the records are duplicate. I can
safely delete those records.

Srimanta
- Original Message -
From: "Robertson-Ravo, Neil (REC)" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, October 07, 2002 10:52 PM
Subject: RE: Primary Keys & Duplicate Values


> Yep, your problem is that you have dupes in the column you want to tag as
a
> PK.   is Field 1 the only field which is uses dupe values?  are the
records
> technically unique or can you safely delete them?
>
>
>
> -Original Message-
> From: Srimanta [mailto:[EMAIL PROTECTED]]
> Sent: 07 October 2002 10:43
> To: CF-Talk
> Subject: OT: Primary Keys & Duplicate Values
>
>
> Hi,
> Once again its me.
>
> I have a table with 18000 records.
> There are three fields say field1, field2 and field3.
> There are no primary keys at the moment.
>
> I want to delegate field1 as the primary key in the modified table.
> When I try to create field1 as the primary key, an error is generated as
> there are duplicate values in the records in field1.
> How do I find which values are duplicate in field1.
> I cannot use the Find and replace function as I do not know which values
to
> look for. Also manually it is impossible as there are too many records to
> search through.
> Is there a Cold Fusion custom tag or function  or SQL syntax I can use?
> Any help will be much appreciated.
>
> Thanks
> Srimanta
> - Original Message -
> From: "Kola Oyedeji" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, October 07, 2002 9:38 PM
> Subject: RE: Variable locking
>
>
> > Hi
> >
> > I'm joining this thread late. Can I just confirm what you guys are
> > saying: In CFMX named locks should be used in place of scoped locks and
> > locks are only needed
> > When a possible race condition could occur?
> >
> > Thanks
> >
> > Kola
> >
> > -Original Message-
> > From: Sean A Corfield [mailto:[EMAIL PROTECTED]]
> > Sent: 04 October 2002 22:53
> > To: CF-Talk
> > Subject: Re: Variable locking
> >
> > On Friday, Oct 4, 2002, at 12:07 US/Pacific, Gaulin, Mark wrote:
> > > Actually, that using NAME is not a better practice... the SCOPE
> > > attribute is
> > > safer and is also what MM support advised us to use (when applicable).
> >
> > Pre-MX.
> >
> > > Sure, the scope of a NAME-based lock will be tighter than using SCOPE,
> >
> > > but
> > > SCOPE will be safer and, as a bonus, you can use CF 5's (and prior)
> > > auto-checking for missing locks...
> >
> > Which is no longer available in MX because it is no longer needed.
> >
> > > Basically, "NAME" is older than "SCOPE", and SCOPE was added to
> > address
> > > issues that NAME cannot handle.
> >
> > SCOPE was added to resolve bugs in earlier releases of CF around the
> > shared scope memory corruption problems. That is no longer an issue in
> > CFMX.
> >
> > An Architect's View -- http://www.corfield.org/blog/
> >
> > Macromedia DevCon 2002, October 27-30, Orlando, Florida
> > Architecting a New Internet Experience
> > Register today at http://www.macromedia.com/go/devcon2002
> >
> >
> >
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

OT: Primary Keys & Duplicate Values

[Srimanta]

Hi,
Once again its me.

I have a table with 18000 records.
There are three fields say field1, field2 and field3.
There are no primary keys at the moment.

I want to delegate field1 as the primary key in the modified table.
When I try to create field1 as the primary key, an error is generated as
there are duplicate values in the records in field1.
How do I find which values are duplicate in field1.
I cannot use the Find and replace function as I do not know which values to
look for. Also manually it is impossible as there are too many records to
search through.
Is there a Cold Fusion custom tag or function  or SQL syntax I can use?
Any help will be much appreciated.

Thanks
Srimanta
- Original Message -
From: "Kola Oyedeji" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, October 07, 2002 9:38 PM
Subject: RE: Variable locking


> Hi
>
> I'm joining this thread late. Can I just confirm what you guys are
> saying: In CFMX named locks should be used in place of scoped locks and
> locks are only needed
> When a possible race condition could occur?
>
> Thanks
>
> Kola
>
> -Original Message-
> From: Sean A Corfield [mailto:[EMAIL PROTECTED]]
> Sent: 04 October 2002 22:53
> To: CF-Talk
> Subject: Re: Variable locking
>
> On Friday, Oct 4, 2002, at 12:07 US/Pacific, Gaulin, Mark wrote:
> > Actually, that using NAME is not a better practice... the SCOPE
> > attribute is
> > safer and is also what MM support advised us to use (when applicable).
>
> Pre-MX.
>
> > Sure, the scope of a NAME-based lock will be tighter than using SCOPE,
>
> > but
> > SCOPE will be safer and, as a bonus, you can use CF 5's (and prior)
> > auto-checking for missing locks...
>
> Which is no longer available in MX because it is no longer needed.
>
> > Basically, "NAME" is older than "SCOPE", and SCOPE was added to
> address
> > issues that NAME cannot handle.
>
> SCOPE was added to resolve bugs in earlier releases of CF around the
> shared scope memory corruption problems. That is no longer an issue in
> CFMX.
>
> An Architect's View -- http://www.corfield.org/blog/
>
> Macromedia DevCon 2002, October 27-30, Orlando, Florida
> Architecting a New Internet Experience
> Register today at http://www.macromedia.com/go/devcon2002
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Update Problem in CF

[Srimanta]

Hi,

I have two tables in a DB containing information about the same products.
Table 1 is comprehensive and has complete details about the products.
Table 2 has fewer no of fields.
The fields common in both Table 1 and Table 2 are productid, modelno, price,
details .

Table1.price contains the old price.
Table2. price is the latest price.

I want to update Table1.price with the values in Table2.price and use
modelno as the unique
value for this update.

Can someone please help.
My SQL knowlede is very basic.
Also what if  Table two consists of new products not included in Table 1.?
What syntax Should  I use?


Thanks
JB


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Re: Cumulative Patch for SQL Server (Q316333) Crtical for 2000

[Srimanta]

Classic!

sr..
- Original Message -
From: "Rob Rohan" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 04, 2002 11:37 AM
Subject: RE: Cumulative Patch for SQL Server (Q316333) Crtical for 2000


> If Microsoft made an airplane would you fly in it?
>
> Then why run your business on it?
>
> -Original Message-
> From: Paris Lundis [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 03, 2002 7:52 AM
> To: CF-Talk
> Subject: Re: Cumulative Patch for SQL Server (Q316333) Crtical for 2000
>
>
> Micro$oft has to stop this s*it...
>
> It's getting silly as can be...  In the last week we have had to
> install about 4-6 OS issued patches it seems and now this...
>
> These big long winded follow 652 step type ones are at the top of the
> annoyance list..
>
> It's almost like they are daring us all to flee their stranglehold...
>
> Just imagine if this were your car and every day almost you had to take
> it to the dealer to be serviced...  What would you do with that car?
>
> Paris Lundis
> Founder
> Areaindex, L.L.C.
> http://www.areaindex.com
> http://www.pubcrawler.com
> 412-292-3135
> [finding the future in the past, passing the future in the present]
> [connecting people, places and things]
>
>
> -Original Message-
> From: Zac Spitzer <[EMAIL PROTECTED]>
> Date: Thu, 03 Oct 2002 16:42:25 +0200
> Subject: Cumulative Patch for SQL Server (Q316333) Crtical for 2000
>
> > Microsoft Security Bulletin MS02-056
> >
> >  > ecurity/bulletin/MS02-056.asp>
> >
> > have fun, yet another crappy m$ patch from with no installer and 2
> > pages
> >   of instructions
> >
> > and it's rated critical for all internet instances
> >
> > z
> >
> >
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Application & Cf Include

[Srimanta]

Hi,

Is there a way to exlude a file (on a particular cfm template) which is
included in the Application.cfm by  tag.
In other words, I have an Application.cfm  which includes a header.cfm file
by tag.
Within the same application  framework I have a file Special.cfm.
I do not want to load the Header.cfm file on this page. But as the
application.cfm file includes the header file it is always included in all
the other files.

I know I can use the cfinclude tag on each and every page individually to
include the header page. But as the intranet site has more than 500
templates it seems to be a lot of work just to exclude one page.

Any ideas ?

Thanks

Srimanta


- Original Message -
From: "Paris Lundis" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 04, 2002 2:51 AM
Subject: Re: Cumulative Patch for SQL Server (Q316333) Crtical for 2000


> Micro$oft has to stop this s*it...
>
> It's getting silly as can be...  In the last week we have had to
> install about 4-6 OS issued patches it seems and now this...
>
> These big long winded follow 652 step type ones are at the top of the
> annoyance list..
>
> It's almost like they are daring us all to flee their stranglehold...
>
> Just imagine if this were your car and every day almost you had to take
> it to the dealer to be serviced...  What would you do with that car?
>
> Paris Lundis
> Founder
> Areaindex, L.L.C.
> http://www.areaindex.com
> http://www.pubcrawler.com
> 412-292-3135
> [finding the future in the past, passing the future in the present]
> [connecting people, places and things]
>
>
> -Original Message-
> From: Zac Spitzer <[EMAIL PROTECTED]>
> Date: Thu, 03 Oct 2002 16:42:25 +0200
> Subject: Cumulative Patch for SQL Server (Q316333) Crtical for 2000
>
> > Microsoft Security Bulletin MS02-056
> >
> > <http://www.microsoft.com/technet/treeview/default.asp?url=/technet/s
> > ecurity/bulletin/MS02-056.asp>
> >
> > have fun, yet another crappy m$ patch from with no installer and 2
> > pages
> >   of instructions
> >
> > and it's rated critical for all internet instances
> >
> > z
> >
> >
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Re: CF Mail Problem..

[Srimanta]

Thanks The code is working.
However there is still one problem.
The email sent is in html format and includes images within the html tables.
How do I ensure that the images are sent to email addresses along with the
html tables.
At the moment the images are not visible. I am using Outlook express.

Any ideas?
Thanks again

Srimanta

- Original Message -
From: "Joel Nath" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, October 01, 2002 7:11 PM
Subject: RE: CF Mail Problem..


> Hi Srimanta,
>
> try something like...
>
>
> 
> Select * FROM Products WHERE product id=#Form.productid#
> 
>
>  from="myemail.com"
> subject="Product"
>   type="HTML">
>  
> 
>
>
> 
>Productid: #Get_Products.productid#   
>   Details: #Get_Products.details#   
>   Model : #Get_Products.modelno#   
> 
>
>
> 
> 
>  
>
> hth
> joel
>
>
>
> -Original Message-
> From: Srimanta [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 1 October 2002 2:51
> To: CF-Talk
> Subject: CF Mail Problem..
>
>
> Hello Forum,
>
> Need Help.
>
> I am trying to send data generated by a query using CFMAIL tag to a
> recepient whose email is obtained from a Form.
> However Instead of including and sending only one email containing  all
the
> rows returned by the query to the email address obtained from the Form in
> the previous page CFMAIL is sending multiple emails to the same email
> address
> --one email for each record generate from the query. Thus each email
> contains only one seperate record.
> I cant understand why?
> The recepient email address comes from the Form. The contents of the email
> is generated by the db query.
> Any help will be much appreciated.
>
> This is my code:
>
> 
> Select * FROM Products WHERE product id=#Form.productid#
> 
>
>  to="#Form.Email_Address#"
> from="myemail.com"
> subject="Product"
>
>   type="HTML">
>
>  From: "jon hall" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, October 01, 2002 4:13 PM
> Subject: Re: Using Java nulls in CF?
>
>
> > For anyone wondering...with smaller files it really doesn't matter,
> > but with a 2.3MB IIS logfile, the Java ReadLine method is about 30-40
> > percent faster than the old standby looping over the file as a string
> > using chr(10) as a delimiter.
> >
> > --
> >  jon
> >  mailto:[EMAIL PROTECTED]
> >
> > Monday, September 30, 2002, 11:43:44 PM, you wrote:
> > jh> Actually I didn't even think of using isDefined(), and I think
> > jh> you answered my question without knowing it :).
> >
> > jh> All I really wanted to do was use java's readLine() method, but
> > jh> readLine returns a null when the last line has been read. So I stuck
> > jh> isDefined() in there an voila! It worked.
> >
> > jh> 
> > jh> fr = createObject("java", "java.io.FileReader");
> > jh> br = createObject("java", "java.io.BufferedReader");
> > jh> fr.init(filename);
> > jh> br.init(fr);
> >
> > jh> line = br.readLine();
> > jh> while (isDefined("line")) {
> > jh> writeOutput(line & '');
> > jh> line = br.readLine();
> > jh> }
> >
> > jh> fr.close();
> > jh> br.close();
> > jh> 
> >
> >
> > jh> Now I'm going to see if this is any faster than looping over line
> > jh> breaks in a string. I hope so after all I tried to get this to work
:)
> >
> >
>
> 
__
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: CF Mail Problem..

[Srimanta]

Hi Sabir
Many Thanks Mate..
It Works
S..

- Original Message -
From: "Ryan Sabir" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, October 01, 2002 6:25 PM
Subject: RE: CF Mail Problem..


> Thats how CFMAIL is supposed to work when you pass a query to it.
>
> What you should do is use a  inside your
> CFMAIL content section to output the data you need in the table.
>
> bye!
>
>
> ---
> Ryan Sabir
> Newgency Pty Ltd
> 2a Broughton St
> Paddington 2021
> Sydney, Australia
> Ph (02) 9331 2133
> Fax (02) 9331 5199
> Mobile: 0411 512 454
> http://www.newgency.com/index.cfm?referer=rysig
>
> > -Original Message-
> > From: Srimanta [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, 1 October 2002 2:51 PM
> > To: CF-Talk
> > Subject: CF Mail Problem..
> >
> >
> > Hello Forum,
> >
> > Need Help.
> >
> > I am trying to send data generated by a query using CFMAIL tag to a
> > recepient whose email is obtained from a Form.
> > However Instead of including and sending only one email
> > containing  all  the
> > rows returned by the query to the email address obtained
> > from the Form in
> > the previous page CFMAIL is sending multiple emails to the
> > same email
> > address
> > --one email for each record generate from the query. Thus each email
> > contains only one seperate record.
> > I cant understand why?
> > The recepient email address comes from the Form. The
> > contents of the email
> > is generated by the db query.
> > Any help will be much appreciated.
> >
> > This is my code:
> >
> > 
> > Select * FROM Products WHERE product id=#Form.productid#
> > 
> >
> >  > to="#Form.Email_Address#"
> > from="myemail.com"
> > subject="Product"
> >
> >   type="HTML">
> >
> >  > From: "jon hall" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Tuesday, October 01, 2002 4:13 PM
> > Subject: Re: Using Java nulls in CF?
> >
> >
> > > For anyone wondering...with smaller files it really
> > doesn't matter,
> > > but with a 2.3MB IIS logfile, the Java ReadLine method is
> > about 30-40
> > > percent faster than the old standby looping over the file
> > as a string
> > > using chr(10) as a delimiter.
> > >
> > > --
> > >  jon
> > >  mailto:[EMAIL PROTECTED]
> > >
> > > Monday, September 30, 2002, 11:43:44 PM, you wrote:
> > > jh> Actually I didn't even think of using isDefined(), and I think
> > > jh> you answered my question without knowing it :).
> > >
> > > jh> All I really wanted to do was use java's readLine()
> > method, but
> > > jh> readLine returns a null when the last line has been
> > read. So I stuck
> > > jh> isDefined() in there an voila! It worked.
> > >
> > > jh> 
> > > jh> fr = createObject("java", "java.io.FileReader");
> > > jh> br = createObject("java", "java.io.BufferedReader");
> > > jh> fr.init(filename);
> > > jh> br.init(fr);
> > >
> > > jh> line = br.readLine();
> > > jh> while (isDefined("line")) {
> > > jh> writeOutput(line & '');
> > > jh> line = br.readLine();
> > > jh> }
> > >
> > > jh> fr.close();
> > > jh> br.close();
> > > jh> 
> > >
> > >
> > > jh> Now I'm going to see if this is any faster than
> > looping over line
> > > jh> breaks in a string. I hope so after all I tried to
> > get this to work :)
> > >
> > >
> >
> 
__
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

CF Mail Problem..

[Srimanta]

Hello Forum,

Need Help.

I am trying to send data generated by a query using CFMAIL tag to a
recepient whose email is obtained from a Form.
However Instead of including and sending only one email containing  all  the
rows returned by the query to the email address obtained from the Form in
the previous page CFMAIL is sending multiple emails to the same email
address
--one email for each record generate from the query. Thus each email
contains only one seperate record.
I cant understand why?
The recepient email address comes from the Form. The contents of the email
is generated by the db query.
Any help will be much appreciated.

This is my code:


Select * FROM Products WHERE product id=#Form.productid#




  jon
>  mailto:[EMAIL PROTECTED]
>
> Monday, September 30, 2002, 11:43:44 PM, you wrote:
> jh> Actually I didn't even think of using isDefined(), and I think
> jh> you answered my question without knowing it :).
>
> jh> All I really wanted to do was use java's readLine() method, but
> jh> readLine returns a null when the last line has been read. So I stuck
> jh> isDefined() in there an voila! It worked.
>
> jh> 
> jh> fr = createObject("java", "java.io.FileReader");
> jh> br = createObject("java", "java.io.BufferedReader");
> jh> fr.init(filename);
> jh> br.init(fr);
>
> jh> line = br.readLine();
> jh> while (isDefined("line")) {
> jh> writeOutput(line & '');
> jh> line = br.readLine();
> jh> }
>
> jh> fr.close();
> jh> br.close();
> jh> 
>
>
> jh> Now I'm going to see if this is any faster than looping over line
> jh> breaks in a string. I hope so after all I tried to get this to work :)
>
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.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