Deleting Image
Can anyone help with this error? I know the file exists in that location however I'm not able to thumbnail pics that are uploaded nor am I able to delete the images, This is the error when trying to remove an image. The destination "C:\Inetpub\voremarketing\zimages\uploadedItemImages\wyb.gif" specified in the CFFILE tag is invalid. The destination either does not exist or is not accessible by this tag. The error occurred in C:\Inetpub\voremarketing\admin\inventory\updateInventory\updateInventory_Images_action.cfm: line 76 Called from C:\Inetpub\voremarketing\admin\inventory\updateInventory\updateInventory_Images_action.cfm: line 57 Called from C:\Inetpub\voremarketing\admin\inventory\updateInventory\updateInventory_Images_action.cfm: line 1 DELETE FROM tblItemImages WHERE itemImageID = #itemImageID# Web Your Business Inc., - located in Loveland, Colorado; serving the World! http://www.webyourbusiness.com/ - & - http://www.aaabusinesshosting.com/ Phone: 970-593-6260 - Fax: 970-593-6267 - Toll Free: 1-877-416-8655 ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188574 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
Total Sales Menu
The following code is from a menu on a site that shows the monthly/quarterly/yearly goal and sales the goal part is working fine but since switching from access to mysql the currently month/quarter/year sales isn't being calulated. SELECT Sum(tblItemPurchase.itemPurchasePrice) AS totalMonthlyPurchase FROM tblItemPurchase WHERE tblItemPurchase.itemPurchaseDate >= '#theMonth#/#1#/#theYear#' GOALS THIS MONTH: GOAL:#DollarFormat(theGoal)#. SO FAR:#DollarFormat(getMonthlyPurchase.totalMonthlyPurchase)# TO GO:#DollarFormat(amountLeft)# SELECT Sum(tblItemPurchase.itemPurchasePrice) AS totalMonthlyPurchase FROM tblItemPurchase WHERE tblItemPurchase.itemPurchaseDate >= '#startMonth#/1/#theYear#' AND tblItemPurchase.itemPurchaseDate <= '#endMonth#/#endDay#/#theYear#'
Re: No Thumbnails
Removed the * deleting images still errors out and when uploading images it still fails to create the thumbnail I'll just continue taking it 1 steo at a time, Thanx for everyone who has helped me fix these small yet important issues and thank you all for the security suggestions. At 03:03 PM 12/21/2004, you wrote: >In MySQL, you have to remove the "*" for DELETE to work. > > >On Tue, 21 Dec 2004 13:50:57 -0800, Bryan Stevenson ><[EMAIL PROTECTED]> wrote: > > NOt sure about MySQL, but in MS SQL you use "DELETE FROM..." and not what > > you have "DELETE * FROM..." > > > > I don't see any reason why the "*" would be needed, because all deletes > > delete the entire record > > > > HTH > > > > BTW...look into CFQUERYPARAM...it will help stop SQL injection attacks > > (among many other useful things it does). You have IDs coming via the URL > > and you currently do not check to see if they are valid values. Someone > > could theorhetically pass a DROP ALL statement in place of a normal ID > value > > and toast your database!!! Merry Ho Ho huh ;-) > > > > Cheers > > > > Bryan Stevenson B.Comm. > > VP & Director of E-Commerce Development > > Electric Edge Systems Group Inc. > > phone: 250.480.0642 > > fax: 250.480.1264 > > cell: 250.920.8830 > > e-mail: [EMAIL PROTECTED] > > web: www.electricedgesystems.com > > - Original Message - > > From: "Jason Smith" <[EMAIL PROTECTED]> > > To: "CF-Talk" > > Sent: Tuesday, December 21, 2004 1:24 PM > > Subject: No Thumbnails > > > > > Well after debugging some code I have come across more image problems > > > mainly to deal with uploading the images. The code is fairly long I'll > > > post > > > a sniplet of it and if anyone needs anymore I'll be happy to get more. > > > > > > I'm attempting to upload a image file while deleting another image file. > > > After the deleting and uploading the thumb nailing is next to take place > > > at > > > the current state of the application it's bombing out on the upload. > > > > > > > > > > > > > > > > > throwontimeout="no"> > > > > > > > > > > > > > > > > > > SELECT itemImageID, itemImageURL > > > FROM tblItemImages > > > WHERE itemID = #URL.itemID# > > > > > > > > > > > > > > > > > > > > > > > action="delete" > > > > > > file="#Request.RootSystemPath#zimages\uploadedItemImages\#itemImageURL#"> > > > > > > > > > DELETE * > > > FROM tblItemImages > > > WHERE itemImageID = #itemImageID# > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > i))> > > > > > action="UPLOAD" > > > > > > filefield="attachment#i#" > > > > > > destination="#Request.RootSystemPath#zimages\uploadedItemImages\" > > > > > > > > > nameconflict="MAKEUNIQUE" > > > > > > accept="image/pjpeg, > > > image/jpeg, image/PJPEG, image/JPEG, image/pgif, image/gif, image/PGIF, > > > image/GIF, image/jpg"> > > > > > > > > > > > > The Error: > > > > > > Syntax error or access violation: You have an error in your SQL syntax. > > > Check the manual that corresponds to your MySQL server version for the > > > right syntax to use near '* FROM tblItemImages WHERE itemImag
No Thumbnails
Well after debugging some code I have come across more image problems mainly to deal with uploading the images. The code is fairly long I'll post a sniplet of it and if anyone needs anymore I'll be happy to get more. I'm attempting to upload a image file while deleting another image file. After the deleting and uploading the thumb nailing is next to take place at the current state of the application it's bombing out on the upload. SELECT itemImageID, itemImageURL FROM tblItemImages WHERE itemID = #URL.itemID# DELETE * FROM tblItemImages WHERE itemImageID = #itemImageID# The Error: Syntax error or access violation: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM tblItemImages WHERE itemImageID = 6355' at lin The error occurred in C:\Inetpub\voremarketing\admin\inventory\updateInventory\updateInventory_Images_action.cfm: line 81 Line 78-82 DELETE * FROM tblItemImages WHERE itemImageID = #itemImageID# I'm baffled by the error itemImageID 6355 is in the database and exists. Web Your Business Inc., - located in Loveland, Colorado; serving the World! http://www.webyourbusiness.com/ - & - http://www.aaabusinesshosting.com/ Phone: 970-593-6260 - Fax: 970-593-6267 - Toll Free: 1-877-416-8655 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188474 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: Image Thumbnails
Being that I'm pretty new to cold fusion and did not code the site originally I am just maintaining it now and updating the data source. I don't know all the ins and outs of cf yet still learning them. http://www.voremarketing.com/home/ If you take a look at that site you will see that the top 5 newest items have no thumbnail image I don't know where the problem is coming from but I was starting the troubleshooting at the display level first seemed to be the easiest code to decipher. Thanx for the date/time correction no telling how long it's been backwards. At 01:13 PM 12/21/2004, you wrote: >Well, the date/time stuff is backwards. TheTime uses Dateformat and >theDate uses Timeformat. You didn't really give much other details as >to what doesn't work. View the source and see what the path for the >images is and compare it to what the image path should be, then make the >necessary changes. Check the variable of request.relRootPath and make >sure that's what it should be. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188459 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
Image Thumbnails
I have a piece of code that works fine but from the switch from access to mysql now a lot of the images do not display. SELECT itemID, itemName, itemKeywords, itemThumbnail FROM tblItem, tblkItemStatus WHERE tblItem.itemStatusID = tblkItemStatus.itemStatusID AND tblkItemStatus.itemStatusMainID = 2 ORDER BY dataEntryDate DESC, dataEntryTime DESC LIMIT 5 #iCount# #itemName# Can anyone just scan over that code for me my eyes can't find any problems but where a image should be loading if you right click and check properties the image name isn't showing up. Now since this is just the code to display the top 5 items I'm assuming this error could be anywhere between the adding of the image file to the thumb nailing of the image. ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188452 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: Date Issues
That is a very helpful piece of code right there MYSQL is outputting the date - 2012-07-20 04:00:00.0 and of course the original writer of the cf app has MM/DD/ as the output in his code. Now I'm assuming I can just change the output format on all 48 pages that use it and I should be good to go, anything else I might need to watch out for? At 12:13 PM 12/21/2004, you wrote: >try: > > >above the code you've written. >Paste the output exactly. > > > >On Tue, 21 Dec 2004 14:04:40 -0500, Burns, John D ><[EMAIL PROTECTED]> wrote: > > Are you sure that's not the date that it's feeding in? Are you positive > > your date format is written correctly. I looks like 2012 is coming up > > for December which leads me to believe that it's reading in MM/DD/YY and > > it thinks it's coming in as YY/MM/DD. Are you sure you're using the > > 4-digit year and that you've tried it as /MM/DD? That was what had > > solved it for me. > > > > > > John Burns > > Certified Advanced ColdFusion MX Developer > > AI-ES Aeronautics, Web Developer > > > > -Original Message- > > From: Jason Smith [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, December 21, 2004 1:58 PM > > To: CF-Talk > > Subject: RE: Date Issues > > > > I tried that in the beginning thinking it might have something to do > > with it. But all that does is reverse the date 2012/07/20 what I really > > can't figure out is where it could possibly be pulling that date from. > > > > At 11:54 AM 12/21/2004, you wrote: > > >I know when I was using MySQL, it used the dateformat of /MM/DD > > >instead of MM/DD/YYYY. You may need to fix your dateFormat to display > > >that correctly. > > > > > > > > >John Burns > > >Certified Advanced ColdFusion MX Developer AI-ES Aeronautics, Web > > >Developer > > > > > >-Original Message- > > >From: Jason Smith [mailto:[EMAIL PROTECTED] > > >Sent: Tuesday, December 21, 2004 1:48 PM > > >To: CF-Talk > > >Subject: Date Issues > > > > > >Can anyone narrow down what the problem might be: > > > > > >The site I'm working on was built for access, I ported it to mysql > > >after making all the needed changes for date stamps and anything else > > >incompatible I have a new issue that seems to be random. When updating > > >an Item via the administration application I have: > > > > > > > > >*Item Date Received: > > > > > > > > > > >'MM/DD/')#> > > > > > > > > > > > > > > > > > > > > > *Item Date > > >Received: > > > > >style="color:gray;">#DR# > >type="text" name="itemDateRecieved" class="formBox" > > >value="#DR#"> > >class="small">MM/DD/ > > > > > > > > >Now when you update an item everything runs fine and seems to update > > >but on certain items dates are still fouled up. One in particular I'm > > >working on is always showing date 07/20/2012 and refuses to take > > >anything else. Now could anyone tell me is this a cf problem or > > >possibly a problem with the data field? > > > > > > > > > > > > > > > > > > > > > > > > ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188445 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: Date Issues
Well I didn't originally code the application but with a full search I don't come across any dates being called like that however In phpmyadmin I just checked to see the date format which is -MM-DD 00:00:00 so I'm starting to wonder if I need to redo all the date statments to display the same format as mysql. It seems to me like it's just storing and retrieving the date wrong. At 12:04 PM 12/21/2004, you wrote: >Are you sure that's not the date that it's feeding in? Are you positive >your date format is written correctly. I looks like 2012 is coming up >for December which leads me to believe that it's reading in MM/DD/YY and >it thinks it's coming in as YY/MM/DD. Are you sure you're using the >4-digit year and that you've tried it as /MM/DD? That was what had >solved it for me. > > >John Burns >Certified Advanced ColdFusion MX Developer >AI-ES Aeronautics, Web Developer > >-Original Message- >From: Jason Smith [mailto:[EMAIL PROTECTED] >Sent: Tuesday, December 21, 2004 1:58 PM >To: CF-Talk >Subject: RE: Date Issues > >I tried that in the beginning thinking it might have something to do >with it. But all that does is reverse the date 2012/07/20 what I really >can't figure out is where it could possibly be pulling that date from. > > >At 11:54 AM 12/21/2004, you wrote: > >I know when I was using MySQL, it used the dateformat of /MM/DD > >instead of MM/DD/. You may need to fix your dateFormat to display > >that correctly. > > > > > >John Burns > >Certified Advanced ColdFusion MX Developer AI-ES Aeronautics, Web > >Developer > > > >-Original Message- > >From: Jason Smith [mailto:[EMAIL PROTECTED] > >Sent: Tuesday, December 21, 2004 1:48 PM > >To: CF-Talk > >Subject: Date Issues > > > >Can anyone narrow down what the problem might be: > > > >The site I'm working on was built for access, I ported it to mysql > >after making all the needed changes for date stamps and anything else > >incompatible I have a new issue that seems to be random. When updating > >an Item via the administration application I have: > > > > > >*Item Date Received: > > > > > > >'MM/DD/')#> > > > > > > > > > > > > > > *Item Date > >Received: > > >style="color:gray;">#DR# >type="text" name="itemDateRecieved" class="formBox" > >value="#DR#"> >class="small">MM/DD/ > > > > > >Now when you update an item everything runs fine and seems to update > >but on certain items dates are still fouled up. One in particular I'm > >working on is always showing date 07/20/2012 and refuses to take > >anything else. Now could anyone tell me is this a cf problem or > >possibly a problem with the data field? > > > > > > > > > > > > > > > > ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188438 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: Date Issues
I tried that in the beginning thinking it might have something to do with it. But all that does is reverse the date 2012/07/20 what I really can't figure out is where it could possibly be pulling that date from. At 11:54 AM 12/21/2004, you wrote: >I know when I was using MySQL, it used the dateformat of /MM/DD >instead of MM/DD/. You may need to fix your dateFormat to display >that correctly. > > >John Burns >Certified Advanced ColdFusion MX Developer >AI-ES Aeronautics, Web Developer > >-Original Message- >From: Jason Smith [mailto:[EMAIL PROTECTED] >Sent: Tuesday, December 21, 2004 1:48 PM >To: CF-Talk >Subject: Date Issues > >Can anyone narrow down what the problem might be: > >The site I'm working on was built for access, I ported it to mysql after >making all the needed changes for date stamps and anything else >incompatible I have a new issue that seems to be random. When updating >an Item via the administration application I have: > > >*Item Date Received: > > > 'MM/DD/')#> > > > > > > > *Item Date >Received: > style="color:gray;">#DR#type="text" name="itemDateRecieved" class="formBox" >value="#DR#"> class="small">MM/DD/ > > >Now when you update an item everything runs fine and seems to update but >on certain items dates are still fouled up. One in particular I'm >working on is always showing date 07/20/2012 and refuses to take >anything else. Now could anyone tell me is this a cf problem or possibly >a problem with the data field? > > > > > > ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188427 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
Date Issues
Can anyone narrow down what the problem might be: The site I'm working on was built for access, I ported it to mysql after making all the needed changes for date stamps and anything else incompatible I have a new issue that seems to be random. When updating an Item via the administration application I have: *Item Date Received: *Item Date Received: #DR# MM/DD/ Now when you update an item everything runs fine and seems to update but on certain items dates are still fouled up. One in particular I'm working on is always showing date 07/20/2012 and refuses to take anything else. Now could anyone tell me is this a cf problem or possibly a problem with the data field? ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188424 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: Datestamp
Disregard that I realized when I was fixing the page I added and extra '
Problem solved thank you I'll see if the report now shows the correct date
on submission.
At 02:35 PM 12/20/2004, you wrote:
>Sorry about that. You use CFQUERYPARAM to wrap the values you pass
>into your query. So instead of this;
>
>INSERT INTO myTable
> (agent,
>dateEntered,
>timeEntered
> )
>VALUES
> ('WEB USER',
>'#theDate#',
>'#theTime#'
> )
>
>you'd do this:
>
>INSERT INTO myTable
> (agent,
>dateEntered,
>timeEntered
> )
>VALUES
> ('WEB USER',
>,
>
> )
>
>CFQUERYPARAM is your friend. Use it everywhere. It saves enormous
>hassles, and helps protect you.
>
>cheers,
>barneyb
>
>On Mon, 20 Dec 2004 13:54:24 -0700, Jason Smith
><[EMAIL PROTECTED]> wrote:
> > I've been reading about CFQUERYPARAM
> > to see where this needs to be inserted to fix my date problem but I am
> > new to CF and I'm most likely overlooking a simple solution can anyone
> > pointme in the right direction or a site that has some better tutorial type
> > information about storing date/time stamps correctly?
> >
>
>--
>Barney Boisvert
>[EMAIL PROTECTED]
>360.319.6145
>http://www.barneyb.com/blog/
>
>
~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188336
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: Datestamp
Now when attempting to submit an offer I get new errors ones I'm not
particularly familiar with.
The cause of this output exception was that:
coldfusion.runtime.Cast$DateStringConversionException: The value
"'14:55:43" could not be converted to a date..
The error occurred in C:\Inetpub\voremarketing\zincludes\offerForm.cfm: line 61
Called from C:\Inetpub\voremarketing\search\itemDetail.cfm: line 130
Called from C:\Inetpub\voremarketing\search\itemDetail.cfm: line 118
Called from C:\Inetpub\voremarketing\search\itemDetail.cfm: line 78
Called from C:\Inetpub\voremarketing\search\itemDetail.cfm: line 1
Called from C:\Inetpub\voremarketing\zincludes\offerForm.cfm: line 61
Called from C:\Inetpub\voremarketing\search\itemDetail.cfm: line 130
Called from C:\Inetpub\voremarketing\search\itemDetail.cfm: line 118
Called from C:\Inetpub\voremarketing\search\itemDetail.cfm: line 78
Called from C:\Inetpub\voremarketing\search\itemDetail.cfm: line 1
59 :'WEB USER',
60 :,
61 :)
62 :
63 :
At 02:35 PM 12/20/2004, you wrote:
>Sorry about that. You use CFQUERYPARAM to wrap the values you pass
>into your query. So instead of this;
>
>INSERT INTO myTable
> (agent,
>dateEntered,
>timeEntered
> )
>VALUES
> ('WEB USER',
>'#theDate#',
>'#theTime#'
> )
>
>you'd do this:
>
>INSERT INTO myTable
> (agent,
>dateEntered,
>timeEntered
> )
>VALUES
> ('WEB USER',
>,
>
> )
>
>CFQUERYPARAM is your friend. Use it everywhere. It saves enormous
>hassles, and helps protect you.
>
>cheers,
>barneyb
>
>On Mon, 20 Dec 2004 13:54:24 -0700, Jason Smith
><[EMAIL PROTECTED]> wrote:
> > I've been reading about CFQUERYPARAM
> > to see where this needs to be inserted to fix my date problem but I am
> > new to CF and I'm most likely overlooking a simple solution can anyone
> > pointme in the right direction or a site that has some better tutorial type
> > information about storing date/time stamps correctly?
> >
>
>--
>Barney Boisvert
>[EMAIL PROTECTED]
>360.319.6145
>http://www.barneyb.com/blog/
>
>
~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188335
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: Datestamp
I've been reading about CFQUERYPARAM to see where this needs to be inserted to fix my date problem but I am new to CF and I'm most likely overlooking a simple solution can anyone pointme in the right direction or a site that has some better tutorial type information about storing date/time stamps correctly? At 12:53 PM 12/20/2004, you wrote: >Use CFQUERYPARAM and your problems will vanish. MySQL is picky about >using strings as date literals, so it's getting screwed up. CF >formats the default MySQL date value (-00-00 00:00:00) as 11/30/02 >for some reason. If you look in the DB, it'll be all zeros though. > >cheers, >barneyb > >On Mon, 20 Dec 2004 12:44:37 -0700, Jason Smith ><[EMAIL PROTECTED]> wrote: > > After switching a cold fusion application from an access database to mysql > > I have some strange problems that I am not 100% sure on. Image issues no > > thumbnails showing up I assume it's related to the original storage > > location of the images. However one issue I can't seem to correct and has > > me stumped there is a time/date stamp that is recorded anytime a bid for an > > item is submitted. In access this was working fine no issues and no > > problems what so ever. Under mysql this snip of code. > > > > TIME: #TimeFormat(now(), 'HH:MM:SS')# > > DATE: #DateFormat(now(), 'MM/DD/')# > > > > > > > > Please do not respond to this > email. > > > > > > > > > > > > > > INSERT INTO tblItemNotes > > (itemID, > > itemStatusID, > > itemListPrice, > > locationID, > > itemNotes, > > agent, > > dateEntered, > > timeEntered) > > VALUES > > (#getItemDetail.itemID#, > > #getItemDetail.itemStatusID#, > > #getItemDetail.itemListPrice#, > > #getItemDetail.locationID#, > > 'OFFER SUBMITTED > > BY: #form.OfferName# > > CONTACT INFO: #form.offercontact# > > AMOUNT: $#form.offeramount#', > > 'WEB USER', > > '#theDate#', > > '#theTime#') > > > > Now to test this problem I have submitted offers on items today and then > > run a report that checks for current open bids and the bids I placed today > > are coming up with a November 30th 2002 date stamp this has left me > > completely boggled and I don't understand what could be causing this issue. > > I have verified all time/dates on all servers that are used for this > > application/database are reporting correct time and date. > > > > > >-- >Barney Boisvert >[EMAIL PROTECTED] >360.319.6145 >http://www.barneyb.com/blog/ > > ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188322 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
Datestamp
After switching a cold fusion application from an access database to mysql I have some strange problems that I am not 100% sure on. Image issues no thumbnails showing up I assume it's related to the original storage location of the images. However one issue I can't seem to correct and has me stumped there is a time/date stamp that is recorded anytime a bid for an item is submitted. In access this was working fine no issues and no problems what so ever. Under mysql this snip of code. TIME: #TimeFormat(now(), 'HH:MM:SS')# DATE: #DateFormat(now(), 'MM/DD/')# Please do not respond to this email. INSERT INTO tblItemNotes (itemID, itemStatusID, itemListPrice, locationID, itemNotes, agent, dateEntered, timeEntered) VALUES (#getItemDetail.itemID#, #getItemDetail.itemStatusID#, #getItemDetail.itemListPrice#, #getItemDetail.locationID#, 'OFFER SUBMITTED BY: #form.OfferName# CONTACT INFO: #form.offercontact# AMOUNT: $#form.offeramount#', 'WEB USER', '#theDate#', '#theTime#') Now to test this problem I have submitted offers on items today and then run a report that checks for current open bids and the bids I placed today are coming up with a November 30th 2002 date stamp this has left me completely boggled and I don't understand what could be causing this issue. I have verified all time/dates on all servers that are used for this application/database are reporting correct time and date. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188312 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: SQL Query
>After some work and some more work I have the administration side of the
>cold fusion application working correctly but now when I am adding a
>product I have come across a problem that appears to be with how the query
>in access worked vs sql. The following is the query if anyone has any
>ideas for making this compatible with sql I would greatly apprteciate any help.
SELECT TOP 5 itemID,itemName, itemLeaseNumber,
itemKeywords, itemThumbnail, itemDescription, itemListPrice,
itemInvoicePrice, MAX(itemListPrice/itemInvoicePrice)
AS priceDifferencePercentage
FROM tblItem, tblkItemStatus
WHERE tblItem.itemStatusID =
tblkItemStatus.itemStatusID
AND tblkItemStatus.itemStatusMainID = 2
AND itemListPrice <> 0
AND itemInvoicePrice <> 0
GROUP BY itemID,itemName, itemLeaseNumber,
itemThumbnail, itemKeywords, itemDescription, itemListPrice, itemInvoicePrice
ORDER BY MAX(itemListPrice/itemInvoicePrice)
ASC
#iCount#
SAVE #pricePercent#% ON#UCase('#itemName#')#
>
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187143
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
SQL Query
This code works fine with a access database, since converting the entire cf application to a live SQL database it has been the beginning of a nightmare. I'm not real familiar with access but it seems they have some really strange ways to check dates and whatnot. SELECT Sum(tblItemPurchase.itemPurchasePrice) AS totalMonthlyPurchase FROM tblItemPurchase WHERE tblItemPurchase.itemPurchaseDate >= ###theMonth#/1/#theYear### GOALS THIS MONTH: GOAL:#DollarFormat(theGoal)#. SO FAR:#DollarFormat(getMonthlyPurchase.totalMonthlyPurchase)# TO GO:#DollarFormat(amountLeft)# If anyone can point me in the right direction or where to look for the needed information about converting a access based site to sql. Thanx Web Your Business Inc., - located in Loveland, Colorado; serving the World! http://www.webyourbusiness.com/ - & - http://www.aaabusinesshosting.com/ Phone: 970-593-6260 - Fax: 970-593-6267 - Toll Free: 1-877-416-8655 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187067 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
Query Errors
While I have been rebuilding a cold fusion application that was using a access database and was running dog slow now I have converted all the databases over to SQL. Now since I'm not 100% sure on what the actual query calls are if someone can direct me to a site that might list the difference between access / SQL query calls I can get this working correctly. Since converting the databases over and not making any code changes this is the first of what I assume will be many errors If anyone can point me in the right direction I would greatly appreciate it. Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Line 3: Incorrect syntax near '#'. The error occurred in C:\Inetpub\voremarketing\admin\adminMain.cfm: line 344 342 : SELECT Sum(tblItemPurchase.itemPurchasePrice) AS totalMonthlyPurchase 343 : FROM tblItemPurchase 344 : WHERE tblItemPurchase.itemPurchaseDate >= ###theMonth#/1/#theYear### 345 : 346 : SQLSELECT Sum(tblItemPurchase.itemPurchasePrice) AS totalMonthlyPurchase FROM tblItemPurchase WHERE tblItemPurchase.itemPurchaseDate >= #12/1/2004# DATASOURCE vodb_remarketing VENDORERRORCODE 170 SQLSTATE HY000 ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186909 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
CF and Databases
I have a client that has access backend for his cf application, when trying to run a query for a report that checks for item status the page always times out never will load. The query works on other reports with no problem. There are about 1500 products in the field and the status id is numerical from 1-10. Now myself personally I would never use an access database for this type of work I would prefer to use mysql but I don't have that choice. So if anyone is familiar with cf/access or know of any issues that have to do with access indexing not working correctly under a cf app please let know. Web Your Business Inc., - located in Loveland, Colorado; serving the World! http://www.webyourbusiness.com/ - & - http://www.aaabusinesshosting.com/ Phone: 970-593-6260 - Fax: 970-593-6267 - Toll Free: 1-877-416-8655 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185556 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: Adding Image to Listing
I tried your line change new problem related to it. Invalid CFML construct found on line 11 at column 36. ColdFusion was looking at the following text: ) The CFML compiler was processing: * an expression beginning with "form", on line 11, column 15.This message is usually caused by a problem in the expressions structure. * a cfif tag beginning on line 11, column 10. * a cfif tag beginning on line 11, column 10. At 04:27 PM 11/19/2004, you wrote: >Jason, > >Offf the top of my head, try: > > > >-joe > >On Fri, 19 Nov 2004 15:38:39 -0700, Jason Smith ><[EMAIL PROTECTED]> wrote: > > Can anyone point me in the right direction with this problem? > > > > This is a re-marketing site and when they add a new product to be sold when > > they attempt to add images this is the error > > > > Variable attachment1 is undefined. > > > > The error occurred in > > > C:\Inetpub\voremarketing\admin\inventory\addInventory\addInventory_Images_action.cfm: > > > > line 11 > > > > 9 : > > 10 : > > 11 : > > 12 : > > 13 : > > > > Since I didn't create this I'm debugging issues that have come about from > > moving to a new host. > > > > Web Your Business Inc., - located in Loveland, Colorado; serving the World! > > http://www.webyourbusiness.com/ - & - http://www.aaabusinesshosting.com/ > > Phone: 970-593-6260 - Fax: 970-593-6267 - Toll Free: 1-877-416-8655 > > > > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184937 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
Adding Image to Listing
Can anyone point me in the right direction with this problem? This is a re-marketing site and when they add a new product to be sold when they attempt to add images this is the error Variable attachment1 is undefined. The error occurred in C:\Inetpub\voremarketing\admin\inventory\addInventory\addInventory_Images_action.cfm: line 11 9 : 10 : 11 : 12 : 13 : Since I didn't create this I'm debugging issues that have come about from moving to a new host. Web Your Business Inc., - located in Loveland, Colorado; serving the World! http://www.webyourbusiness.com/ - & - http://www.aaabusinesshosting.com/ Phone: 970-593-6260 - Fax: 970-593-6267 - Toll Free: 1-877-416-8655 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184935 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: Verity Collection
What I seem to be having more of a problem with is the return url and the
correct indexing of the search and it's settings. Is there a good site that
shows some solid tutorials about settings up and correctly indexing verity
collections in the Cold Fusion Administrator?
At 07:45 PM 11/17/2004, you wrote:
>ok, this code seems kosher. But you want to index actual files on ur
>server in addition to the above? You should be able to followt the
>above code as a template, the big diff will be the cfindex tag. Check
>out
>http://livedocs.macromedia.com/coldfusion/6/Developing_ColdFusion_MX_Applications_with_CFML/indexSearch.htm
>they have a great write up on how to mosh it all out. After you do a
>cfsearch, use cfdump on the result and examine all the fields, it
>looks like you outputted the urlpath filed and teh actual path too.
>
>HTH
>
>Doug
>
>
>On Wed, 17 Nov 2004 14:42:06 -0700, Jason Smith
><[EMAIL PROTECTED]> wrote:
> > The original developer of this web site made a serious mess, I'm still
> > looking for certain files to make changes I personally have never seen a
> > web site with so many useless files in so many locations but as I said I'm
> > new to cold fusion so if you can point me in the direction of what file is
> > most likely to contain the information you need it would help tremendously.
> >
> > Now like I said I have done some things with different cold fusion sites
> > however this is the first cf application I have seen that does not use a
> > global file for anything it would appear he puts all code in every file.
> > Plain and simple the entire application needs a rewrite but I'm really not
> > sure where all strings are that you might need to see.
> >
> > As far as I can tell this is the search info you might be looking for.
> >
> >
> > > collection="itemCollection"
> > name="mySearchQuery"
> > type="simple"
> > criteria="'#exactSearch#'"
> > language="english"
> > external="no">
> > EXACT
> > MATCHES FOR '#UCASE(exactSearch)#'.
> > #mySearchQuery.recordCount#
> > Matching Items
> >
> >
> >
> >
> >
> > > REReplace(mySearchQuery.summary, "<[^>]*>", "", "ALL")>
> >
> > > ReplaceNoCase(searchSummary, "#exactSearch#", "#exactSearch#", "ALL")>
> >
> >
> > > style="font-family: verdana; font-size: 10px;">#iCount# > iCount + 1>. >
> href="#Request.RelRootPath#search/itemDetail_#mySearchQuery.key#.html">#MySearchQuery.Title#
> > > neq 0>#DollarFormat(mySearchQuery.custom2)#
> >
> >
> >
> > > isDefined('mySearchQuery.custom1') and mySearchQuery.custom1 neq "" and
> > mySearchQuery.custom1 neq " ">
> > > href="#Request.RelRootPath#search/itemDetail_#mySearchQuery.key#.html"
> > title="View Details of #MySearchQuery.Title#"> >
> src="#Request.RelRootPath#zimages/uploadedItemImages/thumbnail/#mySearchQuery.custom1#"
> > title="#MySearchQuery.Title#" alt="Used Business Equipment, SAVE MONEY"
> > height="45px">
> >
> > > href="#Request.RelRootPath#search/itemDetail_#mySearchQuery.key#.html"
> > title="View Details of #MySearchQuery.Title#"> > src="#Request.RelRootPath#zimages/noImageFiller.gif" height="45px">
> >
> >
> > #searchSummary# (#Round(score * 100)#% Match)
> >
> >
> >
> >
> >
> > THERE WERE NO EXACT MATCHES FOR
> > '#UCASE(exactSearch)#'.
> >
&
Re: Verity Collection
The original developer of this web site made a serious mess, I'm still looking for certain files to make changes I personally have never seen a web site with so many useless files in so many locations but as I said I'm new to cold fusion so if you can point me in the direction of what file is most likely to contain the information you need it would help tremendously. Now like I said I have done some things with different cold fusion sites however this is the first cf application I have seen that does not use a global file for anything it would appear he puts all code in every file. Plain and simple the entire application needs a rewrite but I'm really not sure where all strings are that you might need to see. As far as I can tell this is the search info you might be looking for. EXACT MATCHES FOR '#UCASE(exactSearch)#'. #mySearchQuery.recordCount# Matching Items ]*>", "", "ALL")> #exactSearch#", "ALL")> #iCount#. #MySearchQuery.Title# #DollarFormat(mySearchQuery.custom2)# #searchSummary# (#Round(score * 100)#% Match) THERE WERE NO EXACT MATCHES FOR '#UCASE(exactSearch)#'. And assuming I have found the information you looking for this would be the cfindex guess. SELECT itemName, itemDescription, itemKeywords, itemID, itemThumbnail, itemListPrice, itemLeaseNumber FROM tblItem, tblkItemStatus WHERE tblItem.itemStatusID = tblkItemStatus.itemStatusID AND tblkItemStatus.itemStatusMainID = 2 FINISHED INDEXING THE ITEM QUERY FINISHED OPTIMIZING THE ITEM COLLECTION At 02:29 PM 11/17/2004, you wrote: >can you post your cfindex tag code? oh, and your cfsearch code too. > >Doug > >On Wed, 17 Nov 2004 14:00:34 -0700, Jason Smith ><[EMAIL PROTECTED]> wrote: > > > > > > Anyone out there real familiar with verity collections, I'm having trouble > > getting one to index correctly. I'll give us many details as possible if I > > left anything out just let me know. > > > > The server is a Coldfusion 6.1MX on a windows 2003 server. Now myself I'm > > very new to cold fusion and just trying to learn more. I have setup a few > > sites for customers but this is the first site that uses a verity > collection. > > > > Now on to the problem I have read a few resources that all point to > > creating the verity collection and then index the collection. Well I called > > the previous hosting company they moved from to get the exact settings > > however the indexing of verity collections if not written down doesn't > > appear to be retrievable. So this is where I am stuck I have the collection > > created. > > > > name itemcollection > > mapped yes > > online yes > > external no > > language english > > path c:\inetpub\mysite\admin\verity\collections\itemcollection > > > > Now for the indexing this is the problem I run into I'm assuming it should > > be indexing the search directory since that is where all the items have > > created detail pages. File extensions since looking in that directory there > > are mainly html pages with 2 cfm pages I'm assuming html pages are the only > > things I want to index. > > > > path c:\inetpub\mysite\search > > return url http://www.mysite.com/search > > > > After I let it index the files and I go to the test search engine and run a > > search the results are wrong, first off you can search for anything and get > > a return of 100+ matches which is the company name not a product. Then > > checking the link of the result found I come across another problem. > > > > > http://www.mysite.com/search/itemDetail_C:/Inetpub/mysite/search/itemSearch.html.html > > > > Every result has this as the url which obviously isn't correct. > > > > I have spent a few hours reviewi
Verity Collection
Anyone out there real familiar with verity collections, I'm having trouble getting one to index correctly. I'll give us many details as possible if I left anything out just let me know. The server is a Coldfusion 6.1MX on a windows 2003 server. Now myself I'm very new to cold fusion and just trying to learn more. I have setup a few sites for customers but this is the first site that uses a verity collection. Now on to the problem I have read a few resources that all point to creating the verity collection and then index the collection. Well I called the previous hosting company they moved from to get the exact settings however the indexing of verity collections if not written down doesn't appear to be retrievable. So this is where I am stuck I have the collection created. name itemcollection mapped yes online yes external no language english path c:\inetpub\mysite\admin\verity\collections\itemcollection Now for the indexing this is the problem I run into I'm assuming it should be indexing the search directory since that is where all the items have created detail pages. File extensions since looking in that directory there are mainly html pages with 2 cfm pages I'm assuming html pages are the only things I want to index. path c:\inetpub\mysite\search return url http://www.mysite.com/search After I let it index the files and I go to the test search engine and run a search the results are wrong, first off you can search for anything and get a return of 100+ matches which is the company name not a product. Then checking the link of the result found I come across another problem. http://www.mysite.com/search/itemDetail_C:/Inetpub/mysite/search/itemSearch.html.html Every result has this as the url which obviously isn't correct. I have spent a few hours reviewing forums and reading posts, book information different things so far I have yet to find a fix for this so if anyone can help I would greatly appreciate it. Jason Smith __ NOD32 1.924 (20041117) Information __ This message was checked by NOD32 antivirus system. http://www.nod32.com Web Your Business Inc., - located in Loveland, Colorado; serving the World! http://www.webyourbusiness.com/ - & - http://www.aaabusinesshosting.com/ Phone: 970-593-6260 - Fax: 970-593-6267 - Toll Free: 1-877-416-8655 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184662 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
