Strip time from date?

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ ASP Server
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - newbie question: Which s/w to use for ASP writing hi folks. newbie to ASP here having previously only worked with Flash and basic HTML.. my question is which software packages do you all us to write your code? I've been using UltraDev 4 (for my HTML stuff), and MM flash (obviously) Should I stick with UltraDev or would you recommend getting hold of Visual InterDev? thanks..and I hope I don't upset you all by asking lots of daft questions in the future Alistair Tag: Strip time from date? Tag: 272098
  - 2
    - Checking links Hi all win 2k pro sql server 2k asp - vbscript I got the below code from somewhere ages ago. I have a list of links on my site that link to other sites but I want to check if the link is a valid link automatically and if it fails after x checks (checks every 7 days) then to mark the link as a possible broken link the below seems to take ages to process and was wondering if there is a better way to do the below. thanks for any help & tips. Al Set xmlhttp = CreateObject("MSXML2.XMLHTTP") on error resume next xmlhttp.open "get", sURL, False xmlhttp.send if err.number = 0 then iStatus = xmlhttp.Status else 'error might be "DNS error" iStatus = 404 end if on error goto 0 Set xmlhttp = nothing ' if status =200 then it is a VALID url. if iStatus = 200 then ' valid link ' update db here else ' invalid link. ' update db end if Tag: Strip time from date? Tag: 272097
  - 3
    - The connection with the server was reset Hi Everyone I'm using serverXMLHTTP to retrieve pages, but in some cases its throwing "The connection with the server was reset" back to me, im not completly sure what the message means, when i used other variations of the the http component i get similair errors, though sometimes it pulls through (once every so many'th times) any help/clues would be appreciated Richard Tag: Strip time from date? Tag: 272096
  - 4
    - query a DB - pass the query to next page I am running a querry on an access database and have set the number of records/page displayed at 20. if there are more than 20 records returned, then 1st page will show the first 20, the next page will show next 20 and so on.... The trouble: the count of total records displayed is correct and the first page is displayed correctly. But when i click on *Next* to go to the next page, all the records of the database get displayed (not the 2nd page of records from the query). here is the demo i put up: http://www.as.pgims.org/query/query.asp Any help? Tag: Strip time from date? Tag: 272094
  - 5
    - Site and component that turn IP number into www.sitename.com? Is there a site where I can enter an IP number and get the URL name, for example 123.234.34.55 ->www.google.com Also, I know there are custom components that do this but don't know their names. Thanks *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: Strip time from date? Tag: 272089
  - 6
    - Redirecting zip file Hi All, Good Morning, The problem which i am facing is related with IIS 6.0 in Win2K3. The problem: I have a ASP page which redirect a zip file which resides in the Application data path, while access this page i am getting the PAGE CANNOT BE FOUND error, with the URL "http:\\172.16.10.98\CWSLite\Temp\Client.asp". But if i brows the same with URL http:\\localhost\CWSLite\Temp\Client.asp then i am getting the zip file. Please any one help me to get the file with IP address URL. Thanks in Advance. Regards, Nagaraj M Tag: Strip time from date? Tag: 272084
  - 7
    - Problem using com object in IIS 4 Hey all, I've been having a weird problem using com objects in IIS 4. I've built a middleware system that can be called with XML requests over HTTP. The request is sent to an ASP page which creates a com object that handles the request. This com object usually calls other asp pages that handle sub functions. This has worked fine, but now I have a new component that is giving me a lot of problems. It's a component that contains a few calls to a SQL db using ADO. It works fine for a while, but then I start getting an error in the backend component. I have very good error handling, so I get an XML response back with the error number and location. I have been able to pin point the line of code that gives the error (5, illegal function call). But it's almost impossible that an error would happen there... The line of code contains an add to a collection. I add a simple variable to a collection. This runs fine for a long time and then I get the error. On my local machine the code works fine. As soon as I plug it into IIS it goes wrong. The error always occurs in the same spot. After this error has occurred, I can no longer use any component that uses my database component. If I leave the machine alone for a while it will pick up again... I'm confused... Thanks, Dirk. Tag: Strip time from date? Tag: 272078
  - 8
    - URL Checker - (One Stage Further) Hello Groups, I have been testing a script I found that checks URL as valid... It uses the XMLHTTP.4.0 object sURL = "http://www.bbc.co.uk" Set obj = CreateObject("MSXML2.XMLHTTP.4.0") on error resume next obj.open "GET", sURL, False obj.send iStatus = obj.Status on error goto 0 this works fine on most URLS, though I do have some problems with redirected URLs, what I have managed to do is do a database select statement outside of the script and check my database of URLs.. This works fine.. My Database of URL are the backend of a search engine I have written, what I was wondering, is instead of me doing a seperate external check of the URLs using the database as above, can I do something like..... When the user clicks on a URL, they have a varable director.asp?url=blar blar blar, this goes to a page that does a redirect to the URL. Is it possible for me to use the XMLHTTP object to do the redirect, and this way would it be possible for me to have the users of my site check the URL by grabbing the value of the statuscode from the XMLHTTP object before it is redirected. I would like to be able to have the links constantly checked by the users rather than me have to manually as above say every month. something like this, if you see below I would be very keen not to make the jump to the URL slower, so once the URL had been checked using XMLHTTP then maybe it would be possible to use the redirect... CLICK ON LINK | CHECK URL EXISTS USING XMLHTTP | UPDATE DATABASE WITH LAST CHECKED TIMESTAMP | REDIRECT TO THE URL I am not sure if any of this is possible, butjust simple I would like the user clicking on the link actually check it for me, and have a column in the database called last_checked TIMESTAMP Graham Mattingley Tag: Strip time from date? Tag: 272077
  - 9
    - asp site map Hi, I would like to create a site map for my map site which is in ASP. I tried to use Visio to create a web site map but it fails because my asp home page requires to authenticate. Is there any other tool to create a sitemap from username/password protected website? thanks jerry Tag: Strip time from date? Tag: 272075
  - 10
    - Server Application Unavailable I'm new to ASP.Net. I have a very simple application that was working last week. Now I get this message when I try to run it from VS.Net: Server Application Unavailable The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request. Administrator Note: An error message detailing the cause of this specific request failure can be found in the system It is only a single page at this point with a few images and labels. I believe IIS is running (version 5.1). I am running Windows XP SP1. I suspect it might have had something to do with installing the latest security patches. Any ideas? Thanks, Ted Tag: Strip time from date? Tag: 272061
  - 11
    - how to keep cookies or sessions between 2 sites? Hello, I have 2 separate web sites on 2 different boxes www.xyz.com on box 1 www2.xyz.com on box 2 Users log into box 1 via regular ASP/Database authentication, and I keep a session variable to mark authenticated users. There's a link that would send users to box #2 at www2.xyz.com. How do I check whether these users are authenticated or not? I do not want to present a login screen again. Is it possible? If so, what are ways to do it, if not session/cookies? Thanks! HH Tag: Strip time from date? Tag: 272054
  - 12
    - Problem using com object in IIS 4 Hey all, I've been having a weird problem using com objects in IIS 4. I've built a middleware system that can be called with XML requests over HTTP. The request is sent to an ASP page which creates a com object that handles the request. This com object usually calls other asp pages that handle sub functions. This has worked fine, but now I have a new component that is giving me a lot of problems. It's a component that contains a few calls to a SQL db using ADO. It works fine for a while, but then I start getting an error in the backend component. I have very good error handling, so I get an XML response back with the error number and location. I have been able to pin point the line of code that gives the error (5, illegal function call). But it's almost impossible that an error would happen there... The line of code contains an add to a collection. I add a simple variable to a collection. This runs fine for a long time and then I get the error. On my local machine the code works fine. As soon as I plug it into IIS it goes wrong. The error always occurs in the same spot. After this error has occurred, I can no longer use any component that uses my database component. If I leave the machine alone for a while it will pick up again... I'm confused... Thanks, Dirk. Tag: Strip time from date? Tag: 272052
  - 13
    - Problem using com object in IIS 4 Hey all, I've been having a weird problem using com objects in IIS 4. I've built a middleware system that can be called with XML requests over HTTP. The request is sent to an ASP page which creates a com object that handles the request. This com object usually calls other asp pages that handle sub functions. This has worked fine, but now I have a new component that is giving me a lot of problems. It's a component that contains a few calls to a SQL db using ADO. It works fine for a while, but then I start getting an error in the backend component. I have very good error handling, so I get an XML response back with the error number and location. I have been able to pin point the line of code that gives the error (5, illegal function call). But it's almost impossible that an error would happen there... The line of code contains an add to a collection. I add a simple variable to a collection. This runs fine for a long time and then I get the error. On my local machine the code works fine. As soon as I plug it into IIS it goes wrong. The error always occurs in the same spot. After this error has occurred, I can no longer use any component that uses my database component. If I leave the machine alone for a while it will pick up again... I'm confused... Thanks, Dirk. Tag: Strip time from date? Tag: 272050
  - 14
    - Problem using com object in IIS 4 Hey all, I've been having a weird problem using com objects in IIS 4. I've built a middleware system that can be called with XML requests over HTTP. The request is sent to an ASP page which creates a com object that handles the request. This com object usually calls other asp pages that handle sub functions. This has worked fine, but now I have a new component that is giving me a lot of problems. It's a component that contains a few calls to a SQL db using ADO. It works fine for a while, but then I start getting an error in the backend component. I have very good error handling, so I get an XML response back with the error number and location. I have been able to pin point the line of code that gives the error (5, illegal function call). But it's almost impossible that an error would happen there... The line of code contains an add to a collection. I add a simple variable to a collection. This runs fine for a long time and then I get the error. On my local machine the code works fine. As soon as I plug it into IIS it goes wrong. The error always occurs in the same spot. After this error has occurred, I can no longer use any component that uses my database component. If I leave the machine alone for a while it will pick up again... I'm confused... Thanks, Dirk. Tag: Strip time from date? Tag: 272049
  - 15
    - Creating Text File I'm using ASP 3.0. I'm taking form contents and dumping it into a text file on the server. My question is how to add the TIME to this statement. I create the text file with the name of file, month, day and year. I would like to add TIME to it. ------------------------------------------------------------- set fso = createobject("scripting.filesystemobject") Set act = fso.CreateTextFile(server.mappath("/data/"&g_filename & "-"& month(date())& day(date())& year(date()) &".htm"), true) ------------------------------------------------------------- Thank you, Erik Tag: Strip time from date? Tag: 272048
  - 16
    - Passing Coordinates If this doesn't fix the post-date issue, I'm at a loss. Anyone care to enlighten me? Tag: Strip time from date? Tag: 272046
  - 17
    - messagebox inside ASP page How can I send messages to user like messageBox from a ASP page without doing postback over the page. thanks for your help Oscar Tag: Strip time from date? Tag: 272040
  - 18
    - unwanted session timeout I have a simple form connecting to an Access database where users log in, fill out the form, and submit. Everything works fine. However, sometimes it takes a user 20 minutes or more to fill out the form. When the user then hits "submit" he is given the login page instead of the response page I have built in. If the user fills the form out in less than 20 minutes or so, it works fine. I have Session.Timeout=720 (2 hours) but this hasn't changed anything. Does anyone know what I'm missing? I'm pretty new at asp so forgive me if it's something simple. Thank you in advance, Rob Tag: Strip time from date? Tag: 272032
  - 19
    - Unpsecified Error with ODBC Connections This happens a lot to my databases. I store them at the root of my developing files, i.e. c:\My Projects\Proj1\database.mdb. Randomly, the security settings on this database will drop to the basic secutiry, myself and SYSTEM. I need IUSR on it so I can access it through my ASP pages... I get errors like this: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data. /amr/common/adovbs.inc, line 4 and Provider (0x80004005) Unspecified error /amr/common/adovbs.inc, line 4 and line 4 is this 2 Dim Connect 3 Set Connect = Server.CreateObject("ADODB.Connection") 4 Connect.Open "dsn name" I will reset the permissions, then the ASP script will access the database once, like read or write, then this will happen again. I have to reset the permissions on the database file. Sometimes i'll have to do this 3 or 4 times until the permissions stick. It only happens on a few of my projects, not all of them. Also, what helps at times, is within IIS, to check server extensions. This seems to do something to it to help it to work. Any Ideas? -- David Lozzi Associated Business & Technology Group www.associatedbtg.com I should've known that....but I had a brain fart. Tag: Strip time from date? Tag: 272031
  - 20
    - Preventing windows from suggesting usernames in login boxes?? How can I prevent this from happening? For example when the asp application works in a public terminal where we don't want successive users to know the login password and user name of the previous ones? Thanks *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: Strip time from date? Tag: 272023
  - 21
    - ASP Pages will not display I had to restore my server from backup. When I did, I could no longer access any asp pages on my web server. The error says HTTP 500 Internal Server Error. I have turned off friendly HTTP error messages and it gives me less info. All it says is server application error. html or htm pages work fine. I have reinstalled com+ so that I can now access the components services snap-in. When I go to the properties of the website and then into home directory and change the application protection to low the pages display correctly. This makes me think it is a permissions issue with the iwam_machinename user. The two event logs that are logged in event viewer on the server each time I try to access an asp page are as follows: Event Type: Error Event Source: W3SVC Event Category: None Event ID: 59 Date: 9/12/2003 Time: 6:30:30 AM User: N/A Computer: HPFMS Description: The COM Application '{3D14228D-FBE1-11d0-995D- 00C04FD919C1}' at '/LM/W3SVC/3/Root' failed to activate out of process. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp and..... Event Type: Warning Event Source: W3SVC Event Category: None Event ID: 36 Date: 9/12/2003 Time: 7:06:21 AM User: N/A Computer: HPFMS Description: The server failed to load application '/LM/W3SVC/3/Root'. The error was 'c000003b'. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp. Please help!! Thanks in advance for any info that you can give me! Tag: Strip time from date? Tag: 272022
  - 22
    - script ASP in an onClick event i need to insert, in a onClick event of a submit button in a form, a call to an ASP script, like follows: <INPUT TYPE="SUBMIT" NAME="btnSend" onClick="<% A_Function_Or_Sub_in_VBScript %>"> the problem is that teh event triggers only event on the client page, not on the server..how to solve the problem??? thx to all.. Tag: Strip time from date? Tag: 272021
  - 23
    - ASP vs. HTML for Search Engines Hello, I'm wondering if anyone can shed some experience on how to have search engines index a website that is a store using products stored in an asp database. I've been creating static html pages each time I update my inventory but it seems like there has to be a better/quicker way. Thanks for any help! --Linda deforgel@aol.com Tag: Strip time from date? Tag: 272019
  - 24
    - Are stored procedures practical using ASP only? Hello, The aspfaq.com seems to really push stored procedures, and I hear the same advice here all the time. So I want to take the advice. Is it possible to create and practically maintain, delete, use, etc.. stored procedures soley from asp (i.e., no GUI or console- like being hosted on Brinkster)? The tutorial on aspfaq.com mentions that stored procedures can be created from asp code- how? Do you just send the stored procedure you'd type into the GUI with oConn.execute() instead? Thanks! Tag: Strip time from date? Tag: 272015
  - 25
    - NEWBIE: How to create a log file Hello All, I'm new to ASP and am having problems with CDONTS.NewMail not always delivering my mail. Unfortunately, it always seems to fail on a particular recipient, so he's getting steamed! In my code, I create two e-mails, one to an end-user, and one to a sales rep. The e-mail to the user always succeeds, but the email to the sales reps fails about 15-25% of the time. I'm trying to debug the ASP page, and I figure using a log file may be the best way. I want to test the sales rep's newMail object and write to a log file when it fails (IsNull()), but I don't know how to create a log file in ASP. Example: Dim newMail newMail = Server.CreateObject ("CDONTS.NewMail") if(IsNull(newMail) then ' Code to write to a log file goes here ' Record the e-mail info for re-send later ' What goes here else ' Code to create the mail components goes here newMail.Send newMail = nothing end if I know this is super-simple and just need a quick code snippet. Thanks -tomas Tag: Strip time from date? Tag: 272008
- Next
  - 1
    - Limit User How can i limit the number of users on my .ASP page, i want only one user to be using the page at a time, The query i have on my page is big and takes a lot of my system resources. John Tag: Strip time from date? Tag: 272007
  - 2
    - Passing coordinates Tag: Strip time from date? Tag: 272006
  - 3
    - protected download of files... I am creating a series of downloadable articles, career tools, spreadsheets, etc. However, some of the content is for "registered" guest. The registrants are stored in a database and logon. I want to ensure that someone registered cannot simply pass someone the path to the files for download. However, I am not creating an actual system user name for the folders where the various documents exist. I don't want someone to logon, retrieve the path to a file, and be able to send that path or return to that path without having to logon. How do I accomplish this? Consider the following: serverroot/registeredcontentfolders would be protected by a single logon name - not accessible via anonymous access. User's logon to site and I auth them with their user name but on the server side, auth with the single account I am establishing for access to the protected folders. Any insight would be appreciated. Thanks, Matt Tag: Strip time from date? Tag: 272005
  - 4
    - ASP with MYSQL Sometimes you dread the day you woke up and said that you will become a Computer Engineer. Not that you love being one, but its just one of those days for me. I have extensively worked on ASP, Access And Sql Server, on win 2k. Now the requirements have changed. The DB has to be MySql. Right now, I m working with a Win2k server and running ASP on IIS. That will eventually be run on Linux on Chilli ASP. I dread that day too now. The thing is, I have got The connection between ASP and MySql running after much difficulty, because I suck at DSN connections and all. Now, that its running, I can't seem to get the RecordCount for any recordset I open with MySql. I worked around it to avoid it, but now I m stuck with the Paging problem, cause whenever I try to page a recordset, the following error pops up :- Error Type: ADODB.Recordset (0x800A0CB3) Object or provider is not capable of performing requested operation. /WorldMediaServices/admin/ListCategory.asp, line 102 AND THE REVELANT CODE FOR THE PAGE is :- <% set Res = Server.CreateObject("adodb.recordset") SQL = "select * from A_Categories" if not request("Category") = "0" then SQL = SQL & " where name = '" & request("Category") & "'" end if SQL = SQL & " order by name" Res.open SQL,Application("Conn"),3,2 Res.PageSize = 10 Res.absolutepage = 1 %> Line 102 being the last one. I don't know where the problem lies, the configuration of MySql for Windows or ASP. Any help would be really appreciated. Thanks Regards Jawad Tag: Strip time from date? Tag: 272002
  - 5
    - System resource exceeded. Hello one of our servers (win2k adv server, IIS5, MDAC 2.8, full patched), once a day in the afternoon starts giving this error on every site that uses asp: Microsoft OLE DB Provider for ODBC Drivers error '8007000e' [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. the memory used goes from 800Kb to 1,5Gb (1Gb of physical ram available), and even though the cpu used isn't 100% we need to reboot because everything dramatically slows down. There are many sites hosted on this server and we never had this problem before... The culprit must be one of the new sites then. Is there a practical way to find out which site is the culprit? Thanks Tag: Strip time from date? Tag: 271997
  - 6
    - Script language choice I see that ASP allows you to specify the scripting language of your choice - including (if you get the COM object) PERL, REXX and more. That seems pretty good, I think. Out of the box, it supports VBScript and JScript. The question is (and I know that personal preference will come into this) what would you choose to use out of JScript and VBScript? Does one actually have more capability than the other? -- jeremy Tag: Strip time from date? Tag: 271992
  - 7
    - can Session.Contents can be a string array? Hello, My script builds a list of files in a folder. These files are stored in an 2-dimensional array, called "a_files". To speed up the script, I don't want the filelist everytime being read on the server. Therefore I wanted to send the contents of a_files to a session variable. However, with Session.Contents("sFiles") = a_files I get the following error message: *********************** Response object error 'ASP 0106 : 80020005' Type Mismatch ? An unhandled data type was encountered. *********************** Is it impossible to store an array to a session var? Is there another way to store the array somewhere in memory so it has not to be rebuild everytime? tia bartp -- HyperART Paul Van Ostaijenlaan 4 3001 Heverlee Tag: Strip time from date? Tag: 271991
  - 8
    - "the link could not be saved" error I have two ASP pages. They basically query a database, and spit out the information as plain text in CSV format. The first has the SQL query hardcoded into it. The second takes a SQL query from a webform. Now, the hardcoded results, I can click "Save Page As" when the results come up and save it as a text file. The other, while it seems to be the same results exactly, gives me an error when I try to save the page locally: "The link could not be saved. The web page might have been moved or had it's name changed." !?!? The page has not been moved, nor had it's name changed. In fact, what's sent back to the browser in each case if virtually (if not actually) identical. What's the problem? [begin code from page that cannot be saved]  <% response.ContentType="text/plain" Set oConn = Server.CreateObject("ADODB.Connection") oConn.Open sDataSource Dim sql Dim count sql = Request.Form("sql") Set objConn = oConn.Execute(sql) fieldCount = ((objConn.Fields.Count) - 1) Do Until objConn.EOF For count = 0 to fieldCount Response.Write "'" & objConn(count) & "'" If count <> fieldCount Then Response.Write "," Else Response.Write VbCr End If Next objConn.MoveNext Loop %> [end code] [begin code from hardcoded page that can be saved]  <% response.ContentType="text/plain" Set oConn = Server.CreateObject("ADODB.Connection") oConn.Open sDataSource sql = "SELECT TABLE1.StudentFirstName, TABLE1.StudentLastName, " sql = sql & "TABLE1.StudentEffectiveEnrollmentDate, TABLE1.StudentTel, TABLE1.StudentAddress1," sql = sql & "TABLE1.StudentAddress2, TABLE1.StudentCity, TABLE1.StudentZip," sql = sql & "TABLE2.InventoryKitID,TABLE2.InventoryKitItem1ID," sql = sql & "TABLE2.InventoryKitItem2ID,TABLE2.InventoryKitItem3ID," sql = sql & "TABLE2.InventoryKitItem4ID,TABLE2.InventoryKitItem5ID," sql = sql & "TABLE2.InventoryKitItem6ID " sql = sql & "FROM TABLE1 INNER JOIN TABLE2 ON " sql = sql & "TABLE1.StudentID = TABLE2.InventoryKitStudentID " sql = sql & "WHERE TABLE2.InventoryKitInventoryKitStatusID = 1 AND TABLE2.InventoryKitStudentID <> 0 " sql = sql & "ORDER BY TABLE1.StudentLastName" Set objConn = oConn.Execute(sql) Dim X X = 1 Response.Write "'Last Name'," Response.Write "'First Name'," Response.Write "'EED'," Response.Write "'Phone'," Response.Write "'Address 1'," Response.Write "'Address 2'," Response.Write "'City'," Response.Write "'Zip'," Response.Write "'Kit'," Response.Write "'CPU'," Response.Write "'Monitor'," Response.Write "'Printer'," Response.Write "'Printer Cable'," Response.Write "'Curcuit Breaker'," Response.Write "'Headphones"&VbCr Do Until objConn.EOF Response.Write "'"&objConn("StudentLastName")&"'," Response.Write "'"&objConn("StudentFirstName")&"'," Response.Write "'"&objConn("StudentEffectiveEnrollmentDate")&"'," Response.Write "'"&objConn("StudentTel")&"'," Response.Write "'"&objConn("StudentAddress1")&"'," Response.Write "'"&objConn("StudentAddress2")&"'," Response.Write "'"&objConn("StudentCity")&"'," Response.Write "'"&objConn("StudentZip")&"'," Response.Write "'"&objConn("InventoryKitID")&"'," Do Until X = 7 If objConn("InventoryKitItem"&X&"ID") > 1 AND objConn("InventoryKitItem"&X&"ID") < 999999Then sql = "SELECT InventorySerialNumber FROM TABLE3 WHERE InventoryID=" sql = sql & objConn("InventoryKitItem"&X&"ID") Set objConn2 = oConn.Execute(sql) Response.Write "'"&objConn2("InventorySerialNumber") Else Response.Write "'" End If X = X + 1 If X <> 7 Then Response.Write "'," Else Response.Write "'" & VbCr End If Loop X = 1 objConn.MoveNext Loop %> [end code] -- Sugapablo :: russREMOVE@sugapablo.com http://www.sugapablo.com | ICQ:902845 Tag: Strip time from date? Tag: 271988
  - 9
    - Passing coordinates I have script that fetches the coordinates from mouse. I would like to pass this mouse coordinates to page2.asp How can I do that? <script language="JavaScript1.2">  </script> </body> </html> Tag: Strip time from date? Tag: 271987
  - 10
    - CSV files into VB Arrays in ASP Can anyone tell me why when using a .csv file called book1.csv with the values below the code below does not recognise values read in after the first line in a loop. please feel free to run the code to see what I mean: book1.csv: RGB01,1,2,3,4 RGB02,1,2,3,4 RGB03,1,2,3,4 RGB04,1,2,3,4 <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <html> <% csv_to_read="book1.csv" set fso = createobject("scripting.filesystemobject") set act = fso.opentextfile(server.mappath(csv_to_read)) imported_text = act.readline imported_text = replace(imported_text,chr(13),",") imported_text = replace(imported_text,chr(34),"") split_text=split(imported_text,",") num_imported=ubound(split_text)+1 total_imported_text = act.readall total_imported_text = replace(total_imported_text,chr(13),",") total_imported_text = replace(total_imported_text,chr(34),"") total_split_text=split(total_imported_text,",") total_num_imported=ubound(total_split_text) dim pinstore(500) Dim I Dim iCols counter = 0 for i = 0 to (num_imported -1) step 1 if i mod num_imported = 0 then pinstore(counter) = cstr(split_text(i)) counter = counter + 1 end if next for i = 0 to (total_num_imported - 1) step 1 if i mod num_imported = 0 then pinstore(counter) = cstr(total_split_text(i)) counter = counter + 1 end if next for i = 0 to counter -1 response.write pinstore(i) & " Is in the list<br>" if pinstore(i) = "RGB01" then response.write Pinstore(i) & " = Matched<p>" end if if pinstore(i) = "RGB02" then response.write Pinstore(i) & " = Matched<p>" end if if pinstore(i) = "RGB03" then response.write Pinstore(i) & " = Matched<p>" end if if pinstore(i) = "RGB04" then response.write Pinstore(i) & " = Matched<p>" end if next %> </body> </html> *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: Strip time from date? Tag: 271984
  - 11
    - User Variable Do you know how to get windows login variables (i.e. the LOGON_USER server variable) from ASP without having to fill in the challenge response message box that automatically appears when you configure IIS to Integrated Windows Security for a particular site? I don't want users to have to log in again to the site as they have already logged in to windows but I want to use their username on the back end to verify permissions. Is it possible? Tag: Strip time from date? Tag: 271979
  - 12
    - Functions vs. subs and role reversal Hi all, First off I know the difference between functions and subs, basically a function returns a value on execution of a code block wheras a sub just executes a code block (more or less). I have found however that if I 'call' a function in the same way as I would a sub the function executes the code as if it were a sub ie: Call openDB 'this is a function which creates a connection object to my database called dbConn which is the available to the rest of my code. openDB is most definitely a function and this method of calling it works perfectly well. My questions are thus: 1) Am I just ignorant of calling procedures? 2) Is it a good idea to call functions like this, or should a sub be a sub and a function be a function? 3) If not a good idea then why not? Any links or thoughts on this 'problem' would be highly appreciated. Colin Mc mahon Tag: Strip time from date? Tag: 271978
  - 13
    - Importing CSV file to VB Script Array I've been working on some coursework that requires the use of an excel spreadsheet and a CSV file to be read into an ASP page and worked with. What I have done is set up an array to store the values from the CSV file and accessed the spreadsheet using an Excel Recordset. For some reason only the first 2 values in the CSV file (stored in the array as the first and last) are comparing properly with values from the spreadsheet. When the comparisons are made I have used a loop to go through all the records in the recordset and then another loop to search the array. If I hard code the values instead of the array values the results are as expected. I've tried making sure all the values are trimmed and preceeded with the "cstr" operation and still no joy. Even when I've written the comparisons to screen it is saying "RGD11 = RGD11 = False" Has any one got any clues as to what is going on??? Tag: Strip time from date? Tag: 271970
  - 14
    - Front Page Server Extention Problem Hi all I have installed Front page server Extention on IIS 5.0 it was working fine. I was able to load project from Visual Interdav and doing well. Yesterday I installed a security update from Microsoft and after that every thing stop working and I am getting the error below when ever I am trying to connect to server using V Interdev. Error Shows that FP Server Extention is not installed but its there even I removed it and installed it back error is still there. "An HHTP error occured. The server could not complete your request. Contact your Internet Service Provider or Web Server administrator to make sure that the server has the FrontPage Server Extensions installed, and that the Web application exists on that server" I dont know about Server Extention too much. If some one know the problem or give any link where I can find more about Server extention will be very thankfull. Kind Regards Fayyaz Tag: Strip time from date? Tag: 271969
  - 15
    - error handling in asp-userfrindly messages hi ... I want to do error handling in my application. I have made a complete application. but when I encounter errors (like mentioned below) I want to do error handling. how can I do it? I mean like in this case I can see if the record is being added duplicate then I can always check for duplicate records and throw a message. but I will face so many errors like this??? do we have a list ..whereby I can get all the error numbers and there meanings and I generate my own user-friendly errors? I hope I am clear..thanks for any suggestion Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again. Tag: Strip time from date? Tag: 271968
  - 16
    - ASP and Excel Hello, in German ASP-Newsgroups nobody had an idea, so I would like to ask the following here: You can simply read the content of an Excel worksheet via ASP by executing a sql-statement like SELECT * FROM [Table1$A:E] That works fine, but how can I search for one special row for example ? I have tried SELECT * FROM [Table1$A:E] WHERE [Table1$D] Like '" & searchstring & "%'; to search a string in column D, but it hadn't worked. Anybody an idea ? Maybe it is a question of the connection drivers ? Should I use the Jet or the Excel drivers ? How the connection-string would look like for the sample above ? Thanks for any help Greetings Thies Tag: Strip time from date? Tag: 271963
  - 17
    - Filepath of include file Hi, Is there a way to determine the filepath of an included file?: First file contains:  <%SomeSub%> Second file Inc_WysiwygEd.asp contains: <% sub SomeSub 'I need to know the URL of the included file here to determine the location of resources like images end sub %> Thanks, Christiaan Tag: Strip time from date? Tag: 271961
  - 18
    - need to refer to a function in another website on IIS I have multiple websites on single IIS. I have a function (in a seperate aspx.vb file) that I want to use for all the default pages on these sites. How do I 'call' this function' from the aspx files without copying the files into each 'bin' folders? what is the syntax for the code (as I am beginner)import, etc, if needed, thanks in advance Joe Tag: Strip time from date? Tag: 271959
  - 19
    - Work locally? Hi, I have included the following code in my asp page. It seems to work fine on my localhost. However when i tried to access the page on other pc in the network, the page could not be displayed, with the error msg internal server error. Is it because the code that i added works only locally and not on a server? Set fso = CreateObject("Scripting.FileSystemObject") Set f = fso.GetFolder("N:\Finance\Systems & Processes\S&P Projects\Proj Finance Intranet Project - Eric\testing\") Set fc = f.Files For Each f1 in fc set rs1 = Server.CreateObject("ADODB.recordset") rs1.Open "Select SectionCode from Dept", conn, adOpenStatic s = mid(f1.name,1,3) do until rs1.eof for each x in rs1.Fields q2= x.value If s = trim(q2) Then set rs2 = Server.CreateObject("ADODB.recordset") set rs3 = Server.CreateObject("ADODB.recordset") rs2.Open "Select Department from Dept where (SectionCode = " & q2 & ")", conn, adOpenStatic rs3.Open "Select Division from Dept where (SectionCode = " & q2 & ")", conn, adOpenStatic Set fsoDepartment = CreateObject("Scripting.FileSystemObject") Set fsoDivision = CreateObject("Scripting.FileSystemObject") 'check if the folder exist If fsoDepartment.FolderExists("N:\Finance\Systems & Processes\S&P Projects\Proj Finance Intranet Porject - Eric\"& rs2.fields(0).value ) Then If fsoDivision.FolderExists("N:\Finance\Systems & Processes\S&P Projects\Proj Finance Intranet Porject - Eric\"& rs2.fields(0).value & "\" & rs3.fields(0).value) Then response.write("Division folder already exist." &"<BR>") Else fsoDivision.CreateFolder("N:\Finance\Systems & Processes\S&P Projects\Proj Finance Intranet Porject - Eric\" & rs2.fields(0).value & "\" & rs3.fields(0).value) End If Tag: Strip time from date? Tag: 271956
  - 20
    - Can't create component in ASP I have a third party COM component registered on my machine which we use to display barcodes on web pages. My problem is that when I try to create the components (2) in ASP I get object creation errors. This would seem to indicate that the component files are not registered correctly or are missing dependencies or something along those lines. However I AM able to create the components in Visual Basic, and also if I install the required files I am using on someone elses machine they do work correctly, and I have re-registered them umpteen times on my machine. i.e. <% Dim BC on error resume next Set BC=Server.CreateObject("IDAuto.BarCode") if err <> 0 then Response.Write("ERROR " & err.number & " - " & err.description) end if %><br><% Dim IX on error resume next Set IX=Server.CreateObject("IDAutomationGDI.ImgX") if err <> 0 then Response.Write("ERROR " & err.number & " - " & err.description) end if %> Produces ERROR -2147319779 - 006~ASP 0177~Server.CreateObject Failed~Library not registered. ERROR 32797 - 006~ASP 0177~Server.CreateObject Failed~800a801d My VB code, Dim BC Set BC = CreateObject("IDAuto.BarCode") Debug.Print BC.FixedResolutionCM , creates and uses the object without issue in VB. BTW I have enabled every permission I possibly can in the IIS folder where the script is resides. Any help appreciated, Dave Tag: Strip time from date? Tag: 271947
  - 21
    - Page Unavailable? I have a site hosted on IIS6 by an ISP. When my page loads, it saves some information from a form into an Access DB, then reads the entire record, including the new data Set Conn... Conn.Open... set RS... Conn.Execute UPDATE mytable WHERE... RS.Open... read data RS.close - set = nothing Conn.close - set=nothing Response.write data The page is actually 20 pages, the text selected to display is chosen by Select Case request.querystring("p"). It's size is 70k. It works fine on LocalHost, but "The page cannot be found.The page you are looking for might have been removed, had its name changed, or is temporarily unavailable." appears about 1 time in 10 on the web site. It then appears OK if the Refresh button is clicked. Any ideas why? (only 1 user logged on, so not too much traffic) Thanks in advance Giles Tag: Strip time from date? Tag: 271946
  - 22
    - Save a file in UTF-8 format from ASP vbscript I need to save a file in UTF-8 format from an ASP file. Using FileSystemObject I can only save them in Unicode (UTF-16, I think) but not in UTF-8: Set zzzz = fso.OpenTextFile(filepath, 2, true, -1) How do I can save my file in UTF-8 format ? I have tried to convert the file to UTF-8, with this code: Dim objStream Set objStream = Server.CreateObject("ADODB.Stream") objStream.Open objStream.Type = adTypeText objStream.Position = 0 objStream.Charset = "utf-8" objStream.LoadFromFile filepath objStream.SaveToFile filepath, adSaveCreateOverWrite objStream.Close set objStream = nothing But, that code doesn't do anything and no error occurs. :-? Thanks in advance for your replays Tag: Strip time from date? Tag: 271945
  - 23
    - Dynamic size page content Hi, As a follow up to my earlier post about dynamically sizing, fitting page content to different screen sizes/resolutions, here are 3 sites that do this: www.cycletrader.com www.sitepoint.com www.fatwallet.com Is it just the use of css, or is there some server-side asp stuff going on? The content on my site is nearly 100% database driven, i.e. little static text. Any clues? Thanks!! Tag: Strip time from date? Tag: 271943
  - 24
    - Inconsistent cookie issue - IIS4 I'm having an inconsistent problem involving cookies. I have attempted to duplicate the OS/browser settings for the remote users in question but I cannot seem to duplicate the problem in any OS (Mac, Linux, Windows). I've gone over and visited one problem site and I couldn't get it to work by playing with security and privacy settings in MSIE. Obviously there is a setting somewhere but I can't find it. I can duplicate the problem by commenting out the ASP code that sets a particular cookie. I also didn't see the cookie get set on the problem system when I was trouble-shooting. I can't have the problem system with me when I code though. :( I won't post the entire project, but here are the parts that seem to be central to the problem... <% Response.Expires=-1 Response.AddHeader "Pragma", "no-cache" response.cookies("epeid") = value '40 characters response.cookies("epeid").Expires = dateadd("n", 7, date() & " " & Time()) response.redirect redirectURL %> It works fine on my systems. It redirects on the problem systems, only they act like the cookie doesn't exist. When I asked the computer to prompt me for each cookie I never saw epeid. On my system when I ask for a prompt it just stalls on that particular cookie. The above code is executed before any headers are written. Thanks for any advice! -- Mike Tag: Strip time from date? Tag: 271935
  - 25
    - input question How can I limit the quantity of characters in an input box I need to limit the input to 10 for example. Tag: Strip time from date? Tag: 271930

Could someone help me work out out a way to either convert a smalldatetime
value from my database(access) to a normal date with out the trailing time.

Is it simple matter of using FormatDate or does one need to do string
maniupulation?

Current
9/13/2003 11:36:00 AM

What I want:
9/13/2003

Thanks
Jason

Top

Re: Strip time from date? by Tom

Tom
Sat Sep 13 12:45:24 CDT 2003

If it's just for display then use FormatDateTime

"jason" <jason@catamaranco.com> wrote in message
news:%23RJkIzheDHA.4024@TK2MSFTNGP11.phx.gbl...
> Could someone help me work out out a way to either convert a smalldatetime
> value from my database(access) to a normal date with out the trailing
time.
>
> Is it simple matter of using FormatDate or does one need to do string
> maniupulation?
>
> Current
> 9/13/2003 11:36:00 AM
>
> What I want:
> 9/13/2003
>
> Thanks
> Jason
>
>
>
>

Top

Re: Strip time from date? by dlbjr

dlbjr
Sat Sep 13 13:14:37 CDT 2003

If all you want to store in the database is the date then set this in the
field properties in access

For presentation purposes use

dtmDate = "9/13/2003 11:36:00 AM" ' rs("date_field")
dtmDate = ConvertDate(dtmDate)

Function ConvertDate(str1)
ConvertDate = "NAD"
If IsDate(str1) Then
ConvertDate= FormatDateTime(str1,2)
End If
End Function

-dlbjr

invariable unerring alien

Top