Hello All; I usually do everything in SQL Server these days, however, I have an site that is just so small, that it is going to be using an Access database. This is the code that I am using to generate the Google Sitemap with, however, there is code here that does not translate over to ACCESS Database. SELECT imageid, imagetitle, MedUpdate as DefaultTime, convert(varchar(11),MedUpdate,121) as UModDate, CONVERT(CHAR(8), CONVERT(DATETIME, MedUpdate, 113), 114) AS UMilTime, convert(varchar(11),MedDate,121) as JDate, CONVERT(CHAR(8), CONVERT(DATETIME, MedDate, 113), 114) AS JTime FROM Images GROUP BY imageid, MedUpdate, MedDate, imagetitle order by imageid Could someone please convert this …

Member Avatar
+0 forum 0

Hello All; It seems that I have just run into a small issue that I am hoping can get resolved pretty quickly, as it is the only thing that is holding me back from completely this part of my task. In an ASHX file, I am needing to read a cookie to pass its value to a SQL Select statement to pass another value from their to a SQL Insert. This is what I am using and it breaks everytime. And since I am using FLASH, it is hard to find out "why" i am getting the error as I …

Member Avatar
Member Avatar
+0 forum 4

Hello All; I would like to start off by saying hello, and that this is actually my first post to the group, even though I have been a member for many years. I am a ASP Classic Programmer, professionally for a little over a year, I have developed some rather nice sites, including the one in my signature (Still a work in progress). I have been forced to use ASP.NET (VB) for a FileUpload control, as it offers a self controlled way of creating Thumbnails, without the use of 3rd party controls, which is great, as my hosting server does …

Member Avatar
Member Avatar
+0 forum 4

The End.