trimming a variable.

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
    - sort data from a table by count value's? Is it possible so sort data from a table based on the count results? I have the following <% set rs = db.execute("Select * from tbleventinfo order by ename") while not rs.EOF tmp = rs("eid") set rs1 = db.execute("Select count(eid) from tbleventdj where eid = " & tmp) if rs1.EOF = false then total = rs1.fields.item(0) else total = 0 end if set rs1 = Nothing echo rs("ename") & "(" & total & ")" rs.moveNext if rs.EOF = false then Response.write "<br>" wend set rs = Nothing %> which works fine. but as you can see it sorts it all out bases on the ename... Any help apriciated!! Willem-Jan Selen Tag: trimming a variable. Tag: 265536
  - 2
    - Session Variables Persist Across Window Close on Mac IE 4.5 and Greater I've noticed that session variables will persist on Mac IE even after all browser windows have been closed. One must quit the program to clear the session variables. This presents a security risk for my session variable based security scheme. Basically, the risk is that a user will login to my site, close the window when done and allow someone else to come up to the machine, go back to my site and be logged into the previous user's account. Anyone know how to make session variables disappear when a window closes? Any other ideas? Am I going to have to redesign my whole security scheme? Any suggestions are appreciated. Dave Tag: trimming a variable. Tag: 265525
  - 3
    - Variable in the field name. Hi All, I have one question. Usually, we can get data from table by using rst("userid") because we know the column name userid. Now, I have a variable to hold the column name. I want to get data value like this rst(var1). However, I got an error message. Thanks. my Tag: trimming a variable. Tag: 265523
  - 4
    - Change Password Error Hello, Exchange 5.5 SP4 on W2K SP3. When in OWA, go to Options->Change Password, i's returning an error when you submit. I fill in the info for Domain, Account, old, new and confirm passwords and it says "Error number: -2147023569 ". Then there's a link that says 'Back' so that you can try again. Anyone seen this error before? A search on Google and KB's returned nothing... Thanks in advance, Tony Tag: trimming a variable. Tag: 265514
  - 5
    - 2 global.asp questions 1. how to determine the 'progid' parameter in the /oject tag for both session and application tags, eg, <object runat="server" scope="application" id="web1" progid="web1"> </object> 2. i want to invoke the meta data for ado in my global.asa, so it will there for all the sessions:  is this then coded within the application 'object' tags, see 1, or is it coded in the application_onstart subroutine?? Tag: trimming a variable. Tag: 265508
  - 6
    - How can u connect to 1 of several dbs based on selection user makes when accessing main page We have a web site IIS 5 (on Win2000k) with Oracle 9i backend (Sun unix). There is 1 user ID to oracle(APT_W3) that is used by all users (50). We have a global.asa file that has one APP Start connection string using OLE DB: Application("dbConnString")="Provider=MSDAORA.1;Password='SDERSD';User ID=APT_W3;Data Source=CCEWSDD1_new;Locale Identifier=1033;OLE DB services=-1" The first page that a user sees asks that they select the area they want to see (western, northern, etc) from a dropdown menu. Once they select it and hit save they can go to other pages, session varibles indicating what area they selected are then passed to pages. Currently all areas are in one database. What we want to do is have areas in separate dbs, a northern one, a western one.etc. Each will have separate user ids (APT_W2N, APT_W3W,etc). We want the users to have the web page presented to them where they select an area. Based on the area they select, the appropriate conneciton string will be used (the one in the global asa). Is there a way to have that in the global asa? Maybe as a session Session_OnStart? Based on the selection they made on the web page, they will be using one of several connection strings so we can have connection pooling Tag: trimming a variable. Tag: 265488
  - 7
    - problems width select line This is a multi-part message in MIME format. ------=_NextPart_000_003C_01C34FC1.EE9CC600 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi! I am having some problems width a little script i downloaded... I'm not able to figure out what he SELECT line does! What does the @@identity mean? Is this maby a javascript? :) function GetLastIdentity(ADOConnection) { var rstIdentity =3D Server.CreateObject("ADODB.Recordset"); rstIdentity.Open("SELECT @@identity AS IdentityId", ADOConnection); var iIdentity =3D rstIdentity.EOF =3D=3D false ? = rstIdentity("IdentityId").value : -1; rstIdentity.Close(); return iIdentity; } ------=_NextPart_000_003C_01C34FC1.EE9CC600 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>Hi!</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I am having some problems width a = little script i=20 downloaded...</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I'm not able to figure out what he = SELECT line=20 does!</FONT></DIV> <DIV><FONT face=3DArial size=3D2>What does the @@identity = mean?</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Is this maby a javascript? = :)</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>function=20 GetLastIdentity(ADOConnection)<BR>{<BR> var rstIdentity =3D=20 Server.CreateObject("ADODB.Recordset");<BR><STRONG> <FONT=20 color=3D#ff0000>rstIdentity.Open("SELECT @@identity AS IdentityId",=20 ADOConnection);</FONT></STRONG><BR> var iIdentity =3D = rstIdentity.EOF =3D=3D=20 false ? rstIdentity("IdentityId").value :=20 -1;<BR> rstIdentity.Close();<BR> return=20 iIdentity;<BR>}</FONT></DIV></BODY></HTML> ------=_NextPart_000_003C_01C34FC1.EE9CC600-- Tag: trimming a variable. Tag: 265486
  - 8
    - Error Too few parameteres expect 1 Works fine. Recid = rs("id") SQLstmt = "SELECT * FROM courses WHERE ID=" & Request.QueryString("Recid") When i combine two tables SQLstmt = "SELECT tblAuthor.employee_code, tblAuthor.name, Courses.status, Courses.ID, Courses.mdate, Courses.InstructorID, FROM tblAuthor INNER JOIN Courses ON tblAuthor.employee_code = Courses.InstructorID WHERE Course.ID=" & Request.QueryString("Recid") i get Too few parameteres expect 1 is it a syntax error? Tag: trimming a variable. Tag: 265485
  - 9
    - Web Bulletin for ASP 1.0 Released. Sunwest Technologies is pleased to announce the availability of Web Bulletin for ASP, a server-side component for easy creation of bulletin board in a web browser. The bulletin board can be used to display news, events and messages. * The messages can be specified by an XML file or through COM interface * Fading and scrolling effects are provided * All major browsers are supported * Can be used FREELY For more information on Web Bulletion, please visit http://www.SunwestTek.com/wb Sincerely, Sunwest Technologies, http://www.SunwestTek.com Tag: trimming a variable. Tag: 265480
  - 10
    - POS Cash Drawer with Internet Explorer? Hi, I'm getting tasked with writing an ASP application deployed throughout the company's intranet where all the workstations will be running Internet Explorer 6.0. It's a retail business, and some of the workstations are Point-Of-Sale and will need to have cash drawers and bar-code scanners. The project managers want this as a web-application because of the ease of deployment and updates to the other stores. The problem is, I don't know how to activate the cash drawers from within IE. Is there any kind of ActiveX control which can be plugged into IE to allow control over the cash drawer from within IE? We don't have the cash drawers purchased yet, and are waiting to find out if anyone makes an ActiveX plug-in control and cash drawer which will work from IE. Suggestions and recommendations would be greatly appreciated. Thanks, Scott Tag: trimming a variable. Tag: 265478
  - 11
    - ASP.NET on a DomainController I'm developing an ASP.NET app that uses ActiveDirectory. To demo this, I've built a notebook as a Win2000 DomainController with IIS. To my pleasant surprise this actually worked - at least until I patched it the other night. Now I get nothing but security violations (access denied), with no usefull indication as to what security I've violated. I'm using 'impersonate' mode and I'm logged in as the admin of the only Domain. I can get this working with .NET 1.0 and an un-patched DC, but I need to upgrade it to .NET 1.1 which requires patches that will introduce the security problems. I've tried modifying the Machine.Config to use 'SYSTEM' rather than 'machine' as the processed, this didn't do it. Does anybody have a hint on what security settings need to be tweeked to get this to work? Thanks, Randy Tag: trimming a variable. Tag: 265457
  - 12
    - is there anyone from microsoft IIS group, please! Hi i am searching for anyone from IIS /ASP team.please contact me or lave me a message here or email me. Regards Bogomil Tag: trimming a variable. Tag: 265446
  - 13
    - Help converting short php script to ASP I've got this PHP script working on one of my sites and now need an ASP version for my intranet. I don't know ASP, can anyone help out? Know of anyway to NOT have a blank browser window open when clicking on the link or even a better solution to prevent spam harvesters? <? // email.php // usage: // // <A HREF="email.php?to=me&domain=mydomain.com">E-Mail Me</a>--> // // if (!isset($to)) //if(!isset($_GET['to'])) { // $_GET['to'] = "info"; $to = "info"; } if(!isset($domain)) { //$_GET['domain'] = "mydomain.com"; $domain = "mydomain.com"; } // $to = $_GET['to']; // $domain = $_GET['domain']; $email_address = $to."@".$domain; // send email header to page header ("Location: mailto:$email_address"); ?> Tag: trimming a variable. Tag: 265445
  - 14
    - Number format problems with SUM and AVG Hie everybody, I have a problem with the following, I have a table with a row containing numbers with 2 decimal places. I want to count the sum of these numbers but my valuw returned is far to high. I think the SUM string doesn't look at the decimal place. The same is with the AVG string Here are the ones I tried : set rs = db.execute("Select SUM(ePrize) from tbleventinfo") if rs.EOF = false then aveprize = Formatnumber(rs.fields.item(0),2) else aveprize = 0 end if set rs = Nothing and set rs = db.execute("Select AVG(ePrize) from tbleventinfo") if rs.EOF = false then aveprize = Formatnumber(rs.fields.item(0),2) else aveprize = 0 end if set rs = Nothing Can anybody help me allong the way?! Thanks in advance, Willem-Jan Selen Tag: trimming a variable. Tag: 265408
  - 15
    - Auto refresh asp Hi All, I want to refresh a page every 5 mins without the users' intervention. I'm not sure that this is possible at all. Do you? Thanks in advance. Abe. Tag: trimming a variable. Tag: 265382
  - 16
    - How to display in any lanaguae hi, Guys..... I am Making A website....in asp Now my data is stored in Sql Server.... What i want is to display the Data as per Languaue the user selects.. The data stored in sql server is english if the user selects French in asp site the data from the backend should be displayed in FRench... or based on ip address and location automatically the Data....sholud be Displayed according to The REgional...settings.. ie guy logging on from japan sholud see data in japanense.. can this be done or what? Please help me out... regds, Navin Mahindroo Tag: trimming a variable. Tag: 265370
  - 17
    - problem with creating a database in win xp hallo i have to do a code in ASP that including this code: set c=server.createobject("adodb.connection") c.open "dsn=MyDSN;" c.execute "create table first_tables(Name char, Tel char)" and i am geting that error: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E09) [Microsoft][ODBC Text Driver] Cannot modify the design of table 'first_tables'. It is in a read-only database. /1.asp, line 4 what can i do? thanks zeev j Tag: trimming a variable. Tag: 265366
  - 18
    - ASP class-session variable Hiya - Big puzzler for me. Code Below I create a class. I save it to a session variable. Then, I retrieve the session variable back into a new local variable. I am able to use a method which prints the name "Joey." Works great. But if I retrieve the same session variable into a local variable from a different page, I cannot use the method. It fails. Even though the session variable is an object, and the local variable is an object! Why? How can I get to this class from the second page? thanks <% dim oTest set oTest= new clsEmployee oTest.EmployeeName="Joey" set session("sessionTest")= oTest set oTest= nothing 'This section works fine------------------------------ 'But not from another page! dim oNewTest set oNewTest = session("sessionTest") Response.Write "<br>Is oNewTest an object? " & isObject(oNewTest) Response.Write "<Br>" Onewtest.PrintEmployeeName --------------------------------------- Class clsEmployee Private m_strEmployeeName Public Property Get EmployeeName EmployeeName = m_strEmployeeName End Property Public Property Let EmployeeName (strEmployeeName) m_strEmployeeName = strEmployeeName End Property Sub PrintEmployeeName Response.Write EmployeeName End Sub End Class %> Tag: trimming a variable. Tag: 265358
  - 19
    - clientside events I want to validate client entries into textbox,checkbox controls etc. can u do this with asp. Like, is there onchange and onclick and so on for these controls? is there a reference for this in the sripting help? Tag: trimming a variable. Tag: 265356
  - 20
    - client-side WSH in ASP Dear all, The following code is used to show installed printers on a computer,it works on server machine,however, if use a client machine to browse, it also shows the intalled printers on the server machine.Actaully, what i want to do is to show what printers installed on your own machine (that means show it on client-side). Do you guys understand my problem?Please help please help, this problem has already existed for a long time, i really need your help! <% Dim WshNetwork, objPrinters, i Set WshNetwork = server.CreateObject("WScript.Network") Set objPrinters = WshNetwork.EnumPrinterConnections For i = 0 to objPrinters.Count - 1 Step 2 response.write objPrinters.Item(i+1) & "<br/>" Next %> Thanks a lot!! Karen Tag: trimming a variable. Tag: 265350
  - 21
    - string variable - weird error - help me!!!! hi, I have a variable which has lots of text (html code more specifically) assigned to it. What I need to do is to strip away large chunks of it from the beginning and end of it. I need to recognise some div tags as the beginning and end of the string and to throw everything else away. I have no guarantees that the surrounding text will be the same each time it is used. So does anybody know how to seek out and find some characters and strip everything before it and then to find a closing tag and strip everything after it. The problem I am currently having is a puzzling one, if i strip away text from a hard coded variable, everything gets posted to my database just fine, however when i try it on my form retrieved string variable my start position is always '0', indicating that the text i am seeking has not been found. My theory is that the search will not read new lines, and is only reading the very first line of text from the string and nothing else. Does anybody know if this is a correct theory, and if so how I can get my search coding to go onto the next line? any help would be greatly appreciated Tag: trimming a variable. Tag: 265348
  - 22
    - stopping users registering with the same username? Hi, i've got a asp page to register a user and check that the username has not been previously registered, heres the code i have ... that doesnt work <SCRIPT LANGUAGE=vbscript RUNAT=server> 'Adds a record to the table Dim SQL 'A variable for the SQL statement Dim ObjConn 'A connection varaible Dim ObjRS Set ObjConn = Server.CreateObject("ADODB.Connection") Set ObjRS = Server.CreateObject("ADODB.Recordset") rsSQL = "SELECT * FROM tblUsers WHERE strUser='" & Request.Form("strUser") & "' " SQL = "INSERT INTO tblUsers " SQL = SQL & "(strUser, strPwd, strEmail) " SQL = SQL & "VALUES ('"& Request.Form("strUser") & "', '" & Request.Form("strPwd") & "','" & Request.Form("strEmail") & "')" ObjRS.Open rsSQL, "DSN=Project" If ObjRS.RecordCount > 1 Then Response.Redirect ("retry.html") Else ObjConn.Open "DSN=project" ObjConn.Execute SQL End If ObjConn.Close Set ObjConn = nothing Response.Redirect("ok.html") </script> i am going the right way about it? if so where have i gone wrong? if not could someone please point me in the right direction any help is appeciated Regards Tag: trimming a variable. Tag: 265344
  - 23
    - string manipulation problem - Replace Hi all, I'm new to ASP so this is probably a problem caused by me.... but here goes. I have been pulling some information from an access database (specifically a postcode) eg. GL3 2SD, I need to swap the space " " for an plus sign "+" and have been trying to use this code - <%Dim ModPostCode If GetPropertiesRecordset.Fields.Item("AddressPostCode").Value <> "" Then ModPostCode=GetPropertiesRecordset.Fields.Item("AddressPostCode").Value Replace(ModPostCode, " " , "+") =ModPostCode%> Some other html........ <%End If%> But I get this Error - Microsoft VBScript compilation (0x800A0414) Cannot use parentheses when calling a Sub /searchresults.asp, line 354, column 31 Replace(ModPostCode, " " , "+") I have tested all the lines to make sure that the data is OK and in the variable 'ModPostCode', I just can't get the Replace command working... Any ideas... anyone... please.... Cheers Coz. Tag: trimming a variable. Tag: 265341
  - 24
    - ASP.NET hi, i have a datagrid in a page. when i sort by a column, the postback occurs, so i get the old version of the page availbale in the brower back button. I want to hide the page from the back button when it is in the postback status. i want to hide the page from the back button of the browser so when i sort the grid, i want the new result (response) to replace the current link in the browser back button. can this happen? thank you Tag: trimming a variable. Tag: 265338
  - 25
    - 500 Internal Server Error Hi all, Just wondering if you could possibly check this site for me - www.gtfasteners.co.uk . I am getting a 500 Internal Server Error message every time I try to log in, however I have set all file permissions related to the login as read,write and execute. Username = user Password = fasteners2003 I don't know all that much about ASP yet as I am learning, but I have managed to get the site working fine on my localhost using IIS. But when the site is uploaded to the remote server, 1&1 Microsoft package, I get the errors. Any help is much appreciated. -- Regards, Chris. http://www.chrisf.has.it http://www.lascoronas10.has.it http://www.boro.rules.it http://www.chrisfuni.has.it Tag: trimming a variable. Tag: 265329
- Next
  - 1
    - DateAdd does not work Dear Lord, I'm trying to code a drop down for a date entry that gives the user the option of the current date plus the dates of the last 7 days. <% for i = -7 to -1 Response.write "<option>" & DateAdd(d,i,Date()) & "<option>" next %> Besides this, even the following code generates an error: Today=Date() Response.write DateAdd(d,5,Today) your guidence is sought, oh great one. amen Tag: trimming a variable. Tag: 265318
  - 2
    - Easy vAlign question Below is my code. It seems that no matter what I do, I cannot get the following list of places to start at the top of the cell. It is always centered in the middle of the cell. Is vAlign the correct command for it to start listing at the top of the cell? Response.Write "<TABLE BORDER=""1"">" Response.Write "<TABLE WIDTH=150>" Response.Write "<TD vAlign=top>" Response.Write "<TR><TD>" & "<FONT face=""Arial"" size=1>"& "<Ahref=DurbanSuburbs.asp>" & "Central Durban" & "</A>" Response.Write "<BR>" & "<FONT face=""Arial"" size=1>" & "La Lucia" Response.Write "<BR>" & "<FONT face=""Arial"" size=1>" & "Umhlanga Rocks" Response.Write "<BR>" & "<FONT face=""Arial"" size=1>" & "<A href=KZNBerea.asp?link=Mount_Edgecombe>" & "Mount Edgecombe" & "</A>" Response.Write "<BR>" & "<FONT face=""Arial"" size=1>" & "Glenashley" Response.Write "<BR>" & "<FONT face=""Arial"" size=1>" & "Durban North" Response.Write "<BR>" & "<FONT face=""Arial"" size=1>" & "North Beach" Response.Write "<BR>" & "<FONT face=""Arial"" size=1>" & "South Beach" Tag: trimming a variable. Tag: 265315
  - 3
    - Trying to find the author of a script I use a script to force the browser to save instead of displaying a simple text file. I downloaded the script some time ago and I don't remember where I got it from. Does anyone recognize this script and if so, do you know the author of this script: ------------------------------------ <% ' Constants for Reading Text File Const ForAppending = 8 Const ForReading = 1 Const ForWriting = 2 Const TristateFalse = 0 Const TristateMixed = -2 Const TristateTrue = -1 Const TristateUseDefault = -2 ' File System Objects Dim FSO Dim TS ' Server File (this is the REAL name of the file) Dim strFile: strFile = Server.MapPath("mybas1.bas") ' File to Save As (this is the name you want to tell the browser) Dim strFileSave: strFileSave = "mybas2.bas" ' Tell Browser what the file name is, so it doesn't try to save as "default.asp" Call Response.AddHeader("Content-Disposition","attachment; filename=""" & strFileSave & """") ' Write out content-type that will FORCE user to SAVE FILE. ' "image/gif" will display in browser Response.ContentType = "bad/type" ' Initialize File System Object Set FSO = Server.CreateObject("Scripting.FileSystemObject") ' Open TextStream for Reading Set TS = FSO.GetFile(strFile).OpenAsTextStream(ForReading,TristateTrue) ' TS.ReadAll DOES NOT WORK. Every Byte must be read and written individually. ' I think you can read them in Chucks, but this was easier. If you know how to ' Read chunks... go ahead, read chunks ;) Do While Not (TS.AtEndOfStream) ' Output MUST be BinaryWrite Response.BinaryWrite(TS.Read(1)) Loop ' Cleanup, like all good programmers do. TS.Close Set TS = Nothing Set FSO = Nothing ' You don't need this, but I like it. Response.End %> ------------------------------- Many thanks in advance, Arguich811 Arguich811*digitalice*com Tag: trimming a variable. Tag: 265313
  - 4
    - What is this ?? Hi guys, can anyone explain line number 5 to me. i don't quite understand what is going on there and why. 1 <script language="vbscript" runat="server">sub Application_OnStart 2 getcustomers 3 end subsub getcustomers 4 set conn=Server.CreateObject("ADODB.Connection") 5 conn.Provider="Microsoft.Jet.OLEDB.4.0" 6 conn.Open "c:/webdata/northwind.mdb" 7 set rs=conn.execute("select name from customers") 8 Application("customers")=rs.GetRows 9 rs.Close 10 conn.Close 11 end sub</script> also what is the meaning of the key word set here. is it an array? is it a connection ( i ask this cos it gets "closed" later in line 9) also i presume that customer would need to be declared somewhere as... dim customers(aNumber). am i correct? if so, how would i be sure that the size given to the "customers" array would be big enough? is there such thing as an array that can hold any number of elements in ASP? thanks guys. Liza Tag: trimming a variable. Tag: 265311
  - 5
    - Cannot connect to WORD and OUTLOOK anymore after upgrade! Please help.. Thanks in advance. When running from a remote machine, I was quite able to server-side create COM connections to WORD and OUTLOOK while using the VB Studio.Net 2002 version using the following style of coding. Dim myObj as New Windows.Application Now, after upgrading to VB Studio.Net 2003, I get a very basic error message "Cannot create ActiveX Object" when trying to access the same application. When accessing it locally, everything runs fine. It MUST be some security/rights thing. I have tried all possible combination of setting the IIS security for the application on the server, but there are so many options, I thing I am running in circles. PLEASE, can anyone give me some advise? What have changed betwen versions 2002 and 2003 and what can I do to correct it? Much appreciated Heinrich Braasch Tag: trimming a variable. Tag: 265308
  - 6
    - Where can i find images ?? Can anyone tell where i can get very professional and sophisticated images for my web sites ( even if i have to pay for them ) thanks. Liza Tag: trimming a variable. Tag: 265278
  - 7
    - how to install Asp script on other server Dear sir, My client asked me to write a small ASP application for them. I have finished the job, however, I am now having a problem during the delivery. This application needs to be installed on > 3 servers. My client will do the installation themselves. Inside my application, there is a MS SQL database, I bought a component, this component is used by asp script. To enable schedule, this application requires a task on windows task scheduler as well. So, I have a database, a component, a scheduled taks, how can I combine them into one package and make it very easy for my client to install it?? Any help will be appreciated. -- Met vriendelijke groet, Guoqi Zheng Pampus 120 2036 TC, Haarlem The Netherlands Tel: 0647556397 Tag: trimming a variable. Tag: 265269
  - 8
    - Beginner question new to the world of asp! I'm trying to define session variables using the following code: Session("Employee")= [value] when i replace the Session with Application, the value is available across all the pages, but the session variables are only available on the page i declare them. Is this a coding or a server issue? Thanks Chris Tag: trimming a variable. Tag: 265268
  - 9
    - RichEdit Dear All, How could I Add RichEdit to my Text Area to allow the user to edit his email (Like The Compose Page In HotMail). Thanks alot in advance Shery Tag: trimming a variable. Tag: 265264
  - 10
    - instantiating the ASP.DLL Is there a way to do a CreateObject("") on the ASP.DLL? TIA Chris Tag: trimming a variable. Tag: 265260
  - 11
    - ASP pages & possible permissions corruption We're running windows 2000 server with IIS 5.0. We're trying to execute .asp scripts but we keep getting the 500 (internal server) error. It looks like the permissions might be corrupted. When I go to the folder in question, go to properties >> security and look at the user groups, for several seconds they say this: S-1-1-0 S-1-5-18 S-1-5-32-544 Then the above numbers turn into the group names (everyone, administrator, etc.). The end result is that no .asp code can be executed, but other scripts (such as ColdFusion scripts, sorry) are working fine. Our website as a whole is functioning properly. Months ago I applied the IIS Lockdown Tool and ever since I've had to jockey the permissions around. Earlier in the week I had IIS prompt me for username/password to access public pages. When I went to the permissions menu, it hesitated and then opened. When I retried the pages after adjusting the permissions, I was able to access them again. Any suggestions, reference? Thanks. Tag: trimming a variable. Tag: 265257
  - 12
    - referrer id How can I learn where my visitor came from? I mean which site reffered to my site? (Something called referrer id/ip) Thanks in advance.. Evrim Tag: trimming a variable. Tag: 265255
  - 13
    - Calendar Control Example Would anyone have an example of using the MS Calendar control (class MSCAL.Calendar.7) and ASP? Help apprecaited. Thanks. Frank *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: trimming a variable. Tag: 265254
  - 14
    - Insert error :: must be updateable? I am picking up the following error message which is strange as it has only started happening since I have transferred servers: Microsoft JET Database Engine error '80004005' Operation must use an updateable query./admin/news1.asp, line 59 sql1 = "INSERT INTO [News] (strDate,Department,Title,ShortDescription,strContent) VALUES (" & strDate1 & ",'" & strDepartment1 & "','" & strNewsTitle1 & "','" & strShortDescription1 & "','" & strDescription1 & "')" Set rsnews = data.execute(sql1) Set rsnews = Nothing Tag: trimming a variable. Tag: 265247
  - 15
    - Pass prameter from a page to another Hi, I have a page that calls a multiple frames page (ASP). I need to send parameters from the first to the multi frames page. If sending to a simple page, it works. If sending to multiple frames page, it does not. -- Thank you, Doru Tag: trimming a variable. Tag: 265235
  - 16
    - HTTP Error 507 I keep getting the following error with my website : ---------------------------------------------------------- HTTP Error 507 507 Unexpected The Web server encountered an unexpected error while communicating with the ASP service. Please contact the server's administrator if this problem persists. ----------------------------------------------------------- I'm using ASP to exchange information with a database. After the above has happened my session variables have all lost their values. It happens at random at different locations in the website, sometimes only seconds after running the site, sometimes I'm good for a few minutes. I have no trouble at home. I've contacted my Host and they say : "I'm not sure why you are getting that error, as I checked the logs and the ASP server has been up and running. One option is I could move you to a different server to see if that helps. I also asked around to see if anyone else had called or emailed in about this and nobody had." - Thanks for nothing http://www.blacksun.ca/ - perhaps they can suggest a more reliable host for me to transfer my business too! Anyone else in here had a similar problem and is there a solution other than changing hosts? Thanks! Tag: trimming a variable. Tag: 265232
  - 17
    - Removing a period from a string I need to remove a period from a string of data. I have a whole column of numbers that have a period distributed randomly in them, and I need a way to pull the period out. Unfortunatly, the period is not at a fixed interval from the start or from the end. Sometimes it's like this: 08307.33214 and sometimes it's like this: 66543354.2213 At any rate, I have a whole column of these in SQL Server 7.0 and need to use the number as is for some issues, but without the period for others. Can someone please show me how to write a function that will remove the period no matter where it is located in the string? Thanks! Bill Tag: trimming a variable. Tag: 265230
  - 18
    - What really is ASP? Hi guys, i'm a little bit confused about ASP... am i correct in thinking that a JBScript that uses asp.dll objects is an ASP? what i mean is is an ASP a script written in ASP supported languages such as vbscript, perlscript etc. but that uses ASP.dll ojbects? also, how is the data collected from an ASP accessed? for example if i have an ASp that collects visitors' contact information, how would i access that information in order to use it? for javaScript and VBScripts, which do not make use of any server, how are information collect by the website processed or collected by the owner of the website in order to utilise the information? if i develop an ASP will i need to develop the server as well, or am i correct in thinking that the server is the IIS? (if so, how would i access the IIS database? would i need to create a separate ASP to retrieve collected information?) is there a difference between perl and perlscript? thanks a lot guy !! Liza Tag: trimming a variable. Tag: 265215
  - 19
    - ColorChooser in HTML Hi! I'm making a web editor in html, an i would like to have a colochooser control, in ActiveX or something similar. Can anybody help me?? Thanks Tag: trimming a variable. Tag: 265209
  - 20
    - ColorChooser in HTML Hi! I'm making a web editor in html, an i would like to have a colochooser control, in ActiveX or something similar. Can anybody help me?? Thanks Tag: trimming a variable. Tag: 265208
  - 21
    - embed object and no DL to browser cache i know this can be done, but i just couldn't figure out how. can someone give me a hint or somthing? it's a asp web application, and i need to use html tag "embed" to put a pdf document on a web page. but i don't want the visitor to download the embeded file. visitor can only view it in browser and the embeded file will never sent to visitor's browser cache. so, what's the tricks that i should do at server side to accomplish this? ray Tag: trimming a variable. Tag: 265207
  - 22
    - Query / mySQL / Access Hi, I've got a query that works fine when used in mySQL but completely fails when I try to apply it to MS Access, weird thing is that it is just a copy of a stored procedure that works fine in the same copy (with the Request.QueryString replaced by a fixed value) ! Any explaination would be great, ID is a number BTW : SELECT page_title,ID,page_content FROM content WHERE ID='" & Request.QueryString("ID") & "' ' Had a look at aspfaq.com but couldn't find anything that applys. Cheers John Tag: trimming a variable. Tag: 265203
  - 23
    - SQL db doesnt support the Cookie This is a multi-part message in MIME format. ------=_NextPart_000_0011_01C34D50.1C072AA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I wrote the code for Members of Register. and i use cookie in this = code, My database is SQL server. SQL server dosent support the cookies = in my codes i dont know why this cause but my codes are working without = any cause=20 can anybody advice me thanks=20 ------=_NextPart_000_0011_01C34D50.1C072AA0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2479.6" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I wrote the code for Members of = Register.=20  and i use cookie in this code, My database is SQL server. SQL = server=20 dosent support the cookies in my codes i dont know why this cause but my = codes=20 are working without any cause </FONT></DIV> <DIV><FONT face=3DArial size=3D2>can anybody advice me thanks=20 </FONT></DIV></BODY></HTML> ------=_NextPart_000_0011_01C34D50.1C072AA0-- Tag: trimming a variable. Tag: 265195
  - 24
    - Radio button group I have a simple html page with a radio button group on it. I am submitting that page into an asp page. How do I know what button the user has checked? Thanks Tag: trimming a variable. Tag: 265187
  - 25
    - MSXML : i want to get the resultant HTML in a variable Hi All i m transforming a simple XSL file on Server side using MSXML Parser ... and writting resultant HTML directly on browser .. is there any way to get this HTML in a variable ??? i seen the article on MSDN but it makes my page blank ... plz edit my code to make is work in this manner, if possible Thankx in advance Plz Help 'MY ASP FILE CODE strxml = "<data><name>Asim</name></data>" XSLFilePath = "C:\Emaples\test.xsl" call TransformDocument(strXMl,XSLFilePath) function TransformDocument(srcXML, srcXSL) Dim sourceFile, styleFile, source 'the xsl file path styleFile = srcXSL set source = Server.CreateObject("MSXML2.DOMDocument") source.async = false source.loadXML srcXML 'Get The Style Object set style = Server.CreateObject("MSXML2.DOMDocument") style.async = false style.load styleFile 'Error Handaling if (source.parseError.errorCode <> 0) then 'result = reportParseError(source.parseError) set oerr = source.parseError sErrMsg = "XML Parsing Error. File: " & oErr.url & " Reason : " & oErr.reason & " Line: " & oErr.line & ", Character: " & oErr.linepos & ", Text: " & oErr.srcText Response.Write sErrMsg elseif (style.parseError.errorCode <> 0) then 'result = reportParseError(style.parseError) set oerr = style.parseError sErrMsg = "XML Parsing Error. File: " & oErr.url & " Reason : " & oErr.reason & " Line: " & oErr.line & ", Character: " & oErr.linepos & ", Text: " & oErr.srcText Response.Write sErrMsg else source.transformNodeToObject style,Response end if End Function 'MY XSL FILE CODE <?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> <xsl:output method="html" version="4.0" encoding="utf-8"/> <xsl:variable name="name">??!</xsl:variable> <xsl:template match="data"> <html> <head><META http-equiv="Content-Type" content="text/html; charset=utf-8"/></head> <body> <hr/> Name from XML is : <xsl:value-of select="//name"/> <hr/> Variable/Contant Value from XSL is : <xsl:value-of select="$name"/> </body> </html> </xsl:template> </xsl:stylesheet> Tag: trimming a variable. Tag: 265186

I need to trim a variable to have everything after 4 chars in a string.

IE:

var_temp = 200:16:1234567890

i want everything after 200: to be a variable.

I cannot use:

var_new = right(var_temp,14)

because the string is a different length everytime.
I just dont know this function. please help :D

Mario C

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Top

Re: trimming a variable. by SPA

SPA
Mon Jul 21 18:24:44 CDT 2003

Use the mid function in vbscript
Mid(string, start[, length])

var_string = mid(var_temp, 5)

If you know the length of how much you need to extract after the 4th
character, you can specify that too

HTH

SPA

"mario c" <philo_surfer_1981@yahoo.com> wrote in message
news:#yLqBu9TDHA.1740@TK2MSFTNGP12.phx.gbl...
>
> I need to trim a variable to have everything after 4 chars in a string.
>
> IE:
>
> var_temp = 200:16:1234567890
>
> i want everything after 200: to be a variable.
>
> I cannot use:
>
> var_new = right(var_temp,14)
>
> because the string is a different length everytime.
> I just dont know this function. please help :D
>
> Mario C
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Top