SQL Question

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

Re: dancing 'round the mullberry bush

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

Help with Search Engine

. 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

Re: Cannot convert to number.

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

Redirection based on IP address.

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

Re: Redirection based on IP address.

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

OT: Australian NZ Stock Quotes

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

OT: Preventing URL Display in Status bar

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

Re: Preventing URL Display in Status bar

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

OT: Email authentication

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

Re: Email authentication

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

Query size

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

QUERY SIZE.

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

Re: Query size

. 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

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

Re: Query size

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

OT: Browser Usage

Hi All, Does any one know what percentage of users use/ prefer Netscape 4.5 or 6 over IE. Thanks S ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

CF Currency Conversion

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

Re: Time Required for Updating DB

,Product.price From New,Product /CFQUERY cfloop query=UpdatePrice Update Product SET Product.price= #UpdatePrice.newprice# WHERE Product.dealerpartno = #UpdatePrice.dealerpartno# /cfloop Note: There are 2 records in both the tables. Thanks Srimanta - Original Message - From: Mosh

Re: Time Required for Updating DB

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

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

Re: Time Required for Updating DB

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 CFQUERY etc... tags around the SQL code... Maybe

OT: Primary Keys Duplicate Values

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

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

Re: Primary Keys Duplicate Values

) 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

Time Required for Updating DB

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

Update Problem in CF

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

Application Cf Include

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

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

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

Re: CF Mail Problem..

://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

Re: CF Mail Problem..

. 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... CFQUERY name= Get_Products DataSource=XYZ Select

CF Mail Problem..

selected by the user in the Form.cfm Page. Thanks Srimanta - Original Message - 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