Display Data Between Commas In Form ASP

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
    - ASP Vbscript Class Includes Hi, I'm running into a problem with VBSCRIPT classes in ASP. I use a seperate file for each class I use. Some of these class files are included in multiple ASP scripts, but are also included in other include files. So if you can't see the problem already, it is that occasionally the class file will be included twice in the same script, relsulting in the following error: Microsoft VBScript compilation error '800a0411' Name redefined /includes/classes/closableobjectlist.asp, line 2 Class ClosableObjectList ------^ Does anyone know a clean solution for this problem? Right now I am just having to be really careful with my includes, but if there was a way I could protect against this, I believe it would be a much more user friendly solution. Thank You Mike Biang Senior Web Application Developer Cramer Development Tag: Display Data Between Commas In Form ASP Tag: 298521
  - 2
    - CDONTS on WINDOWS 2003 Server Hi Some one has posted this question on 10th August, as CDONTS is not working on windows 2003 serever. I have the same problem and I copied CDONTS.DLL from Windows 2000 Server and registered on Win 2003 server but it giving the error on line when I calling method send of the object. Error is Microsoft VBScript runtime error '800a0046' Permission denied I tried to register CDONTS as COM+ with Admin user right to execute but it still giving same error. Any Advise Regards Tag: Display Data Between Commas In Form ASP Tag: 298519
  - 3
    - JS Problem I'm having a problem with JavaScript and ASP that need to be intermixed. I'm querying a database, and creating JavaScript arrays for use on the client side...which works fine. Basically I have two drop down lists, and when you select an item in the first drop down, the items in the second one change. The functionality there is no problem. My problem lies in the fact that I'm embedding ASP code within a javascript function, and it's causing my form to post every time I try to do validation or some other client side function. Is there a simple way around this? Thanks, James Tag: Display Data Between Commas In Form ASP Tag: 298507
  - 4
    - multiple db connections-your advice needed On my website, I want to provide 3 pieces of statistics that will require 3 queries to my SQL database. As much as I'd like these to be live, they are part of a footer that will load each time for about 10 pages on my site. I am thinking that, although they are simple queries, it may be just too much. What do you recommend? I could open the connection, run the query and then close it, each time. Would this be a recommend plan? Or, should I create a daily task that builds a simple text file with those query results and just pull those in each time the footer is loaded? This would not be live, but I can deal with it. What do you all think? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: Display Data Between Commas In Form ASP Tag: 298501
  - 5
    - Non friendly error messages I have a little gripe with my ASP pages, for some reason I am not getting error messages I would expect and don't know if it's an ASP thing, browser thing or IIS problem. I use option explicit to ensure I define every variable. When I have forgotten to define one the error page just dislays the 500.100 error screen. I have ensured that in my IE 6 that 'show friendly http error messages' is unchecked but have the problem still. I would have expected it to display some output and then state the error later in the page. How can I achieve this as I am totally stumped now. :o/ Thx Stu Tag: Display Data Between Commas In Form ASP Tag: 298500
  - 6
    - Example code Hi all. First of all, I am totally new to ASP! I want to create a webpage that a user can fill in and then press submit. Upon pressing submit, the server will create an email and then mail me the contents of the form. I would also like the webpage to automatically get someones Windows 2000 user id and include that in the email. I have been googling around and have not been able to find any example scripts for what I need. So, I am wondering if anyone would be kind enough to post one.....? Thanks! Tag: Display Data Between Commas In Form ASP Tag: 298498
  - 7
    - How to access variables (form text box values) on same form? Hello Asp Programmers, I have a question. I have a form on an ASP page that has 5 text boxes, for data entry. I am trying to get data from the text box, and pass it to a hidden text box on the form. The hidden text box is called "MyDateTime" (a SQL date and time value). I am attempting to concatenate data from two other textboxes (one for date and one for time) to give a string like : "8/8/2004 8:00 AM" I am trying to use the following: <% Dim time Dim date Dim dateAndTime time = Request.Form("usertime") date = Request.Form("userdate") dateAndTime = FormatDateTime(time & " " & date,vbGeneralDate) in the html for MyDateTime hidden field i use this: value= "<%=dateAndTime%> for some reason the time and date fields, do not have data in them (although typed on form) I want to use data typed in the text boxes including the dateAndTime value and insert those values in a database. What am I not doing here?? Thanks for your help (previous posts answered and provided fixes for me) eric Tag: Display Data Between Commas In Form ASP Tag: 298497
  - 8
    - Page Expires - even on Back button? Hi All! At the moment, I have this in the footer section of my login protected pages: <%Response.Expires=-1%> But I notice this doesn't prevent me from being able to press 'Back' after I have logged out and view the same content - content I should not view if I have logged out! How do I force the page to expire then? Any advice would be most welcome! Rob :) Tag: Display Data Between Commas In Form ASP Tag: 298495
  - 9
    - ASP CDO Problems Hey All, I have MDaemon running locally on the server, and that is what I want to send mail through. It's a normal mail server which doesn't require an access list, I just have a list of trusted IP's to accept mail from. This is the code I use on my ASP page <% 'Send email using CDO. Public Function sendEMail( fromAddress, toAddress, subject, body ) Dim outgoingSMTPServer, smtpUserID, smtpPassword Dim objMail 'Trim all the parameter values. fromAddress = Trim( fromAddress ) toAddress = Trim( toAddress ) subject = Trim( subject ) outgoingSMTPServer = "" smtpUserID = "" smtpPassword = "" 'outgoingSMTPServer = Application( "OutgoingSMTPServer" ) 'smtpUserID = Application( "SMTPUserID" ) 'smtpPassword = Application( "SMTPPassword" ) 'Correct COX SMTP address. outgoingSMTPServer = "127.0.0.1" 'Make sure that we have from, to address and body. If fromAddress = "" Or toAddress = "" Or body = "" Then sendEMail = False Exit Function End If 'Create the object. Set objMail = Server.CreateObject( "CDO.Message" ) objMail.From = fromAddress objMail.To = toAddress objMail.Subject = subject objMail.HTMLBody = body 'Send using the specified SMTP server. objMail.Configuration.Fields.Item _ ( "http://schemas.microsoft.com/cdo/configuration/sendusing" ) = 2 'Name of the smtp server name. objMail.Configuration.Fields.Item _ ( "http://schemas.microsoft.com/cdo/configuration/smtpserver" ) = "localhost" 'Default port. objMail.Configuration.Fields.Item _ ( "http://schemas.microsoft.com/cdo/configuration/smtpserverport" ) = 25 'Set the user ID and password if available. If smtpUserID <> "" And smtpPassword <> "" Then objMail.Configuration.Fields.Item _ ( "http://schemas.microsoft.com/cdo/configuration/smtpauthenticate" ) = 1 'Your UserID on the SMTP server objMail.Configuration.Fields.Item _ ( "http://schemas.microsoft.com/cdo/configuration/sendusername" ) = smtpUserID 'Your password on the SMTP server objMail.Configuration.Fields.Item _ ( "http://schemas.microsoft.com/cdo/configuration/sendpassword" ) = smtpPassword objMail.Configuration.Fields.Item _ ( "http://schemas.microsoft.com/cdo/configuration/smtpusessl" ) = False objMail.Configuration.Fields.Item _ ( "http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout" ) = 60 End If 'Update the configuration. Call objMail.Configuration.Fields.Update() 'Send the message Call objMail.Send() 'Release the object. Set objMail = Nothing sendEMail = True Exit Function End Function %> That function is in it's own asp page. I just include it when necessary. when I call the function and pass it the appropriate parameters, it seems to go through without erroring, but of course I never get the email, and the MDaemon logs dont even show an attempted connection. Any ideas? Tag: Display Data Between Commas In Form ASP Tag: 298494
  - 10
    - Web Publish behind ISA I have been assigned a perm IP address for my registered domain along with a gateway and two dns addresses. I am using one W2003 Server for domain controller and ISA. My local address is 192.xxx.xxx.xxx Q1:what do I put in the Lat for internal addresses? Q2: Does mydomain.com go into the LDT? Q3:More to come...... -- Generations Ranch Tag: Display Data Between Commas In Form ASP Tag: 298493
  - 11
    - IIS 5.0 Config for Asp hosting trouble Hi I am having some trouble getting a asp page to load. Im a noob to the asp side. I have followed knowledege base Article 301305. I am running 2000 adv, IIS 5.0 I have the following settings to the folder that has the asp. Application settings application name: upload Starting poing: <website>\upload Execute Permissions: Scripts Only App Protection: High(isolated) Is there anything else i need to do? I installed the lockdown awhile back...does that interfere? Thanks, James Tag: Display Data Between Commas In Form ASP Tag: 298484
  - 12
    - Managing a Database using Word / IIS I have a fairly ambitious client who would like to offload the management of intranet content to other individuals in the organization. For the project to be successful, the data management must be as painless as possible. Accordingly, the ideal interface for data input is Microsoft Word, as most users are extremely comfortable working with it. I would like to be able to create word templates/forms which are dynamically populated with data from an database, then downloaded to the client PC. Once the data is updated, I would like the user to upload their files back to the server, which will in turn update its database and maintain an audit-trail of all changes. Can this be done? I'm assuming that if I install Office on the server, it would be feasible using the office API, but I would love to be able to do this without office on the server.. any hints / suggestions would be HUGELY appreciated! Thanks, Aaron Tag: Display Data Between Commas In Form ASP Tag: 298479
  - 13
    - Urls messy - extra characters not expected? After peforming a basic redirect with two query string parameters I load the page successfully...however the url does not look pretty...can anyone tell me why these percentage signs and extra symbols are showing up: http://69.2.200.70/dev/1/doc3.asp?vID=12&u_FromURL=http://69.2.200.70/dev/1/link.asp&bhjs=1&bhrf=http%3A%2F%2F69%2E2%2E200%2E70%2Fdev%2F1%2Flogon%2Easp%3FCookieChk%3DDisabled%26u%5FFromURL%3Dhttp%3A%2F%2F69%2E2%2E200%2E70%2Fdev%2F1%2Flink%2Easp%26u%5FCurrentURL%3D%2Fdev%2F1%2Fdoc3%2Easp&bhqs=1 Is this related to UNENCODE or something along these lines...? I know percentage symbols traditionally stand for 'spaces' but this seems different.... Thanks Jason Tag: Display Data Between Commas In Form ASP Tag: 298469
  - 14
    - ASP Web Application Timeout Greetings, I have an ASP web application that is written in VBScript, uses MS Access 2000 for record storage, and is running on a Windows 2000 Professional SP4 computer with IIS 5. The application can be started, have a record updated and stored, and then terminate successfully on demand. I would like to have the application remain active on the IIS Server without timing out, but when I attempt to run it in that way, I receive a message (usually first thing in the morning) of "An Eror Occurred - Your Session Timed Out". I have set the Session Timeout feature in IIS to 1440 minutes, and the Server Script Timeout feature in IIS to 1000000 seconds, but the application still times out each morning. Can anyone tell me what else I need to do to keep this application available all day and all night? Thanks! MrLr Tag: Display Data Between Commas In Form ASP Tag: 298468
  - 15
    - localization and ASP Hi, I have a simple 'user' table (SQL Server 2000) and an ASP form that connects to it. I want users of all languages to be able to type in their registration info, in their own language (chinese, german, etc..), store it that way, then have another page that displays it. Is there anything specific I need to do with ASP (classic, not .NET), to handle this? Thanks Tag: Display Data Between Commas In Form ASP Tag: 298464
  - 16
    - Out of memory error message. I get the following error message from an ASP page that we have: METHOD: POST ERROR DESCRIPTION: 007~ASP 0100~Out of memory~Unable to allocate required memory. ERROR NUMBER: -2147024882 ERROR SOURCE: Response object Does anyone out there have any ideas? Please let me know if you need any more information ... I am not sure why this message has suddenly started to pop up. I checked the system logs and cannot see any particular memory loss related message so I don't know. TIA, Rohan Tag: Display Data Between Commas In Form ASP Tag: 298463
  - 17
    - How can I test to see whether a particular object variable is defined? Hi Gang, I want to test and find out whether or not a particular variable object has been defined. I need to know whether or not a recordset has already been defined in the current script. However, my script crashes even though I've disabled error handling, which doesn't make a whole lot of sense to me, but anyways :). Here's my code: --------------------------------------------------- on Error Resume Next If objRS.Fields.GetCount > 1 Then RestartRecordSet() Else OpenConnection() End If On Error Goto 0 ----------------------------------------------------- Is there some command like If isdef(objRS) then... or something to that effect? Also is .GetCount the correct command? I think it is, but MSDN help has a special way of giving too much information. Thanks in advance, Christian Blackburn Tag: Display Data Between Commas In Form ASP Tag: 298448
  - 18
    - Source Control for Web Projects What are people using for source control for ASP and HTML files? We have a typical scenario here, a handful of developers working locally on development, an internal staging server, then an external-facing production web server, all Windows 2003. I'm quite familiar with Visual Sourcesafe, but it doesn't easily allow (to my knowledge, anyway) to move ad-hoc files through to production to fix high severity bugs on the fly. It requires project labeling or "pinning" other files that have been checked-in but aren't ready for prime time. Other solutions? thx Jeff Tag: Display Data Between Commas In Form ASP Tag: 298447
  - 19
    - Converting hrs and min to just min I am using two fields on a form to capture time someboby is working. The fields are hours and minutes. How can I when submitting to the db take both fields and convert them to a single field in the db as minutes? Thanks Carmen Tag: Display Data Between Commas In Form ASP Tag: 298444
  - 20
    - Where do I go wrong when using URLencode? <A href= "GenericUploader.asp?SavePath=<%=server.URLEncode("D:\my new web site\U") %>">folder name</A> the link above does not seem to produce the appropriate query string value upon being clicked on. That is, when an internet user clicks on that link, the Internet Explorer opens the GenericUploader.asp web page, and the code in that asp web page responsible for picking up the value corresponding to the argument 'SavePath' (i.e, request.querystring("SavePath")) returns solely the first word of the value rather than the entire CORERECT value, which is 'D:\my'rather than 'D:\my new web site\U'. Can anyone tell me what needs to be done? Thank you in advance Avi Tag: Display Data Between Commas In Form ASP Tag: 298441
  - 21
    - Error "cannot update database or object is read-only" when updating MDB file in ASP I have IIS installed on XP Professional workstation machine. I have an ASP page that open connection to an Access database, then when trying to update the database, it gave me the error "cannot update database or object is read-only". This is a workstation machine, not connected to any other computer, and I login to the PC using an administrator account. I already check the .MDB file is NOT read-only. But, I do not see the .LDB file. Manually, I can update the .MDB file, and I can create a new file on the directory where the MDB file is. The directory where the MDB is located says "read only", then I uncheck the read only, click apply and OK. When I go back to the property of the directory, it went back to "read only". This seems to happen on any XP machine. But, I can still manually create a new file, delete a file, rename a file on this directory. The MDB file used to have a password, when it did, I got the error on the statement sds("SECURITY_EXTRA1") = sExtra When I got rid of the password, I got the error on the statement sds.update How can I fix this problem ? Thank you. Here are my codes: Set dbConnection = Server.CreateObject("ADODB.Connection") session("CustomersDB_ConnectionString") = "dsnName" Session("CustomersDB_RuntimeUserName") = "userId" Session("CustomersDB_RuntimePassword") = "passw" dbConnection.Open Session("CustomersDB_ConnectionString"), Session("CustomersDB_RuntimeUserName"), Session("CustomersDB_RuntimePassword") Set sds = Server.CreateObject("ADODB.Recordset") sds.ActiveConnection = dbConnection sds.CursorType = adOpenKeyset sds.LockType = adLockOptimistic sds.Source = "select SECURITY_ID,SECURITY_EXTRA from SECURITY where SECURITY_USERID = 'abc'" sds.Open sds("SECURITY_EXTRA1") = sExtra sds.update Tag: Display Data Between Commas In Form ASP Tag: 298438
  - 22
    - upload sql files from IIS to sql We have clients upload sql files to a folder on an IIS 6.0. The sql file are then processed by a scheduled task that runs once every 10mins to process the file with oSQL. With oSQL the files upload the data to a 2 tier SQL server. The developers are complaining about performance and are saying it is the OS/hardware. I have Profmon on the IIS server and 2 tier SQL server. Both only peak at %5 usage on processor memory stays close to the same. I believe that it would better to have IIS make a connection to the SQL server and upload the record directly. What do you think? and any examples would be nice or URL that talks about how to do this. Thanks for you ideas and help!! Tag: Display Data Between Commas In Form ASP Tag: 298434
  - 23
    - Using special characters within a string Hi Doing my best to understand why I cant insert a vbcrlf or an equivalent into this piece of code that read messages from an SQL DB. The messages it takes read into a marquee fine but I want the Marquee to scroll up instead of horizontally and I need new line spacings else the mesages are difficult to read. At present we use the strNewTextDelimitor and I am unable due to syntax or perhaps idioscy to find a way of adding the VBCRLF or any derivative into this code so......I am sure its simple but could do with a hand...Tx in advance. This outout is pumped to a page back to a page which will not pick up the new messages if I use any of the following characters (even without placing them into a variable) vbcrlf vbcr vblf chr(13) chr(10). Do While Not adoRecordset.EOF ' Add the current message in the recordset to the string that is returned strNewText = strNewText & strNewTextDelimiter & Trim(adoRecordset.Fields("Message").Value & "") ' Set the delimiter ready for the next message. strNewTextDelimiter = " * * " ' Get the next message from the recordset adoRecordset.MoveNext Loop The code above works fine but the moment I attempt to add the special characters the scripts do not run and the web page will not update :-( , Tis driving me crackers! Cheers, Tag: Display Data Between Commas In Form ASP Tag: 298428
  - 24
    - Centrilized Data Connection Hi, I have several ASP pages, and some of them are using the same access Database and table. Can I put the connection string somewhere centralized, so I can link to it ? Thx in advance TNGgroup Tag: Display Data Between Commas In Form ASP Tag: 298419
  - 25
    - Put a Timer on the web form Hi, I'm new to ASP.NET. I have an WebForm1 which contained a ListBox1. I have drag a Timer on the form. In the timer1_Elapsed() function , I have add the line ListBox1.Items.Add("haha"). But when the timer elapsed, it called that line of code, but the ListBox1 didn't show "haha". Would you tell me what I have missed? I'm using C#/ASP.NET Best regards, C Learner Tag: Display Data Between Commas In Form ASP Tag: 298418
- Next
  - 1
    - How can I check that the form is not posted from a local html page As title Tag: Display Data Between Commas In Form ASP Tag: 298415
  - 2
    - asp with radio buttons on forms Hello all... I have a page that will be performing a search. The search consists of 3 radio button options. The first 2 will search the entire web through google and the site as indexed by google. The 3rd option I want to search the site using MS-Index Server. I can get them to run individually but I'm not sure how to set the parameters and test for the 3rd radio button (index server) selected on the page. I thought that, for example, my Searchinc.asp could have an If...then...else: <form action="../gw/incl.idq" method="GET"> <td valign="bottom" align="right" width="100%"> <input type="HIDDEN" name="CiScope" value="/geo_portal/gw"> <input type="HIDDEN" name="CiMaxRecordsPerPage" value="10"> <input type="HIDDEN" name="TemplateName" value="incl"> <input type="HIDDEN" name="CiSort" value="rank[d]"> <input type="HIDDEN" name="HTMLQueryForm" value="../gw/incl.asp"> </td> <td width="1"> </form> <%else%>  <form method="get" action="http://www.google.com/custom" target="google_window"> <%end if%> <table width="770" height="32" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF"> <tr class="geoTopLinks"><td width="99" height="32" align="left" valign="top" nowrap="nowrap"> <a href="http://www.google.com/"> <img SRC="http://www.google.com/logos/Logo_25wht.gif" alt="Google" height="32" border="0"></img></a> </td> <td nowrap> <input type="hidden" name="domains" value="www.site.com"></input> <input type="text" name="q" size="15" maxlength="255" value=""></input> <input type="submit" name="sa" value="Search"> </input> </td> <td width="342" height="32" nowrap><font size="-1" color="#000000"> <input type="radio" name="sitesearch" value=""> <span class="Verd10pt">Web <input type="radio" name="sitesearch" value="sitename"> GeoPlace <input type="radio" name="sitesearch" value="geoworld" checked> GeoWorld </span></font><br> <input type="hidden" name="client" value="pub"> </input> <input type="hidden" name="forid" value="1"> </input> <input type="hidden" name="channel" value="a number"> </input> <input type="hidden" name="ie" value="ISO-8859-1"> </input> <input type="hidden" name="oe" value="ISO-8859-1"> </input> <input type="hidden" name="safe" value="active"> </input> <input type="hidden" name="cof" value="big number"> </input> <input type="hidden" name="hl" value="en"> </input> </td> <td width="133" nowrap> The google part works just fine, I can't seem to get the index server piece to work.... Can anyone give me any suggestions? Thanks in advance... Brian Tag: Display Data Between Commas In Form ASP Tag: 298394
  - 3
    - how do i allow access to a shared folder? how can i allow access to a shared network folder? i am trying to give access to my as pages only. i don't want just anyone to type in the path of my files. i can't seem to do this with a shared folder. -- 5khzgjf9e001@sneakemail.com Tag: Display Data Between Commas In Form ASP Tag: 298392
  - 4
    - using ASP and parametized query Per a previous suggestion, I'm trying to use a parametized query in Access 2002. The query functions properly in Access. Now I'm trying to call it from ASP. I'm using code I found at http://www.xefteri.com/articles/apr302002/default.aspx and trying to adjust for my needs. I'm getting this error. The query is there and functioning. It appears that I'm not connecting. Can I get some more insight? thanks! ------------------------------ Microsoft VBScript runtime (0x800A01A8) Object required: 'qry_FindSongs 'White' ------------------------------ My connection string is ------------------------------ Dim conn, mdb, mdw, MM_GenKAccess_STRING set conn = CreateObject("ADODB.Connection") conn.Mode=adModeRead mdb = Server.MapPath("songs.mdb") mdw = Server.MapPath("system.mdw") MM_GenKAccess_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; " & _ "Data Source=" & mdb & ";" & _ "Jet OLEDB:Database Password=xyz;" & _ "Jet OLEDB:System database=" & mdw conn.open MM_GenKAccess_STRING ------------------------------ <% OPTION EXPLICIT %> <% Dim T T = "%" If (Request("title") <> "") Then T = Request("title") End If %> <% Dim A A = "%" If (Request("artist") <> "") Then A = Request("artist") End If %> <% Dim C C = "%" If (Request("category") <> "") Then C = Request("category") End If %> <% Dim TY TY = "%" If (Request("type") <> "") Then TY = Request("type") End If %> <% Dim M M = "%" If (Request("manuf") <> "") Then M = Request("manuf") End If %> <% Dim SA SA = "%" If (Request("singleartist") <> "") Then SA = Request("singleartist") End If %> <% Dim rsResults Set rsResults = Server.CreateObject("ADODB.Recordset") rsResults.ActiveConnection = MM_GenKAccess_STRING rsResults = "qry_FindSongs '" & T & "', '" & A & "', '" & C & "', '" & TY & "', '" & M & "', '" & SA & "'" rsResults.Open rsResults, 0, 4 %> Tag: Display Data Between Commas In Form ASP Tag: 298391
  - 5
    - asptxn.dll in Windows 2000 but not in Windows 2003 Hello All This might just be my ignoranace. --------------------------- The asptxn.dll exists on my Windows 2000 box: C:\WINNT\system32\inetsrv>dir asptxn.dll Volume in drive C has no label. Volume Serial Number is 5839-8874 Directory of C:\WINNT\system32\inetsrv 06/19/2003 01:05p 30,480 asptxn.dll 2 File(s) 369,184 bytes 0 Dir(s) 264,912,896 bytes free -------------------------- However, on my Windows 2003 box: C:\WINNT\system32\inetsrv>dir asptxn.dll Volume in drive C has no label. Volume Serial Number is 7CFC-DDD5 Directory of C:\WINNT\system32\inetsrv File Not Found Does anyone know if (a) I missed an installation step (b) If there is a replacement for asptxn.dll that I should be using (c) If there is another location that I should search for this dll. Actually, I searched the whole filesystem and didnt find anywhere. Any help would be appreciated. Please respond to this post. Thanks -R Tag: Display Data Between Commas In Form ASP Tag: 298389
  - 6
    - http_referer empty? Firewalls? Can one reliably use http_referer to track a user page selections as I appear to be getting BLANK values? I have read that company firewalls etc block this method.... Thanks jason Tag: Display Data Between Commas In Form ASP Tag: 298376
  - 7
    - Converting 25062002120236 to a date! How can I convert a string such as 25062002120236 into a date (25-06-2002 12:02:36). I have tried using the CDate() & ISDate() functions but they don't recognise and convert this into a date. Thanks in advance, Quintus Tag: Display Data Between Commas In Form ASP Tag: 298373
  - 8
    - Cookies being reset or disappearing mysteriously My website uses cookies to persist a certain amount of data on the client. However, occasionally the cookies will disappear or be set to an empty string for no discernable reason. It does not happen in our development environment at all, but does happen in our production environment. We looked at all the likely settings and they were identical on both the production and live servers. We set the cookie domain properly and the cookie path. Has anyone seen similar behavior? And if so, what did you do about it? What IIS settings should I be looking at? Could it be a service pack that was installed on one machine but not another? Any ideas, thoughts or advice would be appreciated. Thanks for any help! Richard Tag: Display Data Between Commas In Form ASP Tag: 298370
  - 9
    - Script to format existing Access table into wall calendar format? I have the tables set up in Access, viewing in column format on ASP pages but now the company wants the schedule reports to be in a wall-calendar type format. I've searched and found calendar scripts but I need one that's creates a table resizable to a report size format. Using the existing MS Access db I've written is also a plus. Any suggestions on where to start? TIA! Lisa Tag: Display Data Between Commas In Form ASP Tag: 298369
  - 10
    - HTMLBody and variable Hi everybody, It seems that a variable cannot be assign to HTMLBody field. Am'I doing something wrong? - this line write a bold html phrase in the email body .HTMLBody = "<HTML><HEAD><BODY><B>Here is the text body</BODY></HTML>" - this line produce an empty body. The variable TableData contains all the required HTML to construct the table. I Use Response.Write and see all the code in it.. .HTMLBody = "<HTML><HEAD><BODY>" & TableData & "</BODY></HTML>" thanks in advance Tag: Display Data Between Commas In Form ASP Tag: 298364
  - 11
    - Build a form - function - combo/select boxes? Is it possible to extend this function to dynamically create a combo boxes from the db table....How would do this...I tried passing a 'Select' type to the function but got a blank entry....Any ideas? function BuildInput(sType,sName,sValue,iSize,iLength) select case sType case "text": BuildInput = "<INPUT TYPE=""text"" NAME=""" & sName & """ VALUE=""" & sValue & """ SIZE=""" & iSize & """ MAXLENGTH=""" & iLength & """>" case "password" BuildInput = "<INPUT TYPE=""password"" NAME=""" & sName & """ VALUE=""" & sValue & """ SIZE=""" & iSize & """ MAXLENGTH=""" & iLength & """>" case "submit" BuildInput = "<INPUT TYPE=""submit"" NAME=""" & sName & """ VALUE=""" & sValue & """>" end select end function Response.Write(BuildForm("edituser","post")) Response.Write(BuildInput("hidden","u_id",Request.QueryString("u_id"),"","") ) Response.Write("<TABLE>") Response.Write("<TR><TD>User Name</TD><TD>" & & BuildInput("text","u_name",escapeString(oRS.fields("u_name")),20,50) & "</TD></TR>") Response.Write("<TR><TD>Password</TD><TD>" & BuildInput("text","u_password",oRS.fields("u_password"),12,12) & "</TD></TR>") Response.Write("<TR><TD>First Name</TD><TD>" & BuildInput("text","u_firstname",escapeString(oRS.fields("u_firstname")),20,5 0) & "</TD></TR>") Response.Write("<TR><TD>Last Name</TD><TD>" & BuildInput("text","u_lastname",escapeString(oRS.fields("u_lastname")),20,50) & "</TD></TR>") Response.Write("<TR><TD>Email Name</TD><TD>" & BuildInput("text","u_email",escapeString(oRS.fields("u_email")),20,50) & "</TD></TR>") Response.Write("<TR><TD COLSPAN=2>" & BuildInput("submit","action",ACTIONSAVE,"","") & "</TD></TR>") Response.Write("</TABLE>" Many thanks Jason Tag: Display Data Between Commas In Form ASP Tag: 298354
  - 12
    - ASP object required error - vbscript Dear Group I am trying to use the following code to refer to a form and control on my form. I am supposed to be using VBSCRIPT for this code. I always get an "object required: 'document' " error: <% Dim Myform Set Myform = document.forms.thisform Myform.textbox1.value = "fish" %> None of this code will work. Always get an error. Using Visual Interdev, plain ole ASP, and vbscript, and Win XP Pro with IIS 5.1 What am I missing or doing wrong??? Thanks eric Tag: Display Data Between Commas In Form ASP Tag: 298353
  - 13
    - Loop with Read Only cursor? Hello, I posted a question about looping with Select in a While loop, a few days ago. Repliers to my post advised me that a Cursor would be much better (thanks all for your replies). I found a looping example using cursors on the net, but I don't know how to declare a read only cursor. Note: my objective is to simulate an array of field names for creating an xml doc/string (to use with OpenXML function). So I created a small table with 22 field names (22 rows). Originally, I had 2 columns - a RowNum col and a fldName col. But with the following example using a Cursor, it seems that I only need 1 column, the fldName col, although this seems like more lines of code than the Select method. The cursor example follows. The question is "How to declare a read only cursor". I also included my Select example - actually the full UDF using Select in the While loop - if anyone could advise me between the two examples which would be more suited for my situation. Cursor Example ----------------------------------------------------- declare @fldName varchar(50) declare @RowNum int declare fldList cursor for select fldName from tblflds OPEN fldList FETCH NEXT FROM fldList INTO @fldName set @RowNum = 0 WHILE @@FETCH_STATUS = 0 BEGIN set @RowNum = @RowNum + 1 print cast(@RowNum as char(2)) + ' ' + @fldName FETCH NEXT FROM fldList INTO @fldName END CLOSE fldList DEALLOCATE fldList -------------------------------------------------------- UDF using Select in While loop Example ---------------------------------------------------- CREATE FUNCTION ConvertToXML( @str1 varchar (8000)) --@str1 contains a list of values from external source --UDF will create xml string by adding a fieldname to --each value from @str1, comma delimited returns varchar (8000) as begin declare @fld varchar(255) declare @fldNum int declare @rownum int --used to increment Select statement declare @xml varchar(8000) --resultant xml string declare @val varchar(255) --each value in @str1 declare @pos1 int --get comma delimeter position of @str1 declare @pos2 int --get comma delimeter position of @str1 set @xml = '<ROOT><Worktable ' set @rownum = 0 set @pos1 = 1 select top 1 @fldNum = rownum, @fld = fldName from tblflds while @rowNum < 22 begin set @pos2 = charindex(',', @str1, @pos1) set @val = substring(@str1, @pos1, @pos2 - @pos1) set @xml = @xml + @fld + '="' + @val + '" ' select top 1 @fldNum = rownum, @fld = fldName from tblflds where rownum > @fldnum set @rowNum = @rownum + 1 set @pos1 = @pos2 + 1 End set @xml = substring(@xml, 1, len(@xml)) set @xml = @xml + '/></ROOT>' return @xml end ---------------------------------------------------------- This UDF works fine with the Select loop. But if this is a kludge and the cursor method would be more correct/professional/better habit to be in, please advise. I am also open to suggestions if there is an easier way to parse @str1 or create @xml. Thanks, Ed Tag: Display Data Between Commas In Form ASP Tag: 298350
  - 14
    - SQL statement error fixed, now wrong data appending Hey guys.... I put an error-handling in my page and have it posted at the complete end of the code, see below(when people were putting in 's I was getting the delimiter errors). Great, I understand that now and it seems to be fixed but the data I'm pulling from the HTML fields is not being appended correctly do my Access DB....The field in the DB now reads " ' ". I understand why it does that (my function) but what I need it to read is whatever data was entered into my text area named "comments". I tried to change the line of code in the SQL statement to read DoubleUpQuotes(comments) but that didn't work....Any help? The page processes, which is a step in the right direction but fixing one thing has broken another.... All of the text input boxes need to have this error-handling capability... <% Mode = request.form("mode") Name = request.form("name") -DROP DOWN BOX Shift = request.form("shift") -RADIO BUTTON Wave = request.form("wave") -TEXT INPUT BOX Carton = request.form("carton") -TEXT INPUT BOX Location = request.form("location") -TEXT INPUT BOX License = request.form("license") -TEXT INPUT BOX Sku = request.form("sku") -TEXT INPUT BOX Qty = request.form("quantity") -TEXT INPUT BOX Reason = request.form("reason") -DROP DOWN BOX Comments = request.form("comments") -TEXT INPUT BOX if mode = "Send" then '***************************************************************************** '* DATABASE APPENDING * '***************************************************************************** 'create db connection Set dbconn = Server.CreateObject("ADODB.Connection") 'open db in a DSN-less method dbconn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE="& Server.MapPath("/jax/wh/Online_Forms/Secured_Archives/search_files/shortage.mdb") 'SQL statement to be run stateSQL = "INSERT INTO shortage (name, shift, wave, carton, location, license, sku, qty, reason, comments)" &_ "VALUES ('" & name & "','" & shift & "','" & wave & "','" & carton & "','" & location & "','" & license & "','" & sku & "','" &_ qty & "','" & reason & "','" & DoubleUpQuotes(strFormElement) & "')" 'display results of statement on screen for testing purposes Response.Write(stateSQL) 'remind the SQL statement who it works for dbconn.Execute(stateSQL) 'smack around the db connection until it lets go dbconn.Close 'kill the connection with extreme prejudice set dbconn = nothing '***************************************************************************** '* FILE APPENDING * '***************************************************************************** ' Create a text file shortage = Server.MapPath("/jax/wh/Online_Forms/Secured_Archives/Archive_TextFiles/Shortage_File.txt") Set fileobject = Server.CreateObject("Scripting.FileSystemObject") Set textfile = fileobject.OpenTextFile(shortage, 8) ' Append to the newly created text file textfile.writeline "<BR>" textfile.writeline "<BR>" textfile.writeline "<b>Name</b> :" & Request.form("name") textfile.writeline "<BR>" textfile.writeline "<b>Shift</b> :" & Request.form("shift") textfile.writeline "<BR>" textfile.writeline "<b>Wave</b> :" & Request.form("wave") textfile.writeline "<BR>" textfile.writeline "<b>Carton</b> :" & Request.form("carton") textfile.writeline "<BR>" textfile.writeline "<b>Location</b> :" & Request.form("location") textfile.writeline "<BR>" textfile.writeline "<b>License</b> :" & Request.form("license") textfile.writeline "<BR>" textfile.writeline "<b>SKU</b> :" & Request.form("sku") textfile.writeline "<BR>" textfile.writeline "<b>Quantity</b> :" & Request.form("quantity") textfile.writeline "<BR>" textfile.writeline "<b>Reason</b> :" & Request.form("reason") textfile.writeline "<BR>" textfile.writeline "<b>Comments</b> :" & Request.form("comments") textfile.writeline "<BR>" textfile.writeline "<b>Date/Time Received</b> :" & FormatDateTime(Now,4) textfile.writeline "<BR>" textfile.writeline "<HR>" ' Close the file and set object to nothing textfile.close Set fileobject = nothing '************************************************** '* EMAIL STATEMENT * '************************************************** Set Mail = Server.CreateObject("Persits.MailSender") Mail.Host = "SMTP1" ' Specify a valid SMTP server Mail.From = "someone@somewhere" ' Specify sender's address Mail.FromName = "Test Warehouse Shortage" ' Specify sender's name Mail.AddAddress "someoneelse@somewhere" 'email address that will receive form submission Mail.IsHTML = True Mail.Subject = "Test Warehouse Shortage" Dim mail_body mail_body = "Name: " & request.form("name") & "<br>" &_ "Shift: " & request.form("shift") & "<br>" &_ "Wave: " & request.form("wave") & "<br>" &_ "Carton: " & request.form("carton") & "<br>" &_ "Location: " & request.form("location") & "<br>" &_ "License: " & request.form("license") & "<br>" &_ "SKU: " & request.form("sku") & "<br>" &_ "Quantity: " & request.form("quantity") & "<br>" &_ "Reason: " & request.form("reason") & "<br>" &_ "Comments: " & request.form("comments") & "<br>" mail.body = mail_body & "Submitted IP Address: " & request.servervariables("REMOTE_ADDR") On Error Resume Next Mail.Send If Err <> 0 Then Response.Write "Error encountered: " & Err.Description End If End if %> <html> HTML FORM DATA IS IN HERE. </html> <% Function DoubleUpQuotes(strText) DoubleUpQuotes = "'" & Replace(strText, "'", "''") & "'" End Function %> Tag: Display Data Between Commas In Form ASP Tag: 298347
  - 15
    - Problem sending mail (CDOSYS) Hi everybody, The following code for sending email (found on msn I think) works find when used in a .VBS file. I double click the file and the mail is send. When I use the same code in my .ASP application I get the following message: "The pickup directory path is required and was not specified" Where to specify that directory? As stated in the article http://www.aspfaq.com/show.asp?id=2418. I did 'web share' c:\inetpub\mailroot\pickup and got no result. It seems that sending email using a .VBS file does not use the same ressource as using a .ASP file even if the component is the same (CDOSYS)! How can'I solve this problem? here is the code i use in the .asp file: Dim iMsg Dim iConf Dim Flds Const cdoSendUsingPort = 2 set iMsg = CreateObject("CDO.Message") set iConf = CreateObject("CDO.Configuration") Set Flds = iConf.Fields With Flds .Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 1 ' local server .Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "http://127.0.0.1" .Item("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = 10 .Item("http://schemas.microsoft.com/cdo/configuration/smtpServerPort") = 25 .Update End With With iMsg Set .Configuration = iConf .To = "<to@x.com>" 'Enter a valid email address. .From = "<from@x.com>" 'Enter a valid email address. .Subject = "This is a test CDOSYS message (Sent via Port 25)" .HTMLBody = TableData .Send End With Set iMsg = Nothing Set iConf = Nothing Set Flds = Nothing Thank's in advance serge Tag: Display Data Between Commas In Form ASP Tag: 298343
  - 16
    - MS SQL CE I have just installed and setup, but when I try to call the sscesa20.dll, I get a page cannot be displayed error. Also in event view I see a W#SVC error event ID 36 in the application log every time it try to call this dll. It says "the server failed to load the application /LM/W3SVC/3/Root, No such interface is supported" does anybody have any ideas as to why I'm getting this? Tag: Display Data Between Commas In Form ASP Tag: 298339
  - 17
    - ms word What is the best way to generate a word-document with wbscript code? I have a text string I would like to save as a word document on the server. Any tutorials? or code examples? Thanks in advance, Christopher Brandsdal Tag: Display Data Between Commas In Form ASP Tag: 298337
  - 18
    - Begginer guide for asp I am looking for some beginner guide for someone to learn asp - tutorials, examples etc Thanks -- Louise Woodward Opal Telecom Application Team Irlam Tel - 01612222443 lwoodward@opaltelecom.co.uk This communication together with any attachments transmitted with it ("this E-Mail") is intended only for the use of the addressee and may contain information which is privileged and confidential. If the reader of this E-Mail is not the intended recipient or the employee or agent responsible for delivering it to the intended recipient you are hereby notified that any use, dissemination, forwarding, printing or copying of this E-Mail is strictly prohibited. Addressees should check this E-mail for viruses. The Company makes no representations as regards the absence of viruses in this E-Mail. If you have received this E-Mail in error please notify our IT Support Team immediately by telephone on 0845 456 9100 or via e-mail at support@opaltelecom.co.uk Please then immediately delete, erase or otherwise destroy this E-Mail and any copies of it. Any opinions expressed in this E-Mail are those of the author and do not necessarily constitute the views of the Company. Nothing in this E-Mail shall bind the Company in any contract or obligation. For the purposes of this E-Mail "the Company" means Opal Telecom Ltd. Please feel free to visit our website: www.opaltelecom.co.uk Opal Telecom Ltd (Registered in England & Wales No. 3849133) Brinnel Drive, Northbank Industrial Park, Irlam, Manchester M44 5BL. A member of the Carphone Warehouse Group of Companies Tag: Display Data Between Commas In Form ASP Tag: 298329
  - 19
    - SQL Breaks ASP In one of our applications we have product id field which sometime contains ' When doing a search the sql breaks due to this. I cannot use replace function to remove this is there anything else I can do so that this works strProductId = 2277'778 sqlstr = " Select * from productdetails where id ='" & strProductId & "'" In this instance the sql breaks and gives me an error. Any suggestions how i can solve this Regards Tag: Display Data Between Commas In Form ASP Tag: 298328
  - 20
    - Session Variables being cleared automatically We have a strange problem with our IIS server running on windows 2003 server. A small number of users complain that thier session expires midway and the application logs them out and even after logging in again the same problem exists. It only happens to about 3-5% of our users. Does anyone know why this happens? Tag: Display Data Between Commas In Form ASP Tag: 298327
  - 21
    - Search Page ASP Hi All We are building an application with ASP/SQL Server and need to build a search page. I want to display lots of fields/textboxes on the search page to allow user to search any field by entering the search terms in any of the textboxes. I was thinking of using lots of if conditions to build the search string something like strSQL = "Select <<fieldnames>> from Contracts where Active= True " if request.form("contractno") <> "" then strSQL = strSQL & " and contractno ='" & request.form("contractno") & "'" end if Does anyone know of a better way to build the SQL string. Also any methods to speed up the query built will be much appreciated. I have already limited the total results that the query displays but adding " Top 20 " in the SQL string. Any other suggestions? Tag: Display Data Between Commas In Form ASP Tag: 298326
  - 22
    - IIS5 to 6 migration trouble with ASP include directives We are poised to migrate about 600 ASP sites from a single IIS5 server to a new pair of IIS6 servers. However, it appears that all files with includes like:  will not work on IIS 6, it returns ASP 0126, include file not found. We have enabled parent paths, but I can't find any documentation that suggests that IIS 6 handles include directives differently than IIS 5. Has this in fact changed in IIS 6? We are trying to avoid a huge and messy "search and replace embedded text" exercise. Your thoughts greatly appreciated. TIA John Chertudi Tag: Display Data Between Commas In Form ASP Tag: 298325
  - 23
    - possible to put 9 asp pages in one server,1 in remote , all under same domain? Hi, I have a site in israel which composed from 10 asp pages, and i want to put page number 1 in a different server in U.S.A since the page need to access a data base in USA. all pages must belongs to the same domain,since i am using IE userData behavior to persist data. thanks Tag: Display Data Between Commas In Form ASP Tag: 298324
  - 24
    - How can I get the TextStream Object to write on Fat32? Hi Gang, I have so far been unable to get the TextStream Object to write on Fat32. I'm using Windows 2000 Pro Sp4. Scripts have write access and I even tried giving IUSR user level writes and still when I tried loading the ASP page it just hangs trying to create the file :(. <% Function WriteText(sPath, sText) Dim fso, TextFile Set fso = CreateObject("Scripting.FileSystemObject") Set TextFile = fso.CreateTextFile(sPath, True) TextFile.Write sText TextFile.Close End Function WriteText "Test.htm", "Testing, Testing, 1, 2, 3" %> Can anyone tell me what I'm doing wrong? This must be a security issue, but how and where? Thanks, Christian Blackburn Tag: Display Data Between Commas In Form ASP Tag: 298307
  - 25
    - Access97 DB locks up the asp code at times I have an Access 97 DB called employees.mdb within a NT security type folder. Other users have write privileges to this document to make updates. This Access DB is only used for an ASP called employee.asp that's within the same folder. Here's the connection string example: <%@ Language=VBScript %> <% Dim my_conn, rs ConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("employees.mdb") Set my_conn = Server.CreateObject("ADODB.Connection") my_conn.Open ConnString set rs = server.CreateObject("ADODB.Recordset") %> This asp has been working without major problems for about 2 years. On most occasions, a user can open the Access DB, make changes and close it without any problems. However, on two occasions, a problem has occurred after a user opened the Access DB. My only guess is that someone accesses the employee.asp, which queries the Access DB when the Access DB is opened and being changed. Once this occurs, the employee.asp delivers an error code and complains about the connection line of "my_conn.Open ConnString". Any idea why this is happening? To correct the problem, I can just rename the employees.mdb to another name like employees1.mdb and then change connection string in the employee.asp to "ConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("employees1.mdb")", from employees.mdb Anyway, I would like the users to still have the ability to be able to modify the MS Access DB if possible so that I don't have yet another thing to do. Any thoughts? Thanks Tag: Display Data Between Commas In Form ASP Tag: 298297

I would like to know if you can display only certain data into a field
between commas or any other symbol without using the curshort feature.
For example. I have the following.

Part, A3472, Desc: Controller: Price$ 45.00

I just need this out of it in a single form field.

A3472

I cannot use the cutshort feature because my part numbers are
different lengths.

Thanks for any help in advance.

Thanks,
gil@ambry.com

Top

Re: Display Data Between Commas In Form ASP by Mark

Mark
Wed Aug 11 11:55:15 CDT 2004

cutshort feature????

in vbScript:

aData = Split( strData, ',' )
strPartNo = aData(1)

--
Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com

"gotcha" <gil@ambry.com> wrote in message
news:73a4f99a.0408110805.4143cb0b@posting.google.com...
> I would like to know if you can display only certain data into a field
> between commas or any other symbol without using the curshort feature.
> For example. I have the following.
>
> Part, A3472, Desc: Controller: Price$ 45.00
>
> I just need this out of it in a single form field.
>
> A3472
>
> I cannot use the cutshort feature because my part numbers are
> different lengths.
>
> Thanks for any help in advance.
>
> Thanks,
> gil@ambry.com

Top