Hello all!
This is probably easy stuff for most.
How do I handle null values in the source csv file when importing into db.
The following lines of code work only when there is no null value in the
source file.
Also how do I handle commas that are in the data itself.
Is there a custom tag or cf base
> I think that's going to have to be done in CF.
>
> andy matthews
> web developer
> ICGLink, Inc.
> [EMAIL PROTECTED]
> 615.370.1530 x737
> --//->
>
> -Original Message-
> From: Nomad [mailto:[EMAIL PROTECTED]
> Sent: Thursday,
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
2
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 cou
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 cou
_10_search
_engine_positioning_mistakes.php
Thanks
Ben
- Original Message -----
From: "Nomad" <[EMAIL PROTECTED]>
To: "CF-Talk"
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 i
; search engine bot is never 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?
>
> --
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 adv
ONG 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 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 advance.
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
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
~~~
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
> described...but
> again...scraping can be something you can get into trouble with so I'd
> check
> into seeing if your not doing something illegal.
>
> Matt
>
>
> - Original Message -
> From: "Nomad" <[EMAIL PROTECTED]>
> To: &
e?
>
> I would recommend, instead of changing 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?
>
> -
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
)
>LEFT JOIN customer
> ON customer.customerID = orders.customerID
>
> Nomad wrote:
>
> > > > The Database tables and fields are:
> > > > Orders (orderid,customerid,Orderdate)
> > > > OrderDetails(Orderid,UnitPrice
> Expert Hosting for less!
> *Ask for a free 30 day trial!*
> http://exciteworks.com
>
> Plans starting at -$12.95- including MS SQL Server!
>
>
>
>
> Nomad wrote:
>
> > Hello!
> >
> > I am trying to create a join of four tables to get data from a db
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)
CustomerPayments(orderid,PaymentR
Hello All ,
I need some direction regarding custom tags/programs to 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 of cheap/free alternative that I can use?
Thanks in advance,
Ben Tho
Hello,
Has anyone in this list used Coral 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 of odd job.
Can I have
Hello!
Can some one please tell me what is wrong with this tag?
The error on the action page reads like this:
"CFGRIDUPDATE CANNOT FIND the GRID named ActorGrid"
My Grid Page is working fine with the applet behaving exactly how it should.
I have changed the Grid name in both pages several tim
Thanks People.
You Guys are Awesome.
All the solutions work. But Mikes 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: S
23 matches
Mail list logo