Recent content by Extentec

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)...