session quiz

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
    - sorting columns with Access Is the CASE statement allowed when querying an Access database? Assuming so, what is the correct syntax? thanks SELECT OrderNo, Description, Type, Label FROM Stock WHERE Manuf = 'M' ORDER BY CASE 'C' WHEN 'orderno_asc' THEN OrderNo END ASC, CASE 'C' WHEN 'description_asc' THEN Description END ASC, CASE 'C' WHEN 'type_asc' THEN Type END ASC, CASE 'C' WHEN 'label_asc' THEN Label END ASC, CASE 'C' WHEN 'orderno_asc' THEN OrderNo END DESC, CASE 'C' WHEN 'description_asc' THEN Description END DESC, CASE 'C' WHEN 'type_asc' THEN Type END DESC, CASE 'C' WHEN 'label_asc' THEN Label END DESC Tag: session quiz Tag: 297096
  - 2
    - TOAD: Create a code statement mod This may be slightly off topic, but this is probably a better place to ask than an Oracle group as folk here are more likely to use the feature I'm asking about. In Toad (Quest Software) there is a button called 'Create a code statement' that turns SQL into something you can use in ASP for building SQL strings: For example if in Toad you highlight the following, and click the button: SELECT name, address_line1, address_line2, county, city, postcode FROM address_table WHERE city = 'Birmingham' It copies this into clipboard: SQL = " SELECT " SQL = SQL & " name," SQL = SQL & " address_line1," SQL = SQL & " address_line2," SQL = SQL & " county," SQL = SQL & " city," SQL = SQL & " postcode" SQL = SQL & " FROM " SQL = SQL & " address_table" SQL = SQL & " WHERE " SQL = SQL & " city = 'Birmingham'" This is a nice feature (and there is another button that does the reverse), but I like to build my SQL like this: Dim aSQL() Redim aSQL(8) aSQL(0) = "SELECT " aSQL(1) = " name, " aSQL(2) = " address_line1," aSQL(3) = " address_line2," aSQL(4) = " county," aSQL(5) = " city," aSQL(6) = " postcode" aSQL(7) = "FROM " aSQL(8) = " address_table" aSQL(9) = "WHERE " aSQL(10) = " city = 'Birmingham'" sql = Join(aSQL,"") Erase aSQL Anyone know if Toad can be modified to create the array above instead? I cant find any information about this anywhere. TIA, Colin Tag: session quiz Tag: 297095
  - 3
    - Field calcs with OnBlur I am trying to have an auto calculation happen on a form when 1 of 2 boxes get data keyed into them. I tried using ONBLUR with both textboxes, but I kept getting an invalid object. I use VBscript for my coding. <% response.write(<td class=""detaill""><input type=""text"" name=""txtRate_1"" size=""5"" onBlur=""CalcTotal"" ></td>") sub CalcTotal . . . end sub %> Any help would be appreciated. Thanks, George Tag: session quiz Tag: 297077
  - 4
    - Form Validation Hi, I have a form that is created dynamically from a recordset, this creates a line for each record together with 2 checkboxes, Yes & No so the source output would be something like this: <p>Please indicate whether you still use each piece of software detailed below:</p> <form name="apps" method="POST" action="MyAction.asp"> <table width="600" border="1" cellspacing="0" cellpadding="5"> <tr bgcolor="#9999FF"> <td><font color="#FFFFFF"><strong> Software</strong></font></td> <td><font color="#FFFFFF"><strong>Required?</strong></font></td> </tr> <tr> <td>Adobe Photoshop 7.0 7.0</td> <td><input type="checkbox" name="Yes" value="Adobe Photoshop 7.0 7.0"> Yes <input type="checkbox" name="No" value="Adobe Photoshop 7.0 7.0"> No </td> </tr> <tr> <td>Citrix ICA Client</td> <td><input type="checkbox" name="Yes" value="Citrix ICA Client"> Yes <input type="checkbox" name="No" value="Citrix ICA Client"> No </td> </tr> <tr> <td>Macromedia Dreamweaver MX 6.0</td> <td><input type="checkbox" name="Yes" value="Macromedia Dreamweaver MX 6.0"> Yes <input type="checkbox" name="No" value="Macromedia Dreamweaver MX 6.0"> No </td> </tr> </table> <p> <input type="submit" name="Submit" value="Submit"> </form> And so on...... I want to ensure that either Yes or No has been checked for each line before the form can be submitted, can this be done in asp? The amount of lines in the form will vary. Thanks. Tag: session quiz Tag: 297070
  - 5
    - Re: Cannot access server variables on client Hi All, I left a mistake in the last line of th script. Here's the revised version. Any ideas why it doesn't work (i.e. no fifth element and first swapped with second)? <html> <head> <script language="javascript" runat="server"> var thirdString = "Thirdly<br>"; var fifthString = "Fifthly<br>"; </script> </head> <body> Firstly <br> <script language="javascript" runat="server"> response.write("Secondly<br>"); </script> <%=thirdString%> <script language="javascript"> var clientFourthString = "Fourthly<br>"; document.write(clientFourthString); </script> <script language="javascript"> var clientFifthString = <%=fifthString%>; document.write(clientFifthString); </script> </body> </html> Tag: session quiz Tag: 297067
  - 6
    - Cannot access server variables on client Hi Folks, This page of asp should (I think) generate a page that reads: Firstly Secondly Thirdly Fourthly Fifthly But it doesn't: the first two lines are swapped and the fifth line is missing. How should I change it so that it worked? Thanks, Tim. PS Actually a fix for either problem would do. PPS Here's the ASP: <html> <head> <script language="javascript" runat="server"> var thirdString = "Thirdly<br>"; var fifthString = "Fifthly<br>"; </script> </head> <body> Firstly <br> <script language="javascript" runat="server"> response.write("Secondly<br>"); </script> <%=thirdString%> <script language="javascript"> var clientFourthString = "Fourthly<br>"; document.write(clientFourthString); </script> <script language="javascript"> var clientFifthString = <%=fifthString%>; document.write(clientString); </script> </body> </html> Tag: session quiz Tag: 297066
  - 7
    - Writing out array values Please help me with this I have an array which has days of the month stored in it. For example at one time it might have the values 1,2,3,6,7,8,9 at another time it might have the value 4,5,12,14,19,25 These are days of the month that have been selected and read into an array. What i would like to do is to write them out and put a "X" where the days were selected Somthing like this For i = 1 to 31 if i is found in the array response.write "X" else response.write "-" end if Next I cannot figure out how to search an array for the values for example the output of the first example should be 1 2 3 4 5 6 7 8 9 10 11 12 ...... X X X - - X X X X - - - Tag: session quiz Tag: 297057
  - 8
    - ASP Error Handling Dear all, this error handling has been a pain since so manya days using ASP 3.0 with IIS 5.0 on W2K server Created a custom error page using the Server.GetLastError() and works fine in most of the cases. Following are the issues : 1. Have a hughe file (5-6 mb approx) to upload, now if there are any errors during upload i want to immediately throw an error and roll back the transaction. 2. When the following error occurs, am not redirected to the custom error page bu the same is displayed on the same page. Error - Microsoft OLE DB Provider for SQL Server error '80040e21' Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. is there a way to trap the above error using the Server.GetLastError on the custom error page Pls help... Thanks & Regards, Niraj *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: session quiz Tag: 297056
  - 9
    - request instead of request.QueryString hi, I saw some program using "request("fieldname") " instead of "request.QueryString" to get the value from URL, what's the different ?? thanks Tag: session quiz Tag: 297055
  - 10
    - Issue with a variable form a database. Hello All. I am having issues with the visualbasic gramatic for the following scenario: I am retrieving information from an Access 2000 Database. The current fields are: ebay, which is a yes / no, showing as -1 or 0 ebay_path, which is a memo field with the ebay link to the product auctioned. within the HTML code, I have the following code: ---------------------------------------------------------------------------- --- <% if elbadet.Fields.Item("ebay").Value = -1 then <a href="<%=(elbadet.Fields.Item("ruta_ebay").Value)%>" target="_blank"><img src="images/content/ebay_auctions.gif" width="296" height="43" border="0"> else <img src="images/content/ebay_auctions_inactive.gif" width="296" height="43" border="0"> end if %> ---------------------------------------------------------------------------- --- where elbadet is the name of the recordset ebay is the field having the value ruta_ebay is the other field with the path Once previewed :is giving me the following error HTTP 500.100 - Internal Server Error - ASP error Internet Information Services ---------------------------------------------------------------------------- ---- Technical Information (for support personnel) a.. Error Type: Microsoft VBScript compilation (0x800A0400) Expected statement /lacany/TMP6hxrg14ri3.asp, line 62 <a href="<%=(elbadet.Fields.Item("ruta_ebay").Value) b.. Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) c.. Page: GET /lacany/TMP6hxrg14ri3.asp d.. Time: Monday, July 19, 2004, 11:10:52 PM e.. More information: Microsoft Support -------------------------------------------------------------------------- In plain english I need the statement to behave something like this (pseudocode) If the specified filed = -1 then show the active gif image and the link else show the inactive gif image end if statent Thanks in advance; any help is highly appreciated. Juan Pablo Rojas merca-web.com Tag: session quiz Tag: 297051
  - 11
    - Calculation not working Hello, I am having a problem getting some code to calculate/work in an ASP page. In the snippet below I am collecting some data (inthours1 and intrate1) and then want to calculate a value (intsub1) to display on the page. If I set intsub1 to a fixed value, the page displays correctly. If I try the calculation listed below, I get a 500 internal server error on the page. What am I doing wrong??? Thanks, Joe <% Dim strSDate1, strEng1, intHours1, intRate1, intSub1 intHours1 = Trim(Request.Form("shours1")) intRate1 = Trim(Request.Form("srate1")) ' Sub total buckets intSub1 = inthours1 * intrate1 %> <td><INPUT TYPE=TEXT NAME="SHours1" VALUE="" SIZE=10 MAXLENGTH=10></td> <td><INPUT TYPE=TEXT NAME="SRate1" VALUE="" SIZE=12 MAXLENGTH=12></td> <td><%= intSub1 %> </td> Tag: session quiz Tag: 297048
  - 12
    - Recommend an ASP-based RSS Reader? Can anyone recommend a good, reliable server-side RSS reader that is VBScript based? Tag: session quiz Tag: 297046
  - 13
    - checking record older than 2 years not working? Good day to you all I'm trying to see all the records in the database older than 2 years from today, and I can't seem to be getting it to go. SELECT * FROM comments WHERE (currentdate < 2002 - 07 - 20) ORDER BY currentdate I get null records returned, even though I can see some records as old as 1995. When I run the command like this however, it returns all the rows. SELECT * FROM comments WHERE (currentdate > 2002 - 07 - 20) ORDER BY currentdate any suggestions? -- Kind Regards Rudi Ahlers +27 (82) 926 1689 Greater love has no one than this, that he lay down his life for his friends (John 15:13). Tag: session quiz Tag: 297042
  - 14
    - code behind file not being refresh we're running IIS 5 and trying to do a simple update to a code behind file (Login.aspx.vb) we copy the file over to the server, but we're not seeing the updates. the server is still reporting errors on line numbers in the file that no longer exist. we've even stopped / restarted the service, with no luck. Tag: session quiz Tag: 297041
  - 15
    - Problem with this code.... Hey Guys, My server decided to all of a sudden stop giving me compile/scrip errors and instead now just gives me a blank page with no informatio as to what the problem might be. I have looked over the below cod quite a few times and just for the life of me can not figure out wha could be wrong maybe a fresh set of eyes could help me. Thanks i advance! (sorry for the sloppy code as well) Set adoCon = Server.CreateObject("ADODB.Connection") 'Set the connection string to the database adoCon.connectionstring = strCon 'Set an active connection to the Connection object adoCon.Open SQLString = "Select * from TblTournaments where Member = '" request("member") & "'" Set adoRec = Server.CreateObject("ADODB.Recordset") adoRec.open SQLString, adoCon, 3, 3 if adoRec.EOF = true then RHTML = "This report did not generate any data." end if if adoRec.EOF = false then adoRec.movefirst xyz = 0 do until adoRec.EOF = true tmpTournament(xyz) = adoRec("TNUM") xyz = xyz + 1 adoRec.movenext loop adoRec.close for x = lbound(tmpTournament) to ubound(tmpTournament) SQLString = "Select * from tblTournaments where TNUM = " tmpTournament(x) adoRec.open SQLString, adoCon, 3, 3 for y = 1 to adoRec.recordcount if adoRec("Member") = request.form("member") then Total_Buyin = Total_Buyin + adoRec("buyin") Tournaments_Played = Tournaments_Played + 1 if adoRec("won") > 0 then Gross_Money_Won = Gross_Money_Won + adoRec("won") Net_Money_Won = Net_Money_Won + (adoRec("won") adoRec.recordcount) Money_Paid = Money_Paid + (adoRec("won") Net_Money_Won) end if else if adoRec("won") > 0 then Gross_Money_Collected = Gross_Money_Collected (adoRec("won") / adoRec.recordcount) end if end if next adoRec.close Total_Tournaments = Total_Tournaments + 1 next Total_Net_Collected = (Net_Money_Won + Gross_Money_Collected - Total_Buyin Solo_Collected = Gross_Money_Won - Total_Buyin RHTML = RHTML & "You have played in a total of " Tournaments_Played & " tournaments.<br>" RHTML = RHTML & "You have spent a total of $" & Total_Buyin " in entry fees.<br>" RHTML = RHTML & "You have generated a Gross amount of $" Gross_Money_Won & " from your wins.<br>" RHTML = RHTML & "You have paid out a total of $" & Money_Pai & " to other members.<br>" RHTML = RHTML & "You have generated a net amount of $" Net_Money_Won & " after paying all members.<br>" RHTML = RHTML & "You have collected $" & Gross_Money_Collecte & " from other members.<br>" RHTML = RHTML & "You have made a net amount $" Total_Net_Collected & ".<br>" RHTML = RHTML & "Flying solo you would have made $" Solo_Collected & " compared to $" & Total_Net_Collected & " being o the team." & ".<br>" response.write RHTML end i - Kewl ----------------------------------------------------------------------- Posted via http://www.codecomments.co ----------------------------------------------------------------------- Tag: session quiz Tag: 297034
  - 16
    - Update Application value on multiple servers? Can I update Application("SomeVariableName") on server A in response to user's action on server B? There is no problem in updating the same variable on server B, of course, but we would like both variables to be in sync since users can view the value stored on arbitrary server. So far I have tried server.execute and server.transer to execute script updating Application("SomeVariableName") value on server A in response to user's action on server B but these methods didn't work - documentation conformed it. Is there another, perhaps some creative way of doing it? Tag: session quiz Tag: 297024
  - 17
    - msgbox im trying to use the MsgBox function in the following to display an ASP MsgBox containing text retrieved from the db into a recordset <% set rsMessages= myRecordset msg_text = rsMessages.Fields("msg_text") msgbox(msg_text) %> this generates a permission denied error b/c msgbox needs to run client side so i tried the same code but used <SCRIPT LANGUAGE="VBSCRIPT"> </SCRIPT> in place of the <% %> tags but now i just get an empty message box i must be misunderstanding something with the way the msgbox function works in terms of client side vs server side. any help would be much appreciated jt Tag: session quiz Tag: 297019
  - 18
    - writing text to an image with asp is there any component to make it.. i want to make user registiration page.. in this page i want to place a image which has a text and a user must be type this text to a text box and after that i will check the textbox value and image text value.. how can i make it.. do i need a component. if there is a component what is its name .. and i need a free one... Tag: session quiz Tag: 297016
  - 19
    - need remote_user servervariable Hi, I have an intranet application running on windows 2000 server with IIS 5.0, but there is no domain. The users use workstation windows 2000 and log on locally. I need the logon of the users of our LAN in the application, so i did: lo=request.servervariables("remote_user"), but it's empty. I tried all of them with this: <% for each a in request.servervariables %> <p> <% = a %> <% response.write(" ") %> <% response.write(request.servervariables(a)) %> <p> <%next%> and i saw that 'logon_user' also was empty. Must there be a domain defined and must the users logs on that domain in order to use 'remote_user' or 'logon_user'? Thanks again Cas Tag: session quiz Tag: 297015
  - 20
    - RSS update problem. Hi All, I was able to generate an RSS for the news I provide with ASP and MS SQL backend. When I opens it its working fine with any RSS reader, But its not getting updated, when I update the feed. Its showing the one which I made the day one, How to rectify and what could be the problem. Any help is appriciated. Regards, Benny Tag: session quiz Tag: 296999
  - 21
    - problem with sending emails with CDO Hi, I run IIS 5.0 on windows 2000 server sp4. This server is connected to the ISP with adsl modem. I put ASP code (found on internet) in order to send emails with CDO: (see below) When running that page, i get the error: "HTTP 500 - Internal server error Internet Explorer" No idea why. I wonder whether the first 4 lines must be between comments. Another point: do i need to install SMTP service of my IIS server, or (what i think) can i use the SMTP service of my ISP? Thanks Cas  <% Set cdoConfig = CreateObject("CDO.Configuration") With cdoConfig.Fields .Item(cdoSendUsingMethod) = cdoSendUsingPort .Item(cdoSMTPServer) = "smtp_ of_ my_ ISP" .Update End With Set cdoMessage = CreateObject("CDO.Message") With cdoMessage Set .Configuration = cdoConfig .From = "fromme@eretr.be" .To = "toyou@dfghdfg.be" .Subject = "test with CDO" .TextBody = "it works" .Send End With Set cdoMessage = Nothing Set cdoConfig = Nothing %> Tag: session quiz Tag: 296998
  - 22
    - asp chat how can i do a chat page with asp .. does anyone have example codes or url.. or with java.. please help me... Tag: session quiz Tag: 296997
  - 23
    - upload file component Hi All, Do you know where have free/buy a upload file component? I need allow user to select the folder instead of select file one by one thanks~~ Tag: session quiz Tag: 296995
  - 24
    - writing to file Hi I'm reading one html file and writing in another problem. while cnt <= ubound(lines) myFile.WriteLine "body = body & """&lines(cnt)&"""" cnt = cnt + 1 wend Using this code when I see new file it puts one character (look like small rectangle) before " how would i get rid of this character??? If i run this code...it works fine while cnt <= ubound(lines) myFile.WriteLine "body = body & """&lines(cnt) cnt = cnt + 1 wend how would i append " at end of each line without having special character..i tried to copy and paste to hear but i am unable to paste...may be its carriage return or line feed... thanx dave Tag: session quiz Tag: 296994
  - 25
    - IIS process only .ASPX files Hi I have installed IIS on WINDOWS 2003 server. IIS is working only if I type filename.aspx for .asp or any other file its giving "HTTP Error 404 - File or directory not found. " Please advise what I am doing wrong. Regards Tag: session quiz Tag: 296989
- Next
  - 1
    - Redefined variable Hi everybody, In an ASP page, I need to load twice an include file that contains variables. So I get an error message "variable redefine" I tried to test with VarType before to define the variable (dim) with no success. Is it faisable with VBScript to define a variable (dim) under condition. ' this code gives an error if VarType("MyVar") = vbNull then dim MyVar end if many thank's serge Tag: session quiz Tag: 296977
  - 2
    - Adding rows to database table thro ASP Hi, I want to add a row to library table. Table has total 7 fields. But I want to create the new row with 5 field data. When I run the following query in MS Access strQ = "INSERT into library (index,title,author,itemtype,createdate) VALUES ('B-096','Hihihihihi','hello','Book','07/18/04')" It successfully adds the row. But same thing I am trying with the following ASP code. It gives error, saying syntax error in INSERT into statement. Can anybody suggest me, what is wrong in my code below. Any help is appreciated. Thanks in advance, Vasanth ----------------------------- <% option explicit Response.ExpiresAbsolute = "January 1, 2003" Dim path, mdbFilePath, sPos, objConnect, objRst, strQ, x for each x in Request.Form execute x & "="""&Request(x)&"""" next path = Request.ServerVariables("PATH_TRANSLATED") sPos = InStr(path, "library\newupdate.asp") if sPos = 0 then sPos = InStr(path, "library/newupdate.asp") end if mdbFilePath = Left(path, sPos-1) & "library.mdb" Set objConnect = Server.CreateObject("ADODB.Connection") objConnect.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & mdbFilePath & ";" Set objRst = Server.CreateObject("ADODB.Recordset") Set objRst.ActiveConnection = objConnect 'strQ = "INSERT into library (index,title,author,itemtype,createdate) VALUES ('"&session("index")&"','"&title&"','"&author&"','"&session("itemtype")&"',' "&date&"')" strQ = "INSERT into library (index,title,author,itemtype,createdate) VALUES ('B-096','Hihihihihi','hello','Book','07/18/04')" objRst.Open strQ Set objRst = nothing objConnect.Close Set objConnect = nothing %> <html> <head> <title> </title> </head> <body> Library Item, <%=session("index")%> has been created on <%=date%>. </body> </html> Tag: session quiz Tag: 296973
  - 3
    - Setting message priority with CDOSYS Hello. Can someone please tell me how to set the priority of an email message sent from an ASP script using CDOSYS as below - set oCdoMsg = server.createobject("CDO.Message") oCdoMsg.from=... oCdoMsg.to=... oCdoMsg.subject=... oCdoMsg.importance=1 ' fails oCdoMsg.HTMLBody=.... oCdoMsg.send With CDONTS I successfully used .importance but that fails with CDOSYS. I have searched the MSDN documentation but can't find it. BTW I find the various alternatives confusing - CDO, CDONTS, CDOEX etc. Thanks in advance for any help. Peter Croft Tag: session quiz Tag: 296972
  - 4
    - [NEWBIE] Viewing ASP files (.ASP extension) Dear group, I have never done any ASP coding before (Just HTML and Javascript as far as web pages go - and got on fine) I would like to start writing some ASP scripts, but I am having difficulties viewing '*.asp' files on my PC, when I open them only the HTML aspects of the code displays or I just get a blank browser window.. I am running XP, is there something special that I need to install? Please forgive me for asking what probably sounds like a stupid question, but as you have probably gathered I haven't got a clue!!! :o) Thanks, Cassandra I am trying to create a simple "Tell A Friend" page. The code I have is as follows: **************************************************************************** ********************************************** (File: Functions.asp) <% function mail(mMessage, mFrom, mTo, mSubject) Dim objMail Set objMail = Server.CreateObject("CDONTS.NewMail") objMail.From = mFrom objMail.Subject = mSubject objMail.To = mTo objMail.Body = mMessage objMail.Send set objMail = nothing end function function tellFriend(pageName) if Request.QueryString("mailsent") = "true" Then Response.Write "<P><strong>Your recommendation has been sent.</strong></P>" end if Response.Write "<P>To tell a friend about this page, complete your friend's name and email address and write your name and email address below.<P>" &vbCrLf Response.Write "form method = ""post"" action = ""tellafriend_script.asp""> &vbCrLf Response.Write "<p>Your name:<br />" &vbCrLf Response.Write "<input type=""text"" name=""senderName"" id=""senderName"" /></P>" &vbCrLf Response.Write "<P>Your Email Address:<br />" &vbCrLf Response.Write "<input type=""text"" name=""senderEmail"" id=""senderEmail"" /></P>" &vbCrLf Response.Write "<p>Your friend's name:<br />" &vbCrLf Response.Write "<input type=""text"" name=""friendName"" id=""friendName"" /></P>" &vbCrLf Response.Write "<P>Your Friend's Email Address:<br />" &vbCrLf Response.Write "<input type=""text"" name=""friendEmail"" id=""friendEmail"" /></P>" &vbCrLf Response.Write "<input type =""hidden"" name=""pageName"" value=""" & pageName & """ />" &vbCrLf Response.Write "<input type =""submit"" value=""send!"" class=""submit""> </P>" &vbCrLf Response.Write "</form>" &vbCrLf end function %> **************************************************************************** ********************************************* (File: tellafriend_script.asp) <%@LANGUAGE = "vbscript"%> <%Option Explicit%> <!-#includefile=function.asp"-> <% Dim senderName, senderEmail, friendName, friendEmail, pageName Dim mailSubject, mailMessage, sendmail senderName = Trim(Request.Form("senderName")) senderEmail = Trim(Request.Form("senderEmail")) friendName = Trim(Request.Form("friendName")) friendEmail = Trim(Request.Form("friendEmail")) pageName = Trim(Request.Form("pageName")) mailSubject = senderName & " has recommended this web page to you" mailMessage = "Dear " & friendName & "," &vbCrLf &vbCrLf mailMessage = mailMessage & "your friend " & senderName & " has recommended that you visit the following page." &vbCrLf &vbCrLf mailMessage = mailMessage & "http://www.yourdomain.com/" & pageName &vbCrLf &vbCrLf mailMessage = mailMessage & "We have not stored your details." sendmail = mail(mailMessage, senderEmail, friendEmail, mailSubject) Response.Redirect(pageName & "?mailsent=true") %> **************************************************************************** ********************************************** (File: Tellafriend.html) <%@LANGUAGE = "vbscript"%> <%Option Explicit%> <!-#includefile=function.asp"-> <%Dim display%> <html> <head> <meta name="GENERATOR" content="Microsoft FrontPage 5.0"> <meta name="ProgId" content="FrontPage.Editor.Document"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>Tell a friend</title> </head> <body> <% display = tellFriend("tellafriend.asp")%> </body> </html> Tag: session quiz Tag: 296968
  - 5
    - Displaying Img from Access using BinaryWrite Hi, Becoming quite frustrated with this. I have a commercial database written in access and I'm trying to display some images, jpegs, stored in the DB on web page. My code is as follows: Response.ContentType = "image/jpeg" sql = "SELECT PartImage FROM Parts WHERE ShortID='AAPTM01'" Set rs = AMConn.execute(sql) If not rs.eof Then PicSize = rs("PartImage").ActualSize if PicSize > 0 then Response.BinaryWrite rs("PartImage").GetChunk(rs("PartImage").ActualSize) end if End If set rs = nothing All i get on the page is the image not found icon with the red cross in IE. What could possibly be going on? Any suggestions would be appreciated. Tag: session quiz Tag: 296967
  - 6
    - ASP and WebBots Can anyone enlighten me as to the spambot email harvesting process? I use to use javascript to protect my email address, but with security levels rising, I can't rely on everyone to have javascript enabled. I am currently using an encoding tool (UltimateMailto) that turns the email address into a combination of hex and dec code. I wondered if drawing the email from a database with asp is safe. Does an email harvesting bot read the .asp code or the page created by the .asp code? Any help and enlightenment would be appreciated. I HATE SPAM!!! Tag: session quiz Tag: 296959
  - 7
    - Distance betweeen 2 zip codes anyone knows what the formula is for finding a distance betweeen 2 zip codes? Aaron Tag: session quiz Tag: 296958
  - 8
    - Client printing format Hello, I have an ASP form to collect some data and then have the client print it out through their browser. I was wondering if there was any way to control and/or eliminate (from the server side) the additional text that gets printed on the page, such as: "page 1 of x" at the top of the page; The date at the bottom of the page; and the form name and path at the bottom of the page. Thanks, Joe Tag: session quiz Tag: 296951
  - 9
    - Form Submit quiz <form action="a.asp" method="get" > <input type="image" border="0" src="IMAGES/oklar.jpg"> </form> im usnig this codes to submit form when a user click on oklar.jpg(an image) .. but it submits form ***a.asp?x=6&y=8*** like this.. x and y takes randomize values... how can i remove x and y variables from my string... if it cant be possible how can submit a form when a user click my image file... Tag: session quiz Tag: 296947
  - 10
    - DSNLess troubles I'm trying to setup an Access DSNLess connection on my local computer. The following string works fine within the Dreamweaver interface. But when I upload to my server (locally) I get this error. Can anyone lend some insight? thanks Object required: 'oConn' /Connections/conn.asp, line 2 <% oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _ "Dbq=c:\inetpub\wwwroot\authors.mdb;" & _ "Uid=admin;" & _ "Pwd=" %> Tag: session quiz Tag: 296939
  - 11
    - simple question on vbScript SET statement Simply: On one .asp page I have: Set Session("mydictionary") = [dictionary object] Now the session variable has the dictionary object in it, then on another page ... Set x = Session("mydictionary") ... and I use the "x" variable with the properties of that object, etc. Question: Is "Set x = nothing" needed before the .asp page ends processing or redirects? From what I know the "x" variable is just a reference and does not need to be set to "nothing"... correct? Tag: session quiz Tag: 296938
  - 12
    - Types in ASP, is it possible? Hey everyone, I am writing a basic tournament submit site for a poker tournamen group I am in. The situation is we want to use code to calculate wha we owe other members at the end of the week. The way I figured to d this is read from the database and store tournament numbers in an arra then run a query for each tournament and cycle through the tournamen data assigning the information where needed. I can not find if you ca or how you can use a Typedef in ASP. Pretty much I want to create type then make an array of that type. ie: Type typTournamentInformation dim Number dim Member dim XYZ dim ETC End Type dim TInfo() as typTournamentInformation then I can assign what I read from the database to tinfo(x).XXX Is this possible in ASP - Kewl ----------------------------------------------------------------------- Posted via http://www.codecomments.co ----------------------------------------------------------------------- Tag: session quiz Tag: 296936
  - 13
    - page expired problem Hello All I have a web pagewhich queries a db and displays information on the subsequent page. On the subsequent page if I click back to previous page (this is a button with javascript code on it), it takes me to the previous page but the page says - "warning page expired". When I am in my company work environment, I dont get this page, it properly displays the information on the previous page but when I go to the client site, it gives me the problem All of us are on the same IE version and service packs. Could this be a programming issue or a security issue. Please advise Thank you Tag: session quiz Tag: 296933
  - 14
    - Enter key behavior Hi, When the cursor is in an INPUT TEXT control and the Enter key is hit, what it's happen. I mean what is the chain of actions starting from that point. I have an ASP application that save modifications (qty chang in an input text) when the user navigate from page to page. For doing so I check if the value of the TEXT control differ from the value in the table. If so, I insert or update the table. But, when I hit Enter it is exactly the same as if I moved to another page. I would like to know exactly what's happen, in order to take advantage of this behavior. thank's serge Tag: session quiz Tag: 296928
  - 15
    - action cancelled error i am using iis 6.0 ,application pool and com+ .previous version iis 5.0 one of asp page work correctly it takes about 3 minutes.but now i get error as "action cancelled" and no error number displayed,i set commandtimeout parameter 500 in asp page and increase iis asp scripttimeout like 500 also change com+ enable idle shutdown parameters as 30.but this page give same error, how can i solve this problem Tag: session quiz Tag: 296917
  - 16
    - Generating navigation Hi guys, I'm using the Webedit Pro CMS for a client. When the user creates a new page, rather than go through every other page in the site and add a new link to the left hand navigation I want to use an include file and search the folder for all .asp and .htm files and display them in the navi as a link. If that makes sense? I've been playing around with FileSystemObject, but am struggling to get the desired results. Rather than display the full name of the file in the navi, I want to remove the file extension and the path, and maybe convert the leading letter to a capital so it looks like a regular nav. If anyone has done this before, or can point me to something that would help then I would appreciate it! regards, Tom Tag: session quiz Tag: 296916
  - 17
    - Will these objects be closed and destroyed? In the code below I have a Response.End in the middle of a Do loop that is run if the condition in a nested 'If...' statement is not met. Will the rs and conn objects be closed and destroyed if the Response.End is called or will they be left open? connStr = "PROVIDER=OraOLEDB.Oracle; DATA SOURCE=xyz; etc..." Set conn = Server.CreateObject("ADODB.Connection") conn.Open connStr rs = Set Conn.Execute("Select A,B,C from TblTableName Where Blah = 'Blah'") Do While Not rs.eof If rs("A") = "Tra la la" Then 'Do something Else Response.Write("Some message") Response.End End If Loop 'Do other stuff... rs.Close Set rs = nothing conn.Close Set conn = nothing Tag: session quiz Tag: 296912
  - 18
    - Previous return values from a BE method are shown when refreshing an ASP calling that method My ASP always calls a DLL that was constructed using VFP Code. If needed, this DLL can call a VFP External Class Method that is outside the DLL for some process. The DLL is bound with COM always. I have this External Class setup because, If a quick fix is needed, I can manage this with just sending modified External Class Library instead of the DLL. But the problem arrives this way. - Call ASP to receive old value X from existing External Class Method - this works fine - Call ASP to receive new value Y from modified External Class Method - this does not work - Shutdown COM object that cotains DLL and then, - Call ASP to receive new value Y from modified External Class Method - this works fine My only idea to have External Class Library is not to disturb existing COM setup (shutdown etc) for any quick fix. Does anybody have a clue whether can I achieve this without disturbing COM? - Shekhar Tag: session quiz Tag: 296911
  - 19
    - Get Bad Data from a Recordset Call Here's the code: ------------------------------------------------------------------- accessID = request("accessID") strSQL = "SELECT * From PendingAccRequests Where AccessID = "&accessID 'Create the Recordset object and run SQL statement Set accRS = Server.CreateObject ("ADODB.Recordset") accRS.Open strSQL, objConn If request("confirm") = "yes" then strSQL = "Select * From AccessMaster Where RequestID = "&accessID 'Create the Recordset object and run SQL statement Set masterRS = Server.CreateObject ("ADODB.Recordset") masterRS.CursorLocation = adUseClient masterRS.Open strSQL, objConn,, adLockOptimistic masterRS.AddNew masterRS("PropownID") = accRS("Bld_Owner_ID") masterRS("FileName") = accRS("PROPOWN_Name") masterRS("Multiagreement") = False masterRS("OpenDate") = Date() masterRS("requestID") = accessID masterRS.Update strSQL = "Select * From Access Where MasterID = "&masterRS("MasterID") 'Create the Recordset object and run SQL statement Set newRS = Server.CreateObject ("ADODB.Recordset") newRS.CursorLocation = adUseClient newRS.Open strSQL, objConn,, adLockOptimistic newRS.AddNew newRS("Prop_Owner_ID") = accRS("Bld_Owner_ID") newRS("Acct_Mgr") = accRS("Assigned") newRS("Status") = "OPEN" newRS("Source_Date") = accRS("AccessDate") If Not IsNull(accRS("ProjID")) then newRS("Source_Info") = "SALES REQUEST" Else newRS("Source_Info") = "CONSTRUCTION" End If newRS("File_Received") = Date() newRS("MasterID") = masterRS("MasterID") newRS.Update If Not IsNull(accRS("ProjID")) then strSQL = "Insert Into AccessBldg (AccessID, BidID) "&_ "Select "&newRS("AccessID")&", BID_ID from ConstructionBldg Where ProjectID = "&accRS("ProjID")) objConn.Execute(strSQL) strSQL = "Update Building Set Bld_Access_ID = "&masterRS("MasterID")&" Where Bld_Address_ID in "&_ "(Select Bid_ID From ConstructionBldg Where ProjectID = "&accRS("ProjID")) &")" objConn.Execute(strSQL) Else strSQL = "Select * From AccessBldg Where AccessID = "&accIDRS("AccessID") 'Create the Recordset object and run SQL statement Set accBldRS = Server.CreateObject ("ADODB.Recordset") accBldRS.CursorLocation = adUseClient accBldRS.Open strSQL, objConn,, adLockOptimistic accBldRS.AddNew accBldRS("AccessID") = accIDRS("AccessID") accBldRS("BidID") = accRS("BidID") accBldRS("suite") = accRS("Suite") accBldRS.Update strSQL = "Select * From Building Where Bld_Address_ID = "&accRS("BidID") 'Create the Recordset object and run SQL statement Set bldRS = Server.CreateObject ("ADODB.Recordset") bldRS.CursorLocation = adUseClient bldRS.Open strSQL, objConn,, adLockOptimistic bldRS("Bld_Access_ID") = masterRS("MasterID") bldRS.Update End If strSQL = "Update AccessRequest Set Completed = 1 Where AccessID = "&AccessID objConn.Execute(strSQL) Response.Redirect("handler.asp?id="&newRS("AccessID") ) End If --------------------------------------------------------------- Now you'll notice I'm updating and pulling from multiple recordsets. Here's the problem. PendingAccRequests is a View, and when I run the SQL query (Where AccessID = "&accessID), I get good data. So I plug it into accRS. Now in that row there is a column called projID... it has the number 477 in it. But Anytime I try and call that field (accRS("ProjID")) I get nothing. It Will Not return my 477. This is the problem Just FYI. When I call newRS("AccessID") which is the ident key of the record I'm adding, I also get nothing. When I call accRS("Assigned") which is filled with the number 47, I get nothing. When I call masterRS("MasterID") which is another ident field of a recordset I'm adding. I get the wrong number. I do not know where the number is coming from. Can anyone tell me what could be wrong??? Thanks Tag: session quiz Tag: 296906
  - 20
    - website on a CD I want to create a dynamic website hosted on a CD. It would be based on ASP and have a database. Is this possible? How would I approach such a thing? I'm sure I could by a runtime version of Access and build an application, but could that be implemented within the website? Any thoughts? I don't want the user to install anything on their hardrive if possible. thanks! Tag: session quiz Tag: 296904
  - 21
    - formatting string Hi Guys I have one string variable and value stores something like this st = "From: ""John Thomas"" <john@test.com.au>" when i test it display some thing like From: "John Thomas" <john@test.com.au> How can I pick up only display name and without double quotes. i.e. it should display only John Thomas Thanx for helping dave Tag: session quiz Tag: 296903
  - 22
    - Multi-column combo box, change width on select Has anybody ever seen or written code for ASP that would mimic Access' multi-column combo box? Specifically, I have a drop down box that lists about 100 five-digit codes. Each of these codes has a long text description that explains what the code represents. I'd like to be able to show the code plus description when the drop down list is dropped down, but just the code when the list is not displayed, so that I don't have to have a hugely long combo box taking up space. So, for instance, if I had a drop down list of airports and I'd selected SeaTac, I'd just see SeaTac in the drop down box text area, but if I were to click on the arrow and drop down the list, I'd see: SeaTac Seattle-Tacoma International Airport MCI Kansas City, MO International Airport etc... I know you can change the width of the combo box through javascript, but that screws up the rest of the fields to the right. Plus, whenever I change the width on the onclick event, it hides the list and I have to click again. Is there anyway to just change the width of the list area? TIA, Diane Tag: session quiz Tag: 296896
  - 23
    - Hidden value Hello I seem to be having a problem with saving hidden values. I am trying to use the hidden values to post infomation back to the same page and also to a different second page. I would like to persit the values to a couple of more pages in this process. I have ten different values that I am trying to save. The problem is I dont see these Request objects on the second page. I have another .asp page that is included and processed on this second page (). Do I need to pass the request items to this include file and to the real page? I must be doing something wrong however I am not quite sure what I must me doing wrong. This a snippet from the original page. <tr> <td width="33%" align="right">Region: </td> <td align=left width="66%"> <input type="text" name="txtRegion" id="txtRegion" value=<%= strRegion %> ></td> </tr> <Input Type="hidden" Name="VendorRegion" Value ='"<%=Request.form("txtRegion")%>">' ....... </form> </BODY> </HTML> This a snippet from the second page. I am trying to grab the value here so that I can use this value on the page. strRegion = trim(Request.form("VendorRegion").item) ...... <HTML> <HEAD> <TITLE> Thanks for any insight! Tag: session quiz Tag: 296895
  - 24
    - Displaying recordsets I'm trying to display different recordsets (which are 1 field each) as columns right next to one another. For example, Recordset1 is displayed on the left hand side of the screen. Recordset2 is displayed immediately to the right of then first recordset with the first rows or each at the same level. Recordset3 is displayed to the right of Recordset2 and so on. There is no set limit to the number of possible recordsets (or columns to display). Imagine a spreadsheet where each column is a different recordset. How can I display that using ASP? Tag: session quiz Tag: 296893
  - 25
    - submit() QueryString data Hi, Is there a way to append the QueryString data when using <Script>document.FrmName.submit()</Script> Thank's in advance serge Tag: session quiz Tag: 296885

i have a site which uses session("xx") value.. in my site i take a variable
and
session("xx")=request("xx")

im my url www.xx.com?xx=aaaaa

it works... and i click another page in this url www.xx.com/d.asp the
session variable is ok...

but another page

www.yy.com

in a frame it opens my page to sending xx value... i take in my first
page... but in www.yy.com i click my page and go to another page in frame(my
page) the session variable is empty.. why? any idea....

Top

Re: session quiz by Ray

Ray
Tue Jul 20 10:35:53 CDT 2004

Sessions cannot be shared across domains or sites.
http://www.aspfaq.com/show.asp?id=2157

ALSO READ THIS:
http://www.aspfaq.com/show.asp?id=2111

Ray at work

"Savas Ates" <savas@indexinteractive.com> wrote in message
news:uRAl1imbEHA.3420@TK2MSFTNGP12.phx.gbl...
>i have a site which uses session("xx") value.. in my site i take a variable
> and
> session("xx")=request("xx")
>
> im my url www.xx.com?xx=aaaaa
>
> it works... and i click another page in this url www.xx.com/d.asp the
> session variable is ok...
>
> but another page
>
> www.yy.com
>
> in a frame it opens my page to sending xx value... i take in my first
> page... but in www.yy.com i click my page and go to another page in
> frame(my
> page) the session variable is empty.. why? any idea....
>
>
>
>

Top