Re: Group Query help.

] 615.370.1530 x737 --//- -Original Message- From: Nomad [mailto:[EMAIL PROTECTED] Sent: Thursday, December 15, 2005 10:49 PM To: CF-Talk Subject: Group Query help. Hello! How do I limit the number of rows returned per group in a grouped query. My query: Select

Group Query help.

Hello! How do I limit the number of rows returned per group in a grouped query. My query: Select pid, Details, Brand from Products group by brand order by price This query returns: pid Details Brand 1abcdMacromedia

Getting first 10 words from a string.

Hello! Need help. How do I get the first (say 10) words from a string? Problem: A query to my database returns a column (details) that is of memo type. I want to limit the display of this column to the first 10 words only. I had a quick look at the CFML documentation for string functions but

Getting the first 10 words from a string..

Hello! Need help. How do I get the first (say 10) words from a string? Problem: A query to my database returns a column (details) that is of memo type. I want to limit the display of this column to the first 10 words only. I had a quick look at the CFML documentation for string functions but

Client/Session Variable: When to set?

Hello! Need to clear this up once and for all When is the best time to set session/client variables..(Application page or Cart page for an online shop) and why? My understanding is that sites that set session/client variables in Application page have poor search engine ranking. Thanks in

Re: Client/Session Variable: When to set?

going to know where the session/client variables are being set. In general, you probably want to allow bots to spider the pages of your shop, but surely client and session variables are irrelevant for viewing pages of your shop catalogue? -Original Message- From: Nomad [mailto:[EMAIL

Solved: Client/Session Variable: When to set?

_engine_positioning_mistakes.php Thanks Ben - Original Message - From: Nomad [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, October 28, 2005 11:06 AM Subject: Client/Session Variable: When to set? Hello! Need to clear this up once and for all When is the best time to set session/client

WHAT'S WRONG WITH THIS QUERY?

Hello, This query works fine with Access. With SQL server it creates an error. Here's the query: UPDATE NewProduct INNER JOIN OldProduct ON NewProduct.dealerpartno = OldProduct.dealerpartno SET NewProduct.details = OldProduct.details Much appreciate any help in debuging. Thanks in

Re: WHAT'S WRONG WITH THIS QUERY?

WITH THIS QUERY? Did you try this (or something like it)? update newproduct set details = (select details from oldproduct where dealerpartno = newproduct.dealerpartno) cheers, barneyb On 10/19/05, Nomad [EMAIL PROTECTED] wrote: Hello, This query works fine with Access. With SQL server

Cold Fusion MX Adminstrator Error

Hi Guys, I am having problem accessing the CFMX administrator page. I am running Cold Fusion MX 7 with IIS5 on Win Professional 2000 on a standalone machine. It appears that both IIS and Cold Fusion Server are working fine. Can someone point out where and what the problem might be and how to fix

Track Visitor Country/City from IP address.

Hello all, A client of mine is having a hard time with credit card fraudstars placing orders with stolen cards. At this time the client is collecting IP address of every customer placing an order but is having to check each ip address manually to determine the source country. What is the easiest

Re: Track Visitor Country/City from IP address.

Thanks Hua, I am looking for something free (if available). Ben, You can take a look at this: http://www.maxmind.com/app/ccfd_features It has HTTP service, so could be implemented in colfusion pretty easily. Hua Ben Thomas

Re: CF Spider/Screen Scrape

not doing something illegal. Matt - Original Message - From: Nomad [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, September 05, 2005 7:05 PM Subject: Re: CF Spider/Screen Scrape Thanks. How do I get started with the monitoring service? Any pointers

CF Spider/Screen Scrape

Hello all, I have been asked by a client who operates an online shop to do the following: 1. Create a spider/crawler that will crawl and collect pricing information from a number of competitors sites. 2. Update the clients own database with the information collected undercutting the competitors

Re: CF Spider/Screen Scrape

the data automatically, just compiling it into a mail message with links and letting the client verify the prices by hand. So build a monitoring service. This would be a lot safer. Is what you want to do even legal? -Original Message- From: Nomad [mailto:[EMAIL PROTECTED] Sent

Re: SQL Query Help Please.

) AS amountDue, FROM (orders LEFT JOIN customerPayment ON customerPayment.orderID = orders.orderID) LEFT JOIN customer ON customer.customerID = orders.customerID Nomad wrote: The Database tables and fields are: Orders (orderid,customerid,Orderdate) OrderDetails(Orderid,UnitPrice,productid

SQL Query Help Please.

Hello! I am trying to create a join of four tables to get data from a db in the format I want. The Database tables and fields are: Orders (orderid,customerid,Orderdate) OrderDetails(Orderid,UnitPrice,productid,quantity) Customer(Customerid, customername, address)

Re: SQL Query Help Please.

Server! Nomad wrote: Hello! I am trying to create a join of four tables to get data from a db in the format I want. The Database tables and fields are: Orders (orderid,customerid,Orderdate) OrderDetails(Orderid,UnitPrice,productid,quantity) Customer(Customerid, customername

Cold Fusion to PDF

Hello All , I need some direction regarding custom tags/programsto convert CF / HTML to PDF for an invoicing application. I have found a couple of sources while googling but they seem to be pretty expensive. Does anyone know ofcheap/free alternative that I can use? Thanks in advance, Ben Thomas

VB6 Application, Cold Fusion Coral

Hello, Has anyone in this list usedCoral for parsing cfm files within distributed Visual basic applications? I am hoping to redesign an old Visual Basic (distributed application ) add lots of cfm templates and use Coral for parsing the cfm files. Has anyone done this sort ofodd job. Can I have

Problem with CFGRID

Hello! Can some one please tell me what is wrong with this tag? CFIF CGI.REQUEST_METHOD IS POST CFGRIDUPDATEDatasource=SomeDatasource tablename=SomeTablename Grid=ActorGrid /CFIF The error on the action page reads like this: CFGRIDUPDATECANNOT FIND the GRID named ActorGrid My Grid Page is working

Re: SQL Question SOLVED

Thanks People. You Guys are Awesome. All the solutions work. ButMikes solution seems to me the most appropriate in my scenario. Regards, SB - Original Message - From: Mickael [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, December 05, 2003 10:34 AM Subject: Re: SQL