Search results for query: *

If I understand what you are trying to do try something like: SELECT itemlookup_code, quanitity, datetransfered FROM table ORDER BY datetransfered DESC, GROUP BY datetransfered http://www.onti.net

This is an easy one I hope..just can't remeber how to make this happen: I am working on a program (written by microsoft) run on SQL Server. One of the table names is "ORDER" and the word 'ORDER' being a reserved word in SQL Server generates an error when I try to reference the table...

Use the Scripting.FileSystemObject: <% Set oFS = Server.CreateObject(&quot;Scripting.FileSystemObject&quot;) Set oFile = oFS.GetFile(&quot;C:/MyFile.xls&quot;) Response.Write oFile.DateLastModified & &quot;<BR>&quot; Response.Write oFile.DateCreated & &quot;<BR>&quot; Response.Write...

Not to sound pessimistic but...good luck :) I had a similar problem with a client for whom I was developing a inventory tracking/management system. They wanted it to import and export from peachtree 2000, the system they had been using for some time. Peachtree 2000 db is a btrieve based db...

Not exactly...check out: http://www.multiwareinc.com/pawcom.htm http://www.onti.net

Sorry, misunderstood what you were trying to do :-) If the second list must come from the SQL and if there is no way to preload all the possible combinations then you must do a round trip to the server to retrieve the data based on the &quot;on Change&quot; Selection (from option 1). In this...

Pardon me for switching to VBScript on the server side but why don't you loop through the list and build the HTML when you get the RS instead of getting the Array and then pushing it through JS? I am not sure of the equivalent loop in JS... example: <% dim arrTopics 'SQL query...

What OS? (WIN95/98/Me, WIN2K, WINXP, WINNT, Linux) http://www.onti.net

Yes and No. You have the version of PTC 2002 which comes as a single user and has an optional multi user add on pack (This is the standard version I believe). Peachtree wants you to pay for each user using the software. You can buy another single user copy of PTC 2002 for the second computer...

I created a custom for based on IPM.Post to store client data. When I try to save or post the form a exclamation box pops up with the message &quot;11/05/2001 8:00:00&quot; and nothing else. The Item_Write event never fires and the item is not saved. I can close the item but when prompt ed to...

First do a virus scan for 'Code Red' or other malicious code. (Code Red had this result I believe) Try unloading one web site at a time until InetInfo calms down (if it does). Try running each site in its own memory space and doing this. After unloading all the sites start making hits to each...

Try: valueStart = InStr(1, strQuerystring, strName) + (Len(strName) + 1) http://www.onti.net

FYI- I am pretty sure that putting that object on the server would violate the EULA & copyright laws :-( http://www.onti.net

Use the file systems object to loop through the folders and sub folders. There may be a more efficent way to do this, any input would be appreciated :-) <% Public Function GetFolderList(strPathName) 'Returns comma delimited string of folder names ' starting with &quot;l2d&quot; starting...

When the server processes a Response.Write it streams data to the client. When Response.Buffer is set to true the server holds all the respsonse.write output and any other HTML you have coded until the response.flush is called or the end of the page is reached ( flush is called implicitly)...

Use the FileSystemObject to return the 'files' collection from the folder with the images (I am assuming you know the path to the images in the example) and iterate in a loop through the collection setting a string var with all the html. <% 'function that returns images in a 2 col table...

You are not allowed to redirect once you have written anything to the client. You have to do the redirect before sending out or writing any HTML to the browser. There are a couple of options. 1) Easiest -- besure login check is the third thing on your page: (assuming the inlclude file writes...

To work with the running/not running thing programatically I have used the following code. It is a bit hacky and I would appreciate advise on a better method but it works. Err.Clear On Error Resume Next Set objXLS = Server.GetObject(, &quot;Excel.Application&quot;) 'If the Excel...

Try this: Response.write &quot;<a class='' href='&quot; & News.Link & _ &quot; target='_blank'>All News</a>&quot; When I trouble shoot this type of error it is always helpful to look at the source of the brower output (view source). That will help eliminate missing spaces and quotes...

kevink, Good point about the vbscript default...DO NOT use Cdate with my above solution if you have access set up for dd/mm/yyyy unless your IIS local is set properly also(may have to test). http://www.onti.net