Import CSV file
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 based utility that does all that which I can
execute from a cf template?
Codes that work only when the source file has no null fields or commas:
INSERT INTO Table1
(modelno,details,dealerpartno,rrp,costprice,brand,subcategory)
VALUES
('#listgetAt('#index#',1, ',')#',
'#listgetAt('#index#',2, ',')#',
'#listgetAt('#index#',3, ',')#',
'#listgetAt('#index#',4, ',')#',
'#listgetAt('#index#',5, ',')#',
'#listgetAt('#index#',6, ',')#',
'#listgetAt('#index#',7)#'
)
Mush appreciate any help.
Thanks heaps.
Ben.
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236278
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Group Query help.
Hi Bobby, I am using SQl Server 2000. Ben Sorry for the delay in my reply. - Original Message - From: "Bobby Hartsfield" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Friday, December 16, 2005 3:34 AM Subject: RE: Group Query help. > The only thing I can think of off the top of my head that MIGHT be able to > help is 'LIMIT' in MySQL... even then I THINK you can only use that at the > end of a query. But with nested selects, you might come up with something. > > What type of database are you using? That might trigger the brain of some > SQL gurus around here... but I'm afraid it's something that you're probably > not going to get done in a single query. > > ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. > Bobby Hartsfield > http://acoderslife.com > > > -Original Message- > From: Andy Matthews [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 15, 2005 9:21 AM > To: CF-Talk > Subject: RE: Group Query help. > > I'm no SQL expert but I don't know if what you're describing is possible. > > Retrieve a max of 5 rows for each group in the database. > > 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, 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 pid, Details, Brand from Products group by brand order by price > > This query returns: > > pid Details Brand > 1abcdMacromedia > 2efgh Macromedia > 3efgh Corel > 4abcf Corel > 5errerAdobe > > etc etc. > > What I want to achieve is to limit the max number of rows returned per group > to say 5. > So if there are 10 Macromedia products in my db only 5 rows would show up. > Please note that my aim is not to limit the total number of rows returned > with a Top statement or similar. > > Thanks in advance. > > Ben > > > > > > > Logware (www.logware.us): a new and convenient web-based time tracking > application. Start tracking and documenting hours spent on a project or with > a client with Logware today. Try it for free with a 15 day trial account. > > http://www.houseoffusion.com/banners/view.cfm?bannerid=67 > > > > Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221634 > > Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 > > Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 > > Unsubscribe: > http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11639.10644.4 > > Donations & Support: http://www.houseoffusion.com/tiny.cfm/54 > > > > > > > > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227112 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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 2efgh Macromedia 3efgh Corel 4abcf Corel 5errerAdobe etc etc. What I want to achieve is to limit the max number of rows returned per group to say 5. So if there are 10 Macromedia products in my db only 5 rows would show up. Please note that my aim is not to limit the total number of rows returned with a Top statement or similar. Thanks in advance. Ben > Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. > http://www.houseoffusion.com/banners/view.cfm?bannerid=67 > > Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221634 > Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 > Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 > Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11639.10644.4 > Donations & Support: http://www.houseoffusion.com/tiny.cfm/54 > ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227075 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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 could not find any that works with words (not characters). I am obviously missing something. What is it? Thanks a lot. Ben > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225129 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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 could not find any that works with words (not characters). I am obviously missing something. What is it? Thanks a lot. Ben ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225124 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Solved: Client/Session Variable: When to set?
Hello Googled with the keywords "session variables and search engine ranking" http://uglyduckling.net.au/web-designer-pitfalls.html http://www.seomoz.org/articles/search-ranking-factors.php#5 http://www.livingroom.org.au/searchengineoptimization/archives/top_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 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 advance.. > > Ben > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222523 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Client/Session Variable: When to set?
Hi Matthew, Client/ session variables are not required to view pages .. it is being used for managing the shopping cart. The question is when to set it. I can set it up in the application.cfm page or the cart page. I am told setting it in the application.cfm page could hurt google rankings. I may sound stupid: spiders bots can detect whether or not session/client variables has been set. I am certain about this. I have seen google links to some items on the website that actually included the session id/ Cfid tokens. Consequently the site ranking was poor. Just wanted to clarify that. Ben - Original Message - From: "Matthew Walker" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Friday, October 28, 2005 11:38 AM Subject: RE: Client/Session Variable: When to set? > By "Application page" do you mean Application.cfm? If you do, then the > 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? > > -Original Message- > From: Nomad [mailto:[EMAIL PROTECTED] > Sent: Friday, 28 October 2005 11:31 a.m. > To: CF-Talk > 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 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. > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222503 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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 advance.. Ben ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222495 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: WHAT'S WRONG WITH THIS QUERY?
Thanks Barney, This one works. But wonder why the other one doesn't. Thought it would be good to know. Ben - Original Message - From: "Barney Boisvert" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Thursday, October 20, 2005 12:22 PM Subject: Re: WHAT'S WRONG 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. > > > > Ben > > > > -- > Barney Boisvert > [EMAIL PROTECTED] > 360.319.6145 > http://www.barneyb.com/ > > Got Gmail? I have 100 invites. > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221579 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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 advance. Ben ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221574 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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 it? I have tried uninstalling and reinstalling CFMX but the problem still exists. Thanks in advance Ben The error message is: Error Occured while Processing Request. java.lang.NoClassDefFoundError at javax.crypto.Cipher.getInstance([DashoPro-V1.2-120198]) at coldfusion.compiler.TemplateReader.decrypt(Unknown Source) at coldfusion.compiler.TemplateReader.(Unknown Source) at coldfusion.compiler.NeoTranslationContext.getPageReader(Unknown Source) at coldfusion.compiler.NeoTranslator.translateJava(Unknown Source) at coldfusion.compiler.NeoTranslator.translateJava(Unknown Source) at coldfusion.runtime.TemplateClassLoader$1.fetch(Unknown Source) at coldfusion.util.LruCache.get(Unknown Source) at coldfusion.runtime.TemplateClassLoader$TemplateCache.fetchSerial(Unknown Source) at coldfusion.util.AbstractCache.fetch(Unknown Source) at coldfusion.util.SoftCache.get(Unknown Source) at coldfusion.runtime.TemplateClassLoader.findClass(Unknown Source) at coldfusion.filter.PathFilter.invoke(Unknown Source) at coldfusion.filter.LicenseFilter.invoke(Unknown Source) at coldfusion.filter.ExceptionFilter.invoke(Unknown Source) at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source) at coldfusion.filter.BrowserFilter.invoke(Unknown Source) at coldfusion.filter.GlobalsFilter.invoke(Unknown Source) at coldfusion.filter.DatasourceFilter.invoke(Unknown Source) at coldfusion.CfmServlet.service(Unknown Source) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220775 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219029 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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 way to track country / city from customer ip address programmatically in real time with CF? Thanks in advance, Ben Thomas ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219025 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Spider/Screen Scrape
Many Thanks. Ben - Original Message - From: "Matthew Walker" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Tuesday, September 06, 2005 3:38 PM Subject: RE: CF Spider/Screen Scrape > This may help, but you need to be able to use regular expressions > http://www.eswsoftware.com/library/scraping.cfm > > > -Original Message- > From: Matthew Blatchley [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 6 September 2005 12:45 p.m. > To: CF-Talk > Subject: Re: CF Spider/Screen Scrape > > First you might want to start by having permission from the site owner > of > the page your scraping which isn't as easy as a phone call :) > > I would use and then search through the page for the specific > name > of the products your looking for and the price. It's a lot easier to > scrape > a page that isn't dynamically generated because it probably won't change > > from one day to the next. You'll need to use some pretty fancy Regular > expressions to get it work for each page you scrape. Once the data is > collected, send out the email with link to update as Matthew > 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: "CF-Talk" > 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? > > > > Ben > > > > - Original Message - > > From: "Matthew Walker" <[EMAIL PROTECTED]> > > To: "CF-Talk" > > Sent: Tuesday, September 06, 2005 12:10 PM > > Subject: RE: CF Spider/Screen Scrape > > > > > >> Yes you can do this in CF, but... > >> > >> Screen scraping is very fragile. It can be useful, but I wouldn't > >> recommend attaching it to a live database. Your competitors could > change > >> their template and then suddenly you're selling your products for > $0.00. > >> Will you as the developer be liable? > >> > >> 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? > >> > >> -Original Message- > >> From: Nomad [mailto:[EMAIL PROTECTED] > >> Sent: Tuesday, 6 September 2005 12:01 p.m. > >> To: CF-Talk > >> Subject: 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 by few cents/dollars. > >> > >> Can Cold Fusion do this? > >> Can someone provide some pointers for me to get started. > >> I understand that this is not an easy beast to tame. > >> Is there any ready made solution that I can integrate with the > clients > >> website (CF based). > >> > >> Will appreciate any help. > >> > >> Thanks > >> > >> Ben Thomas. > >> > >> > >> > >> > >> > > > > > > > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217508 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Spider/Screen Scrape
Thanks. How do I get started with the monitoring service? Any pointers? Ben - Original Message - From: "Matthew Walker" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Tuesday, September 06, 2005 12:10 PM Subject: RE: CF Spider/Screen Scrape > Yes you can do this in CF, but... > > Screen scraping is very fragile. It can be useful, but I wouldn't > recommend attaching it to a live database. Your competitors could change > their template and then suddenly you're selling your products for $0.00. > Will you as the developer be liable? > > 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? > > -Original Message- > From: Nomad [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 6 September 2005 12:01 p.m. > To: CF-Talk > Subject: 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 by few cents/dollars. > > Can Cold Fusion do this? > Can someone provide some pointers for me to get started. > I understand that this is not an easy beast to tame. > Is there any ready made solution that I can integrate with the clients > website (CF based). > > Will appreciate any help. > > Thanks > > Ben Thomas. > > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217404 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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 by few cents/dollars. Can Cold Fusion do this? Can someone provide some pointers for me to get started. I understand that this is not an easy beast to tame. Is there any ready made solution that I can integrate with the clients website (CF based). Will appreciate any help. Thanks Ben Thomas. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217398 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL Query Help Please.
Thanks Umer & Others, You guys have been of great help. Will try the query today.. Regards, Mark - Original Message - From: "Umer Farooq" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 11, 2004 8:17 PM Subject: Re: SQL Query Help Please. > Here you.. go.. returns.. orderId, date, customerId, customer name, > paymentReceived, amount due (per order)... , > > > SELECT orders.orderId, order.orderDate, orders.customerID, >customers.customerName, customerPayment.PaymentReceived >(SELECT sum(unitPrice * quantity) > FROM orderDetails > WHERE orderDetails.orderID = orders.orderID ) 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,quantity) > > > > Customer(Customerid, customername, address) > > > > CustomerPayments(orderid,PaymentReceived) > > > > > > > > My purpose is to track the account status of the customer for each > > order > > > > they have placed. > > > > > > > > The desired format of result obtained from the query is like this: > > > > > > > > Customername, Orderid, Orderdate,AmountReceived, AmountDue(this is a > > > > calculated column). > > > -- > Umer Farooq > Octadyne Systems > [EMAIL PROTECTED] > +1 (519) 772-5424 voice > +1 (519) 635-2795 mobile > +1 (208) 275-3824 fax > > > LOOKING FOR A USED CAR IN IOWA VISIT: http://www.IowaMotors.com > > > WARNING: --- The information contained in > this document and attachments is confidential and intended only for the > person(s) named above. If you are not the intended recipient you are > hereby notified that any disclosure, copying, distribution, or any other > use of the information is strictly prohibited. If you have received > this document by mistake, please notify the sender immediately and > destroy this document and attachments without making any copy of any kind. > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL Query Help Please.
Hi Josh, Thanks for your reply. Your query is similar to what I have been trying. My query is: SELECT customer.Customercompanyname, orders.Orderid, orders.Orderdate, (Orderdetails.unitprice * Orderdetails.quantity) As OrderValue, CustomerPayments.PRIG As PaymentsReceived FROM Orders , OrderDetails, Customer, CustomerPayments WHERE 0=0 AND Orderdetails.orderid=Orders.orderid AND CustomerPayments.orderid=Orders.orderid AND Orders.customerid=Customer.customerid The result is something like this which is wrong: Notice the repetition of the OrderId field. Ideally there should be one row for each order. Customer Name OrderID, OrderDate, OrderValue Payments Received. Company 1 1 11/10/2004 55 500 Company 1 1 11/10/2004 31898 500 Company 1 1 11/10/20045678 500 Company5 4 11/10/20042320 400 Company5 4 11/10/20044740 400 Company5 4 11/10/2004 26400 400 Company5 4 11/10/2004544600 400 - Original Message - From: "Josh" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 11, 2004 6:07 PM Subject: Re: SQL Query Help Please. > Here's a start, though you'll have to explain your tables and your > calculations further. > > SELECT > c.Customername, > a.Orderid, > a.Orderdate, > ( where is this being stored? AmountReceived maybe this could be > d.PaymentReceived AS AmountReceived ? ), > ( put your formula for calculating AmountDue here, possibly a subquery ) > FROM Orders a, OrderDetails b, Customer c, CustomerPayments d > WHERE a.orderid = b.orderid > AND a.orderid = d.orderid > AND c.customerid = a.customerid > > Hope that helps some... > > I would recomend the SQL book by forta, or just look online for a good > tutorial. > > -Josh > > -- > Exciteworks, Inc > 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 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,PaymentReceived) > > > > My purpose is to track the account status of the customer for each order > > they have placed. > > > > The desired format of result obtained from the query is like this: > > > > Customername, Orderid, Orderdate,AmountReceived, AmountDue(this is a > > calculated column). > > > > I am using Access 2000 with CFusion. > > > > 1.)Can someone help me with the SQL syntax please. I have tried several > > permutations and combinations of sql (to the best of my knowledge) but > > without success. > > 2.) Can someone please suggest a good book on SQL syntax that will clear > > thing up for me. > > > > Many Thanks in Advance, > > > > Mark Taylor > > Admin > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
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) CustomerPayments(orderid,PaymentReceived) My purpose is to track the account status of the customer for each order they have placed. The desired format of result obtained from the query is like this: Customername, Orderid, Orderdate,AmountReceived, AmountDue(this is a calculated column). I am using Access 2000 with CFusion. 1.)Can someone help me with the SQL syntax please. I have tried several permutations and combinations of sql (to the best of my knowledge) but without success. 2.) Can someone please suggest a good book on SQL syntax that will clear thing up for me. Many Thanks in Advance, Mark Taylor Admin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Cold Fusion to PDF
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 Thomas [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
VB6 Application, Cold Fusion & Coral
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 some feedback please? I am particularly interested with issues relating to packaging, deployment and distribution within one singleapplication. Thanks in advance Ben Thomas [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Problem with CFGRID
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 times to see if it makes any difference. None at all. Wondering if this is a bug. I am on CFMX without the Updater. Has anyone faced similar problem?. Any help would be much appreciated. Regards, SB [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Question SOLVED
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: SQL Question > Hi, > > I am not sure if you can add a column or not, but a simple way to do it if you can add a column is create a column called TempCol or something > > Then > > Update TopStudents set tempcol = left(topstudents.studentdetails, len(topstudents.studentdetails)-12) 12 being the number of charters after the name > > > > Then your are left with just the names in tempcol > > then update the corrected name back to the original column > > update topstudents set studentdetails = topstudents.tempcol > > You can do this right in the query window in access, don't need CF > > Do it on a copy of the DB first. > - Original Message - > From: Srimanta B > To: CF-Talk > Sent: Thursday, December 04, 2003 2:53 PM > Subject: 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" 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]
