Search results for query: *

perfect..thanks!

Whats the best way of setting a date field to add 1 year from the current date? Using getDate() set the current date by default so I would imagine its just a matter of adding something between the brackets. Thanks

either way to get it to work.

Originally I had the data in excel. Im not sure how to take existing data in there and appending a quote to the front and end of each field. Could you explain this please? Thanks

Basically what im trying to do is take all my data from this table and export it into a csv but each field needs to be surrounded by quotes. Whats the best way of doing this? Thanks, Micah...

In access 2007 im running a query and need to export the fields with quotes around them. select productName, productPrice from Products needs to come out as: "product1","price1" "product2","price2" etc... Whats the way to do this? I know this is probably pretty basic but so am i right now...

actually the correct term is "UPC lookup database"

Youll want to look into licensing a UPC database. Heres an example: http://www.upcdatabase.com/itemform.asp

I finally figured this out. Adding .xmlText to the end seemed to fix this.

I cant find a link for it now bet we have used a tag called cfx_pixSize and cfx_PicReSize. Works really well.

When I look at the source for this this is what im getting: <li><a href='/Category.cfm?categoryID=<?xml version="1.0" encoding="UTF-8"?> <ProductID xmlns="http://sitemname.org/Products.xsd">42735</ProductID>'><?xml version="1.0" encoding="UTF-8"?> <Description...

Im trying to use an ID I get in my xml to add it to an <a href=""> link but am having some problems displaying this correctly. If I display the xml element outside of the link it displays properly. <a href="/Category.cfm? categoryID=">#xRows.xmlChildren[name].productID#</a> But when I add it...