Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
getDate() + 1 year
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- mcb999
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
-
exporting quote csv
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...- mcb999
- Thread
- Replies: 5
- Forum: Microsoft: Access Other topics
-
xml parsing error
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...
