Do I use a Join statement?

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
    - using vbscript to write jscript Hi All, Please, if this is not the group for this, let me know and I'll post it to where it may get answered Also please excuse the relative length of this post as I needed to get the information across. I'm using Sub procedures written in vbscript to try an catch input errors client-side. I have a portion of it working but am having a devil of time trying to complete it. **the following "Call code" is on the page default.asp, a basic data entry page with 6 text boxes (4 required) and 2 select boxes (1 required). **of the 4 required text boxes only 1 has to be a minimum length of 7 and each character in it must be numeric. The other 3 have no other restrictions. **the Sub procedures being called are on the include file ValidatorClient.asp **Each Call of WriteFormFieldTextRequired works, but..... **Whenever I try to Call FieldMinLength (even by itself) the page reacts as if this entire Call sequence isn't there. Even the Call of WriteFormFieldTextRequired does not work; i.e. pop up an alert box. '<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> Call WriteFormHeader("Form1Validator") Call WriteFormFieldTextRequired("txtStudentIDNumber", "Student ID Number") '--------------------------------------------------------------------------- 'when this is uncommented out this whole call group seems as if it has not been called, just blown by. 'Call FieldMinLength("txtStudentIDNumber", 7, "Student ID Number") '--------------------------------------------------------------------------- Call WriteFormFieldTextRequired("txtStudentFirstName", "First Name") Call WriteFormFieldTextRequired("txtStudentLastName", "Last Name") Call WriteFormFieldTextRequired("selResidenceHall", "Residence Hall") Call WriteFormFieldTextRequired("txtRoomNumber", "Room Number") Call WriteFormFooter() 'and fyi the form tag <form action="default.asp" method="post" id="PreReg" name="PreReg" onSubmit="return Form1Validator(this)"> '<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> **the include page ValidatorClient.asp as is: <% '---------------------------------------- ' Accepts strFunctionName as string - Name of javascript function '---------------------------------------- Sub WriteFormHeader(ByVal strFunctionName) With Response .Write(" <scr" & "ipt type=""text/javascript"">") & vbCrLf .Write(" ") & vbCrLf .Write(" </scr" & "ipt>") End With End Sub %> Any questions pleae so not hesitate to ask. Thank you for your time and in advance for your help. gdr -- Gary D. Rezek University Networking Services South Dakota State University Tag: Do I use a Join statement? Tag: 290864
  - 2
    - Authenticating Twice ??? I have an ASP website that is challenging twice. I've checked the access over and over and cannot see why this is happening. Any thoughts ? Thanks, Paul Tag: Do I use a Join statement? Tag: 290861
  - 3
    - Session variables I am trying to use Session("xxx"). When I declare the variable like this on page or in procedure, it doesn't work. Session("xxx") = "1234" Have also tried declaring it in Global.asa, but it doesn't printanything when I use <%=Session("xxx")%>. Any clues? Do I have to tell ASP or IIS that I'm using a Session Variable or something? I have followed several examples with like results. What i want to do is to have the user login, and their password be accessible from any page so they don't have to constantly relog. Any tutorials or links? TIA ck Tag: Do I use a Join statement? Tag: 290858
  - 4
    - comprehensive header list Does anyone know of a comprehensive header list available somewhere for the http protocol? Tag: Do I use a Join statement? Tag: 290856
  - 5
    - Bulk Mail Hope this is not too far off topic - Anyone out there able to point me to a good hosting service that allows bulk mail (Preferably in the UK)? I currently use Fasthosts for about 50 sites but a couple of customers want to be able to send newsletters and the like to members, about 500 max., and Fasthosts will only allow 10 mails per 30 secs. and/or 50 per hour. I originally set this up with CDONTS Newmail object on asp pages, which is when I found out about the Fasthosts rules. They won't budge so I must find a new host. TIA Clive Moss Tag: Do I use a Join statement? Tag: 290853
  - 6
    - Buffering cannot be turned off once it is already turned on. WTF???? I mean, really now....... Why can't it be turned off, since it's on? But this now raises a good, when do you turn it on, when do you turn it off? Why would a website have some scripts have it turned on, and other scripts have it turned off? -- 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: Do I use a Join statement? Tag: 290852
  - 7
    - Connect to Access 2002 on local computer Here's the code I'm trying to use; basic ASP code and it just reads the records in the database: I want to use it on my local computer where this file "ReadRecords.asp" and the "calgarywebconcepts_Master.mdb" file are both in the Inventory directory. I'm using Access 2002 and my problem seems to be in how I'm trying to connect to the database (the first 13 lines). Can anyone see a problem with this? I connect very well on my website using: set conn = Server.CreateObject("ADODB.Connection") conn.Open "calgarywebconcepts_Master" set rs = Server.CreateObject("ADODB.Recordset") rs.Open "Inventory", conn, adOpenStatic, adLockOptimistic, adCmdTable BUT... I want to set up a database on my local computer and use some of my asp files (through frontpage). Thanks... Steve  <% dim strconn dim rs dim conn strconn="Provider=Microsoft.Het.OLEBD.3.51; Data Source=C:\Inventory\calgarywebconcepts_Master.mdb" set conn = Server.CreateObject("ADODB.Connection") conn.Open "strconn" set rs = Server.CreateObject("ADODB.Recordset") rs.Open "Inventory", conn, adOpenStatic, adLockOptimistic, adCmdTable Response.Write "<TABLE BORDER=""1"" CELLSPACING=""2"" CELLPADDING=""2"">" & vbCrLf Response.Write vbTab & "<TR>" & vbCrLf Response.Write vbTab & vbTab & "<TD><B>Department</B></TD>" & vbCrLf Response.Write vbTab & vbTab & "<TD><B>ItemNo</B></TD>" & vbCrLf Response.Write vbTab & vbTab & "<TD><B>ItemName</B></TD>" & vbCrLf Response.Write vbTab & vbTab & "<TD><B>Description</B></TD>" & vbCrLf Response.Write vbTab & vbTab & "<TD><B>Price</B></TD>" & vbCrLf Response.Write vbTab & vbTab & "<TD><B>Quantity</B></TD>" & vbCrLf Response.Write vbTab & vbTab & "<TD><B>DateAdded</B></TD>" & vbCrLf Response.Write vbTab & vbTab & "<TD><B>DateSold</B></TD>" & vbCrLf Response.Write vbTab & vbTab & "<TD><B>DateTransferred</B></TD>" & vbCrLf Response.Write vbTab & vbTab & "<TD><B>DateReturned</B></TD>" & vbCrLf Response.Write vbTab & vbTab & "<TD><B>PictureSmall</B></TD>" & vbCrLf Response.Write vbTab & vbTab & "<TD><B>PictureLarge</B></TD>" & vbCrLf Response.Write vbTab & vbTab & "<TD><B>Color</B></TD>" & vbCrLf Response.Write vbTab & vbTab & "<TD><B>Size</B></TD>" & vbCrLf Response.Write vbTab & vbTab & "<TD><B>Special</B></TD>" & vbCrLf Response.Write vbTab & vbTab & "<TD><B>Discount</B></TD>" & vbCrLf Response.Write vbTab & "</TR>" & vbCrLf If Not rs.EOF Then rs.MoveFirst 'Show data Do While Not rs.EOF Response.Write vbTab & "<TR>" & vbCrLf For I = 0 To rs.Fields.Count - 1 Response.Write vbTab & vbTab & "<TD>" & rs.Fields(I) & "</TD>" & vbCrLf Next Response.Write vbTab & "</TR>" & vbCrLf rs.MoveNext Loop End If Response.Write "</TABLE>" & vbCrLf rs.Close set rs=nothing 'Close Recordset Object conn.Close Set conn=Nothing 'Delete connection Object %> <html> <head> <title>ReadRecords.asp</title> </head> <body BACKGROUND="images/bkg_white.jpg"> </body> </html> Tag: Do I use a Join statement? Tag: 290850
  - 8
    - hiding querystring in URL if I have a page which insert info into a DB, and then redirects the user to another page, with the following code: Response.Redirect("index.asp?p=confirm&Action=" & Request("Action") & "&FName=" & Server.URLEncode(Request("FName")) & "&Email=" & Request("Email") & "&newcode=" & Server.URLEncode(newcode) & "") how can I hide the stuff after the URL? This is what I get: http://hobbit/newhp/index.asp?p=confirm&Action=New&FName=Rudi&Email=theesain t@bonzai.org.za&newcode=M7EW1RZO This is not a form, so it's not todo with the GET / POST actions. -- 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: Do I use a Join statement? Tag: 290828
  - 9
    - Forcing to authentificate every tiome Hi all, I've a page with requirement to authentificate access every time when user loads it. I put it into separate directory and I could set BASIC authentification and it works fine except one thing - an authentification is asked only first time a page is accessed. All next requests don't require to authentificate (til you close your browser). Is any solution in this situation? Tnx in advance, Jonas Tag: Do I use a Join statement? Tag: 290827
  - 10
    - which scripting languages can be used? Here is an interesting question, and it's not aimed at anything other than to help every coder / developer / programmer out there. I was wondering, which languages can be used in .asp files? I know one can use vbscript / JavaScript / jsp / perl. But, what about C++ / C / cobal / python / visual basic / fortan? and, if you want to use any of these, how would you do it? The default codepage is <% @ LANGUAGE = "VBScript"%>, which as we can see if vbscript. But, let's say you are a PHP programmer / C++ programmer, and you don't really want to learn a new programming language (but would learn new concepts / platforms / RDBMS), wouldn't it make life much easier? -- 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: Do I use a Join statement? Tag: 290826
  - 11
    - authentication Hi, I am running IIS server for hosting webpages. For one of the folders I want to enable the authentication. How to do this? My webpage is not asking login/password, when the page is accessed in browser. I don't want to maintain one more set of username & passwords. Server has already username & passwords. I just want to use that facility. All I need is only username in my scripts. I want this authentication only for few pages/folders. Any help appreciated. Can somebody suggest me a good book. Regards, Vasanth Tag: Do I use a Join statement? Tag: 290823
  - 12
    - Server access I have several ASP applications on my WinXP-Pro server. Typically I only allow users to access my server on a demo basis. Once the system goes live I remove their access and install the application on their own server. I now have a situation where a company wants to subscribe to one of my applications and I host it on an ongoing basis. In the past I have given demo users "Basic" access to my server and created a temporary user under the "manage" option, but now I want to give these new subscribers only access to the directory where their application resides ... and nowhere else. How do I set this up ? The only options are ... 1. Anonymous 2. Basic 3. Integrated Tag: Do I use a Join statement? Tag: 290803
  - 13
    - How can I change the content in cache before I send it to client in ASP? Can anyone help me?Thanks a lot. Tag: Do I use a Join statement? Tag: 290798
  - 14
    - Export to Excel or txt File Hi I access a MySql Dbase and the results go in screen just fine (1 record per line etc) I want to export the data into excel and read that putting this at the top of my code would do the trick <%Response.ContentType = "application/vnd.ms-excel"%> However Im not prompted to save the file and the output just gos to the screen, I could make do with saving as a txt file but am not sure of the application type ? Pointers appreciated. Regards John Berman john_berman@blueyonder.co.uk Tag: Do I use a Join statement? Tag: 290789
  - 15
    - Please help Hi, I am creating a site on ASP and SQL, which would essentially be hosted in a third party server like Interland or Net4India. It is dynamic in nature, i.e. has its own database. But I have got a module in where I would need to connect to an remote SQL server, which is located somewhere else. I know the IP address. I would need to copy a table from that sql server to my server, and synchronize it regularly, just in case something is updated. Now my problem is, (1) How do I connect to that remote sql server using ASP. (2) Please suggest what method should I adopt to copy and synchronize the data between the two servers. Thank you very much, Regards, Bhaskardeep Tag: Do I use a Join statement? Tag: 290784
  - 16
    - MD5DLL: Anyone? Hi, Refer to the following code: <% set oMD5 = Server.CreateObject("MD5DLL.Crypt") Response.Write oMD5.EnCrypt("1") %> If you replace "1" with "2", the result will be the same, that is empty!! In this case, how can I store the encrypted password in my database?? How to perform comparison? Also, there is a bug whereby you can't do concatenation, why? Can somebody help? Thanks a lot! Best regards, Antonio Tag: Do I use a Join statement? Tag: 290778
  - 17
    - asp using xslt error: msxml3.dll (0x80004005) This xslttest.asp will call xmldata.xml and table.xsl to output table.html. However, it has the following run-time error on code: xml.transformNodeToObject xsl, ofile 'produces UTF-8: Error Type: msxml3.dll (0x80004005) The stylesheet does not contain a document element. The stylesheet may be empty, or it may not be a well-formed XML document. Any ideas? Thanks!! //---------------------------- xslttest.asp ----------------------------------------------- <% Set xml = CreateObject("Msxml2.DOMDocument") Set xsl = CreateObject("Msxml2.DOMDocument") xml.async = False xsl.async = false xml.Load "xmldata.xml" xsl.Load "table.xsl" set ofile = CreateObject("ADODB.Stream") ofile.Type = 2 ofile.Charset = "Windows-1252" ofile.LineSeparator = -1 ofile.open xml.transformNodeToObject xsl, ofile 'produces UTF-8 ofile.SaveToFile "table.html", 2 %> //------------------------------ xmldata.xml ---------------------------------------------- <?xml version="1.0"?> <level1> <level2> <level3> <name>name1</name> <value>value1</value> </level3> <level3> <name>name2</name> <value>value2</value> </level3> </level2> <level2> <level3> <name>name3</name> <value>value3</value> </level3> </level2> </level1> //----------------------------------- table.xsl -------------------------------------------- <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:ms="urn:schemas-microsoft-com:xslt"> <xsl:output method="html" encoding="UTF-8" indent="yes" /> <xsl:template match="/"> <html> <body> <table> <xsl:for-each select="//level3"> <tr> <td><xsl:value-of select="name" /></td> <td><xsl:value-of select="value" /></td> </tr> </xsl:for-each> </table> </body> </html> </xsl:template> </xsl:stylesheet> Tag: Do I use a Join statement? Tag: 290774
  - 18
    - objFSO.FileExists not working????? I have the following link: http://hobbit/newhp/index.asp?l=advert, and it doesn't do what I want it to do, even though the file exists. If a file doesn't exist, it should use home.asp as default, yet it uses home.asp as default regardless if the file exists or not? Here is the script: linkname = request.QueryString("l") if linkname <> "" then page = linkname & ".html" If objFSO.FileExists(page) = false Then page = "home.asp" End If end if If http://hobbit/newhp/index.asp?l=advert123 (which doesn't exist) it goes to home.asp, which is what I want, but it also does it for all the files that does exist, and reason for that? -- 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: Do I use a Join statement? Tag: 290771
  - 19
    - can i modify the content in the buffer of response(not response.buffer prep) Tag: Do I use a Join statement? Tag: 290768
  - 20
    - Fill A VB6 Recordset Using The ASP Response Object My old development computer, Windows XP Pro, Visual Basic 6 SP5, used then following with success to fill a VB6 recordset from an ASP page, but my new computer, Windows XP Pro, Visual Basic 6 SP6, gives an error: SomePage.ASP looks like this with no HTML: Set xConn = Server.CreateObject("ADODB.Connection") xConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("data/db.mdb") Set rst = xConn.Execute("SELECT TOP 100 PERCENT whatever") rst.Save Response rst.Close Set rst = Nothing xConn.Close Set xConn = Nothing VB app looks like this: Set rst = New ADODB.Recordset rst.Open "http://somedomain.com/asp/somepage.asp" The error message upon executing the rst.open statement is: Error #3709 The connection cannot be used to perform this operation. It is either closed or invalid in this context. How do I fix the problem? Thank you kindly, Dan Sikorsky Tag: Do I use a Join statement? Tag: 290764
  - 21
    - counter Hi im trying to build a page counter type thing which will update a database on the number of times a certain page has been opened... however if a person skips to another page and back again during the same "Session" i dont want the counter to increment.... ive looked at session variables but this mightnt work as they are changing constantly for the application... i want to be able to count how many times a photo gallery, album and image are accessed in the gallery. the galleries contain albums which contain photos, but i dont want to increment the album viewed number each time a user flicks back from an image to select another image Is there like a unique session ID type thing that is assigned to a user that i can use to compare ? Tag: Do I use a Join statement? Tag: 290754
  - 22
    - Invalid URL form or fully-qualified absolute URL was used. Use relative URLs Please help, I have tried all possible routes. I have a table with a layout, and in one of the cells, I have : <%=server.Execute(page)%> The code that gives me this problem is: newslink = request.QueryString("n") IDno = request.QueryString("ID") if newslink <> "" then page = "news/" & newslink & ".asp" If objFSO.FileExists("/news/" & page) = false Then page = "news/news.asp" End If if IDno <> "" then page = page & "?ID=" & IDno end if else page = "home.asp" end if Now, when I type the following URL in, http://localhost/newhp/index.asp?n=news, then it works fine If, however I type in http://localhost/newhp/index.asp?n=news&ID=71, I get the above error. all the news stuff is in a seperate folder, but that shouldn't be a problem. Please help? -- 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: Do I use a Join statement? Tag: 290746
  - 23
    - avoiding storing identical information In a Products database I have a field "How_to_Use" which is of memo type and is quite lengthy. Some products have the same How_to_Use value. This database is used, among other purposes, to build a product Data Sheet, which includes How_to_Use information. For the moment I have to store How_to_Use data (some being identical) against every product. So, if How_to_Use is modified, modification needs to be done for every product using this How_to_Use data. Is it possible instead of storing How_to_Use in the database, to store a reference to this info stored elsewhere (say, in a text file) and get it inserted into a resulting Datasheet asp file? I considered moving How_to_Use to a separate table, but this involves modifying the code logic. Tag: Do I use a Join statement? Tag: 290742
  - 24
    - where to post asp scripts Dear sir, I have some asp scripts/applications which I do not want any more... Does some one know where can I post them. I know hotscripts.com is a very good place. Any other website??? -- Kind regards Guoqi Zheng guoqi AT meetholland dot com Http://www.meetholland.com Tag: Do I use a Join statement? Tag: 290741
  - 25
    - Server.MapPath Object Question Hello, ASP, VBScript, IIS5. I have used the Server.MapPath object in the past in my web sites. What I am trying to do is before I map a path, to see if the folder is there. If so, map it. If not, do something else. Is there a way to do this? I tried the following: If Server.MapPath("testfolder") = True Then Set objFile = Server.MapPath("testfolder") End If but of course that doesn't work because MapPath doesn't support a Boolean value. Any ideas on what I need to do to accomplish this? Thanks, Chris Tag: Do I use a Join statement? Tag: 290731
- Next
  - 1
    - Dos command to check if file arrived through FTP Hi, is there a way to check if the file has arrived via DOS command(s)? thanks, Igor Tag: Do I use a Join statement? Tag: 290725
  - 2
    - Can Response.Cookie("X")("KEY1") leave existing keys intact? I am using a single cookie with up to around 20 or so KEY/VALUE pairs. I have an existing cookie built up through user interaction on the client side where events lead to writing out an associative array with Javascript via document.cookie. Then when the form is submitted, the page that is posted takes data out of the form and writes the cookie again (snippet follows): strCrumb = Request.form("ddState") if len(strCrumb) > 0 then Response.Cookies("MDW")("STATE") = strCrumb end if strCrumb = Request.form("ddCounty") if len(strCrumb) > 0 then Response.Cookies("MDW")("COUNTY") = strCrumb end if strCrumb = Request.form("ddMetro") if len(strCrumb) > 0 then Response.Cookies("MDW")("METRO") = strCrumb end if '... etc. (more of the same testing of form elements, setting of cookie keys) Response.Cookies("MDW").Expires = DateAdd("d", 180, Now) Response.Cookies("MDW").Path = "/" Response.Cookies("MDW").Domain = "www.mortgagedataweb.com" A typical Response.Cookies above "adds" or "replaces" a given key:value pair but I am noticing that it does not preserve any prior key:value pairs. In other words, any prior cookie key:value pair written by Javascript is lost if not in the above form. Is there a way to make the above example preserve an existing value for say, METRO, if the form only contains ddState and ddCounty? Ideally, I'd like the above code fragment to "merge" any matching values in the response.cookies collection leaving anything "unmatched" alone and preserved. Thanks. Tag: Do I use a Join statement? Tag: 290723
  - 3
    - Dynamic selct box from another select box First, let me apologize, I'm sure this has been posted before but I'm having trouble finding a good source of information. Ok ... I have a <SELECT> which is pulling a list of User Type's. Depending on what user type get's selected I want to bring up another <SELECT> which will display all of the available selections for that usertype ... i.e. If user type = Customer, then the second select box would bring up a list of Customers to select from. Any help much appreciated. Tag: Do I use a Join statement? Tag: 290718
  - 4
    - asp - db problem with connection. hi. ive recently put XP on my system which was running Win 2k. ever since this, i cant seem to get my asp stuff to interact with a database. even with code which wasn't changed since 2k. the error im getting each time i try to access a database is as follows.... Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xf40 Thread 0xaa8 DBC 0x15f8024 Jet'. /Brian/functions.asp, line 27 line 27 is the 3rd line of the code below.... any ideas would definately help...... DatabasePath = Server.MapPath("photoalbum.mdb") Set Conn1 = Server.CreateObject("ADODB.Connection") Conn1.Open = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & DatabasePath & "" Tag: Do I use a Join statement? Tag: 290715
  - 5
    - asp login I'm trying to create a website login page/form that has a simple UserName/Password feature. The page/form checks MS SQL Database Table to see if the UserName/Password exists. If it exists, it sends the user to the page depending on what UserName/Password they entered. I have a 'URL' field in the MS SQL 'LOGIN' table to accomodate the 'redirection' info. I also want to pass the 'UserName' and 'Password' as session variables and protect each page to avoid unauthorized viewing based on 'User Level' info. What's the best way to go about this? Please be thorough with your explanation. Thanks in advance for your help. Tag: Do I use a Join statement? Tag: 290707
  - 6
    - muliple select list This is a multi-part message in MIME format. --------------EA526924C8E3F24EFEA28EA0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit When using a multi-select list box named "category" on a submitted form, I can use... <% response.write "<p>Category = " & Request.Form("category") & "</p>" %> which shows me ... Category = 1, 2, 5 These are the values I expect from my selections. But my question is how can I put the selected values into an array, or get the values one at a time?? (What I really want to do is mathematically sum the selected values as in: var = 1 + 2 + 5.) I regret that I used to know this and have forgotten, but am working outside my usual environment and don't have the book nor on-line help to assist me. All I have for help is this forum, and Google (which hasn't been much help). Thanks for the help! Mark --------------EA526924C8E3F24EFEA28EA0 Content-Type: text/x-vcard; charset=us-ascii; name="Mark.Fenbers.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Mark J Fenbers Content-Disposition: attachment; filename="Mark.Fenbers.vcf" begin:vcard n:Fenbers;Mark tel;work:937-383-0430 x-mozilla-html:TRUE org:National Weather Service;Ohio River Forecast Center adr:;;;;;; version:2.1 email;internet:Mark.Fenbers@noaa.gov title:Sr. HAS Meteorologist fn:Mark J Fenbers end:vcard --------------EA526924C8E3F24EFEA28EA0-- Tag: Do I use a Join statement? Tag: 290702
  - 7
    - Statement on Spam and VoteNader.org  <html> <head> <title>Nader for President - Statement on Spam and VoteNader.org - www.voteNader.org</title> <link rel="stylesheet" href="http://www.votenader.org/css/main.css" type="text/css"> <link rel="stylesheet" href="http://www.votenader.org/css/module.css" type="text/css"> <script language="JavaScript1.2" type="text/javascript" src="http://www.votenader.org/js/api.js"></script> <script language="JavaScript1.2" type="text/javascript" src="http://www.votenader.org/js/setcaption.js"></script> </head> <body topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" marginheight="0" marginwidth="0"> <script language="JavaScript1.2" type="text/javascript"> </script> <table border="0" cellpadding="0" cellspacing="0" width="100%" name="boxBGHome" id="boxBGHome"> <thead> <tr valign="top" class="bannerBGColor"> <td valign="top" width="50%" height="85" colspan="2" class="bannerLeft">  <div id="bannerHomeLeft" name="bannerHomeLeft"><a href="http://votenader.org/index.php" alt="Homepage"></a></div>  </td> <td valign="top" width="50%" height="85" colspan="2" class="bannerRight">  <div id="bannerHomeRight" name="bannerHomeRight"><a href="http://votenader.org/index.php" alt="Homepage"><img src="http://www.votenader.org/img/logo/logo_banner_v2.gif" width="312" height="85" border="0" class="bannerLogo" name="bannerLogoImg" id="bannerLogoImg"></a></div>  </td> <td class="rightRuleGray" width="1" rowspan="3"><img src="http://votenader.org/img/s.gif" width="1" height="1" border="0" alt=""></td> </tr> <tr valign="top"> <td valign="top" width="100%" colspan="4"><div id="tnHome" name="tnHome" class="tnHome"><link rel="icon" href="http://votenader.org/favicon.ico"> <link rel="SHORTCUT ICON" href="http://votenader.org/favicon.ico"> <script language="JavaScript1.2" type="text/javascript"> // preload the top navigation item top right edge slant image tnEdge = new Image(); tnEdge.src="http://votenader.org/img/tn/tn_rt.gif"; </script> <div id="boxBGTN" name="boxBGTN"> <div id="mainContentTN" name="mainContentTN"> <span class="tnTab"><a class="tnText" href="http://votenader.org/why_ralph/index.php">  Why Ralph?<span class="tnRightEdge"><img src="http://votenader.org/img/tn/tn_rt.gif" width="7" height="21" border="0" alt="" align="middle"></span></a></span> <span class="tnTab"><a class="tnText" href="http://votenader.org/get_involved/index.php">Get Involved<span class="tnRightEdge"><img src="http://votenader.org/img/tn/tn_rt.gif" width="7" height="21" border="0" alt="" align="middle"></span></a></span> <span class="tnTab"><a class="tnText" href="http://votenader.org/ballot_access/index.php">Ballot Access<span class="tnRightEdge"><img src="http://votenader.org/img/tn/tn_rt.gif" width="7" height="21" border="0" alt="" align="middle"></span></a></span> <span class="tnTab"><a class="tnText" href="http://votenader.org/issues/index.php">Issues<span class="tnRightEdge"><img src="http://votenader.org/img/tn/tn_rt.gif" width="7" height="21" border="0" alt="" align="middle"></span></a></span> <span class="tnTab"><a class="tnText" href="http://votenader.org/calendar/index.php">Calendar<span class="tnRightEdge"><img src="http://votenader.org/img/tn/tn_rt.gif" width="7" height="21" border="0" alt="" align="middle"></span></a></span> <span class="tnTab"><a class="tnText" href="http://votenader.org/media_press/index.php">Media & Press<span class="tnRightEdge"><img src="http://votenader.org/img/tn/tn_rt.gif" width="7" height="21" border="0" alt="" align="middle"></span></a></span> <span class="tnTab"><a class="tnText" href="http://votenader.org/contact/index.php">Contact<span class="tnRightEdge"><img src="http://votenader.org/img/tn/tn_rt.gif" width="7" height="21" border="0" alt="" align="middle"></span></a></span> <span class="tnTab"><a class="tnText" href="http://votenader.org/subscribe/index.php">Subscribe<span class="tnRightEdge"><img src="http://votenader.org/img/tn/tn_rt.gif" width="7" height="21" border="0" alt="" align="middle"></span></a></span> <span class="tnTab"><a class="tnText" href="http://votenader.org/contribute/index.php">Contribute  <span class="tnRightEdge"><img src="http://votenader.org/img/tn/tn_rt.gif" width="7" height="21" border="0" alt="" align="middle"></span></a></span> <span><a href="http://votenader.org/contact/spam.php"><img src="http://votenader.org/img/icn/icn_spam_faq.gif" width="64" height="17" border="0" alt="SPAM Notice" /></a></td></span> </div> </div> </div></td> </tr> <tr valign="top"> <td valign="top" width="181" height="1"><img src="http://votenader.org/img/s.gif" width="181" height="1" border="0" alt=""></td> <td valign="top" width="45%" height="1"><img src="http://votenader.org/img/s.gif" width="254" height="1" border="0" alt=""></td> <td valign="top" width="45%" height="1"><img src="http://votenader.org/img/s.gif" width="118" height="1" border="0" alt=""></td> <td valign="top" width="194" height="1"><img src="http://votenader.org/img/s.gif" width="194" height="1" border="0" alt=""></td> </tr> </thead> <tbody> <tr valign="top"> <td valign="top" width="181" height="90%" rowspan="3"> <div id="leftColumnHome" name="leftColumnHome" class="leftColumn">  <script language="JavaScript1.2" type="text/javascript" src="http://votenader.org/js/ballot_access.js"></script> <style> #boxBGBallot { background-image: url(http://www.votenader.org/img/mod/mod_ballot_map_v3.gif); } #greenRect { background-image: url(http://www.votenader.org/img/mod/green_rect.gif); } </style> <div name="boxBGBallot" id="boxBGBallot"> <form name="ballotHome" id="ballotHome" action=""> <input type="hidden" id="stateContentId" name="stateContentId" value=""> <div id="ballotStatesListBox" name="ballotStatesListBox"> <label for="ballotStates" class="ballotAccessModule">Select State:</label><br> <select id="ballotStates" name="ballotStates" onchange="if(this.selectedIndex > 0) { selTxtVal = this.options[this.selectedIndex].text; stId = stateId[selTxtVal]; this.form.elements.stateContentId.value = stId; window.location = '../ballot_access/index.php' + '?cid=' + jsAPI.getObjRef('stateContentId').value + ';'; return false; };"> <option value="">Please select</option> <option value="AL">Alabama</option> <option value="AK">Alaska</option> <option value="AZ">Arizona</option> <option value="AR">Arkansas</option> <option value="CA">California</option> <option value="CO">Colorado</option> <option value="CT">Connecticut</option> <option value="DE">Delaware</option> <option value="DC">District of Columbia</option> <option value="FL">Florida</option> <option value="GA">Georgia</option> <option value="HI">Hawaii</option> <option value="ID">Idaho</option> <option value="IL">Illinois</option> <option value="IN">Indiana</option> <option value="IA">Iowa</option> <option value="KS">Kansas</option> <option value="KY">Kentucky</option> <option value="LA">Louisiana</option> <option value="ME">Maine</option> <option value="MD">Maryland</option> <option value="MA">Massachusetts</option> <option value="MI">Michigan</option> <option value="MN">Minnesota</option> <option value="MS">Mississippi</option> <option value="MO">Missouri</option> <option value="MT">Montana</option> <option value="NE">Nebraska</option> <option value="NV">Nevada</option> <option value="NH">New Hampshire</option> <option value="NJ">New Jersey</option> <option value="NM">New Mexico</option> <option value="NY">New York</option> <option value="NC">North Carolina</option> <option value="ND">North Dakota</option> <option value="OH">Ohio</option> <option value="OK">Oklahoma</option> <option value="OR">Oregon</option> <option value="PA">Pennsylvania</option> <option value="RI">Rhode Island</option> <option value="SC">South Carolina</option> <option value="SD">South Dakota</option> <option value="TN">Tennessee</option> <option value="TX">Texas</option> <option value="UT">Utah</option> <option value="VT">Vermont</option> <option value="VA">Virginia</option> <option value="WA">Washington</option> <option value="WV">West Virginia</option> <option value="WI">Wisconsin</option> <option value="WY">Wyoming</option> </select> <a href="javascript:void(0);" onclick="selSt = jsAPI.getObjRef('ballotStates'); if(selSt) { selTxtVal = selSt.options[selSt.selectedIndex].text; stId = stateId[selTxtVal]; selSt.form.elements.stateContentId.value = stId; window.location = '../ballot_access/index.php' + '?cid=' + jsAPI.getObjRef('stateContentId').value + ';'; }; return false;"><img src="http://votenader.org/img/btn/btn_go_green.gif" width="30" height="16" border="" alt="Go" align="middle"></a> </div> </form> </div> <script language="JavaScript1.2" type="text/javascript"> stateIdVal = " "; stateIdVal = parseInt(stateIdVal); if(!isNaN(stateIdVal)) { if(document.layers) { setTimeout("initBallotAccessModule(stateIdVal);",3333); } else { initBallotAccessModule(stateIdVal); } } </script> <div class="modShimH5"> </div> <script language="JavaScript1.2" type="text/javascript"> // // dynamic mainContentSubscribe content variable (USE NOT RECOMMENDED FOR COMPATIBILITY w/Netscape 4.xx) captionStrSubscribeLeft = false; contentStrSubscribeLeft = false; // </script> <form name="subscribeLeft" id="subscribeLeft" onsubmit="return jsAPI.validValueByRegExp((this.elements.email.value + '').toString(),/[\S]+\@[\S]+/);" action="" method="post"> <input type="hidden" name="domain" value="lists.votenader.org"> <input type="hidden" name="redirect" value="http://www.votenader.org/subscribe/thanks.php"> <input type="hidden" name="list" value="updates"> <input type="hidden" name="mode" value="subscribe"> <table border="0" cellpadding="0" cellspacing="0" width="100%" name="boxBGSubscribeLeft" id="boxBGSubscribeLeft"> <thead> <tr valign="top" onclick="document.location.href = '../subscribe/index.php';"> <td valign="top" width="100%" height="17"><p name="capTitleSubscribeLeft" id="capTitleSubscribeLeft" class="capSmTitleText"><a class="capSmTitleText" href="http://votenader.org/subscribe/index.php">Subscribe</a></p></td> <td class="capAngle" width="16" height="17"><img src="http://votenader.org/img/mod/hdr_angle_16x17_rt.gif" width="16" height="17" border="0" alt="" name="capAngleImg" id="capAngleImg"></td> <td width="1" height="1" valign="bottom" class="rightRuleWhite"><img class="rightRuleBlue" src="http://votenader.org/img/s.gif" width="1" height="1" border="0" alt="" align="bottom"></td> </tr> </thead> <tbody> <tr valign="top"> <td width="100%" colspan="2" bgcolor="#ffffff" width="100%"> <div id="mainContentSubscribeLeft" name="mainContentSubscribeLeft" class="mainContentText">  <table border="0" cellpadding="0" cellspacing="0" width="148" class="mainContentText" style="border: 0px dotted #990000;"> <tbody> <tr valign="top"> <td width="40"><img src="http://votenader.org/img/s.gif" width="40" height="1" border="0" alt=""></td> <td width="8"><img src="http://votenader.org/img/s.gif" width="8" height="1" border="0" alt=""></td> <td width="14"><img src="http://votenader.org/img/s.gif" width="14" height="1" border="0" alt=""></td> <td width="86"><img src="http://votenader.org/img/s.gif" width="86" height="1" border="0" alt=""></td> </tr> <tr valign="top"> <td align="right" colspan="4"><input type="text" class="nptText" id="email" name="email" size="22" value="enter email address" onkeypress="return jsAPI.validInputByRegExp(this,event,/[^\s<>\#\!\%\\\?\*]/);" onfocus="jsAPI.clearDefaultContent(this,event);" onblur="jsAPI.restoreDefaultContent(this,event);" onchange="this.form.action = 'http://' + this.form.elements.domain.value.toString() + '/' + 'mailman' + '/' + this.form.elements.mode.value.toString() + '/' + this.form.elements.list.value.toString() + '/'+ this.value.toString();" /></td> </tr> <tr valign="top"> <td height="22" align="right" colspan="2"><input type="text" class="nptText" id="subscribeZipCodeLeft" name="subscribeZipCodeLeft" size="5" value="zip" onkeypress="return jsAPI.validInputByRegExp(this,event,/[0-9\-]/);" onfocus="jsAPI.clearDefaultContent(this,event);" onblur="jsAPI.restoreDefaultContent(this,event);"></td> <td height="22" align="right" colspan="2"><input type="image" src="http://votenader.org/img/btn/btn_subscribe_green.gif" class="btn" width="98" height="18" border="0" alt="subscribe" name="btnSubscribeLeft" id="btnSubscribeLeft" /></td> </tr> <tr valign="top"> <td height="22" align="right" colspan="4" class="mainContentText"><a href="http://votenader.org/unsubscribe/index.php">Unsubscribe</a> | <strong><a href="http://votenader.org/contact/spam.php">Spam Notice</a></strong></td> </tr> </tbody> </table>  </div> </td> <td width="1" height="100%" rowspan="2" class="rightRuleBlue"><img class="rightRuleBlue" src="http://votenader.org/img/s.gif" width="1" height="1" border="0" alt="" align="bottom"></td> </tr> <tr> <td class="bottomRule" width="100%" height="1" colspan="2"><img src="http://votenader.org/img/s.gif" width="164" height="1" border="0" alt=""></td> </tr> </tbody> </table> </form> <script language="JavaScript1.2" type="text/javascript"> // if(typeof setCaption != "undefined") { evStSubscribeLeft = escape(((document.layers) ? "setTimeout('" : "") + "setCaption(\"capTitleSubscribeLeft\",\"mainContentSubscribeLeft\",\"" + ((typeof captionStrSubscribeLeft == "string") ? captionStrSubscribeLeft : "") + "\",\"" + ((typeof contentStrSubscribeLeft == "string") ? contentStrSubscribeLeft : "") + "\");" + ((document.layers) ? "',888);" : "")); eval(unescape(evStSubscribeLeft)); } // </script> <div class="modShimH5"> </div> <script language="JavaScript1.2" type="text/javascript"> // // dynamic mainContentContribute content variable (USE NOT RECOMMENDED FOR COMPATIBILITY w/Netscape 4.xx) captionStrContributeLeft = false; contentStrContributeLeft = false; // </script> <form name="contributeHome" id="contributeHome" action=""> <table border="0" cellpadding="0" cellspacing="0" width="100%" name="boxBGContributeLeft" id="boxBGContributeLeft"> <thead> <tr valign="top" onclick="document.location.href = '../contribute/index.php';"> <td valign="top" width="100%" height="17"><p name="capTitleContributeLeft" id="capTitleContributeLeft" class="capSmTitleText"><a class="capSmTitleText" href="http://votenader.org/contribute/index.php">Contribute</a></p></td> <td class="capAngle" width="16" height="17"><img src="http://votenader.org/img/mod/hdr_angle_16x17_rt.gif" width="16" height="17" border="0" alt="" name="capAngleImg" id="capAngleImg"></td> <td width="1" height="1" valign="bottom" class="rightRuleWhite"><img class="rightRuleBlue" src="http://votenader.org/img/s.gif" width="1" height="1" border="0" alt="" align="bottom"></td> </tr> </thead> <tbody> <tr valign="top"> <td width="100%" colspan="2" bgcolor="#ffffff" width="100%"> <div id="mainContentContributeLeft" name="mainContentContributeLeft" class="mainContentText">  <table border="0" cellpadding="0" cellspacing="0" width="148" class="mainContentText" style="border: 0px dotted #990000;"> <thead> <tr valign="top"> <td width="40"><img src="http://votenader.org/img/s.gif" width="40" height="1" border="0" alt=""></td> <td width="8"><img src="http://votenader.org/img/s.gif" width="8" height="1" border="0" alt=""></td> <td width="14"><img src="http://votenader.org/img/s.gif" width="14" height="1" border="0" alt=""></td> <td width="86"><img src="http://votenader.org/img/s.gif" width="86" height="1" border="0" alt=""></td> </tr> </thead> <tbody class="mainContentText"> <tr valign="top"> <td align="left" colspan="4"> <span class="mainContentTextBlue"><strong>Thank You, We Appreciate your Support!</strong></span> <p> Help get Ralph Nader on the Ballot in all 50 states, see the <a href="http://votenader.org/ballot_access/index.php">Ballot Access section</a> for more information. </p> </td> </tr> <tr valign="top"> <td align="right" colspan="4"> <a href="http://votenader.org/contribute/index.php"><img src="http://votenader.org/img/btn/btn_contribute_green.gif" class="btn" width="98" height="18" border="0" alt="contribute" name="btnContribute" id="btnContribute" onmouseover="jsAPI.hoverOver(jsAPI.getObjRef('btnContribute'),event);" onmouseout="jsAPI.hoverClear(jsAPI.getObjRef('btnContribute'),event);" onmousedown="jsAPI.activeButton(jsAPI.getObjRef('btnContribute'),event);" onblur="jsAPI.hoverClear(jsAPI.getObjRef('btnContribute'),event);"></a> </td> </tr> </tbody> </table>  </div> </td> <td width="1" height="100%" rowspan="2" class="rightRuleBlue"><img class="rightRuleBlue" src="http://votenader.org/img/s.gif" width="1" height="1" border="0" alt="" align="bottom"></td> </tr> <tr> <td class="bottomRule" width="100%" height="1" colspan="2"><img src="http://votenader.org/img/s.gif" width="164" height="1" border="0" alt=""></td> </tr> </tbody> </table> </form> <script language="JavaScript1.2" type="text/javascript"> // if(typeof setCaption != "undefined") { evStContributeLeft = escape(((document.layers) ? "setTimeout('" : "") + "setCaption(\"capTitleContributeLeft\",\"mainContentContributeLeft\",\"" + ((typeof captionStrContributeLeft == "string") ? captionStrContributeLeft : "") + "\",\"" + ((typeof contentStrContributeLeft == "string") ? contentStrContributeLeft : "") + "\");" + ((document.layers) ? "',888);" : "")); eval(unescape(evStContributeLeft)); } // </script> <div class="modShimH5"> </div> <script language="JavaScript1.2" type="text/javascript"> // // dynamic mainContentSubscribe content variable (USE NOT RECOMMENDED FOR COMPATIBILITY w/Netscape 4.xx) captionStrIssues = false; contentStrIssues = false; // </script> <table border="0" cellpadding="0" cellspacing="0" width="100%" name="boxBGIssues" id="boxBGIssues"> <thead> <tr valign="top" onclick="document.location.href = '../issues/index.php';"> <td valign="top" width="100%" height="17"><p name="capTitleIssues" id="capTitleIssues" class="capSmTitleText"><a class="capSmTitleText" href="http://votenader.org/issues/index.php">What Are The Issues?</a></p></td> <td class="capAngle" width="16" height="17"><img src="http://votenader.org/img/mod/hdr_angle_16x17_rt.gif" width="16" height="17" border="0" alt="" name="capAngleImg" id="capAngleImg"></td> <td width="1" height="1" valign="bottom" class="rightRuleWhite"><img class="rightRuleBlue" src="http://votenader.org/img/s.gif" width="1" height="1" border="0" alt="" align="bottom"></td> </tr> </thead> <tbody> <tr valign="top"> <td width="100%" colspan="2" bgcolor="#ffffff" width="100%"> <div id="mainContentIssues" name="mainContentIssues" class="mainContentText">  <table border="0" cellpadding="0" cellspacing="0" width="100%" class="mainContentText"> <thead> <tr valign="top"> <td width="44"><img src="http://votenader.org/img/s.gif" width="44" height="1" border="0" alt=""></td> <td width="4"><img src="http://votenader.org/img/s.gif" width="4" height="1" border="0" alt=""></td> <td width="15"><img src="http://votenader.org/img/s.gif" width="15" height="1" border="0" alt=""></td> <td width="86"><img src="http://votenader.org/img/s.gif" width="86" height="1" border="0" alt=""></td> </tr> </thead> <tbody class="mainContentList"> <tr valign="top"> <td colspan="4"><a href="http://votenader.org/issues/healthcare.php">Healthcare</a></td> </tr> <tr valign="top"> <td colspan="4"><a href="http://votenader.org/issues/living_wage_jobs.php">Living Wage/Jobs</a></td> </tr> <tr valign="top"> <td colspan="4"><a href="http://votenader.org/issues/corp_responsibility.php">Corporate Responsibility</a></td> </tr> <tr valign="top"> <td colspan="4"><a href="http://votenader.org/issues/the_environment.php">The Environment</a></td> </tr> <tr valign="top"> <td colspan="4"><a href="http://votenader.org/issues/clean_government.php">Clean Government</a></td> </tr> </tbody> </table>  </div> </td> <td width="1" height="100%" rowspan="2" class="rightRuleBlue"><img class="rightRuleBlue" src="http://votenader.org/img/s.gif" width="1" height="1" border="0" alt="" align="bottom"></td> </tr> <tr> <td class="bottomRule" width="100%" height="1" colspan="2"><img src="http://votenader.org/img/s.gif" width="164" height="1" border="0" alt=""></td> </tr> </tbody> </table> <script language="JavaScript1.2" type="text/javascript"> // if(typeof setCaption != "undefined") { evStIssues = escape(((document.layers) ? "setTimeout('" : "") + "setCaption(\"capTitleIssues\",\"mainContentIssues\",\"" + ((typeof captionStrIssues == "string") ? captionStrIssues : "") + "\",\"" + ((typeof contentStrIssues == "string") ? contentStrIssues : "") + "\");" + ((document.layers) ? "',888);" : "")); eval(unescape(evStIssues)); } // </script> <div class="modShimH5"> </div> <script language="JavaScript1.2" type="text/javascript"> // // dynamic mainContentSubscribe content variable (USE NOT RECOMMENDED FOR COMPATIBILITY w/Netscape 4.xx) captionStrGet = false; contentStrGet = false; // </script> <table border="0" cellpadding="0" cellspacing="0" width="100%" name="boxBGGet" id="boxBGGet"> <thead> <tr valign="top" onclick="document.location.href = '../get_involved/index.php';"> <td valign="top" width="100%" height="17"><p name="capTitleGet" id="capTitleGet" class="capSmTitleText"><a class="capSmTitleText" href="http://votenader.org/get_involved/index.php">Get Involved</a></p></td> <td class="capAngle" width="16" height="17"><img src="http://votenader.org/img/mod/hdr_angle_16x17_rt.gif" width="16" height="17" border="0" alt="" name="capAngleImg" id="capAngleImg"></td> <td width="1" height="1" valign="bottom" class="rightRuleWhite"><img class="rightRuleBlue" src="http://votenader.org/img/s.gif" width="1" height="1" border="0" alt="" align="bottom"></td> </tr> </thead> <tbody> <tr valign="top"> <td width="100%" colspan="2" bgcolor="#ffffff" width="100%"> <div id="mainContentGet" name="mainContentGet" class="mainContentText">  <table border="0" cellpadding="0" cellspacing="0" width="100%" class="mainContentText"> <thead> <tr valign="top"> <td width="44"><img src="http://votenader.org/img/s.gif" width="44" height="1" border="0" alt=""></td> <td width="4"><img src="http://votenader.org/img/s.gif" width="4" height="1" border="0" alt=""></td> <td width="15"><img src="http://votenader.org/img/s.gif" width="15" height="1" border="0" alt=""></td> <td width="86"><img src="http://votenader.org/img/s.gif" width="86" height="1" border="0" alt=""></td> </tr> </thead> <tbody class="mainContentList"> <tr valign="top"> <td colspan="4"><a href="http://votenader.org/get_involved/index.php">Volunteer</a></td> </tr>  <tr valign="top"> <td colspan="4"><a href="http://votenader.org/ballot_access/index.php">Ballot Access</a></td> </tr> <tr valign="top"> <td colspan="4"><a href="http://www.rockthevote.com/rtv_register.php">Register to Vote</a></td> </tr> <tr valign="top"> <td colspan="4"><a href="http://votenader.org/contribute/index.php">Contribute</a></td> </tr> </tbody> </table>  </div> </td> <td width="1" height="100%" rowspan="2" class="rightRuleBlue"><img class="rightRuleBlue" src="http://votenader.org/img/s.gif" width="1" height="1" border="0" alt="" align="bottom"></td> </tr> <tr> <td class="bottomRule" width="100%" height="1" colspan="2"><img src="http://votenader.org/img/s.gif" width="164" height="1" border="0" alt=""></td> </tr> </tbody> </table> <script language="JavaScript1.2" type="text/javascript"> // if(typeof setCaption != "undefined") { evStGet = escape(((document.layers) ? "setTimeout('" : "") + "setCaption(\"capTitleGet\",\"mainContentGet\",\"" + ((typeof captionStrGet == "string") ? captionStrGet : "") + "\",\"" + ((typeof contentStrGet == "string") ? contentStrGet : "") + "\");" + ((document.layers) ? "',888);" : "")); eval(unescape(evStGet)); } // </script> <div class="modShimH5"> </div> <div class="modShimH5"> </div> <script language="JavaScript1.2" type="text/javascript"> // // dynamic mainContentSubscribe content variable (USE NOT RECOMMENDED FOR COMPATIBILITY w/Netscape 4.xx) captionStrContact = false; contentStrContact = false; // </script> <table border="0" cellpadding="0" cellspacing="0" width="100%" name="boxBGContact" id="boxBGContact"> <thead> <tr valign="top" onclick="document.location.href = '../contact/index.php';"> <td valign="top" width="100%" height="17"><p name="capTitleContact" id="capTitleContact" class="capSmTitleText"><a class="capSmTitleText" href="http://votenader.org/contact/index.php">Contact Us</a></p></td> <td class="capAngle" width="16" height="17"><img src="http://votenader.org/img/mod/hdr_angle_16x17_rt.gif" width="16" height="17" border="0" alt="" name="capAngleImg" id="capAngleImg"></td> <td width="1" height="1" valign="bottom" class="rightRuleWhite"><img class="rightRuleBlue" src="http://votenader.org/img/s.gif" width="1" height="1" border="0" alt="" align="bottom"></td> </tr> </thead> <tbody> <tr valign="top"> <td width="100%" colspan="2" bgcolor="#ffffff" width="100%"> <div id="mainContentContact" name="mainContentContact" class="mainContentText">  <table border="0" cellpadding="0" cellspacing="0" width="100%" class="mainContentText"> <thead> <tr valign="top"> <td width="44"><img src="http://votenader.org/img/s.gif" width="44" height="1" border="0" alt=""></td> <td width="4"><img src="http://votenader.org/img/s.gif" width="4" height="1" border="0" alt=""></td> <td width="15"><img src="http://votenader.org/img/s.gif" width="15" height="1" border="0" alt=""></td> <td width="86"><img src="http://votenader.org/img/s.gif" width="86" height="1" border="0" alt=""></td> </tr> </thead> <tbody class="mainContentList"> <tr valign="top"> <td colspan="4" class="mainContentText">For more information, contact us. <a href="http://votenader.org/contact/index.php">Contact Us >></a> | <strong><a href="http://votenader.org/contact/spam.php">Spam Notice</a></strong></td> </tr> </tbody> </table>  </div> </td> <td width="1" height="100%" rowspan="2" class="rightRuleBlue"><img class="rightRuleBlue" src="http://votenader.org/img/s.gif" width="1" height="1" border="0" alt="" align="bottom"></td> </tr> <tr> <td class="bottomRule" width="100%" height="1" colspan="2"><img src="http://votenader.org/img/s.gif" width="164" height="1" border="0" alt=""></td> </tr> </tbody> </table> <script language="JavaScript1.2" type="text/javascript"> // if(typeof setCaption != "undefined") { evStContact = escape(((document.layers) ? "setTimeout('" : "") + "setCaption(\"capTitleContact\",\"mainContentContact\",\"" + ((typeof captionStrContact == "string") ? captionStrContact : "") + "\",\"" + ((typeof contentStrContact == "string") ? contentStrContact : "") + "\");" + ((document.layers) ? "',888);" : "")); eval(unescape(evStContact)); } // </script> <br> <br>  </div> </td> <td valign="top" width="100%" height="90%" colspan="3"> <div id="mainContentHome" name="mainContentHome" class="bodyCopy">  <h2><strong>Spam from VoteNader.org?</strong></h2> <h3>(Or naderexplore04.org)</h3> <p>You may have received spam email recently that appears to come from our campaign, or be about our campaign — perhaps the "From" and or "Reply-to" addresses look like they are coming from VoteNader.org. Or perhaps you have received a message that appears to come from an individual (if the address is real, the real owner probably did not send this email either) with suppressed recipients. Or maybe you received an email that appeared to come from yourself promoting our site.</p> <p> <strong>These messages are NOT from Nader for President 2004, and these email tactics are NOT condoned by our campaign in any way.</strong></p> <p> <strong>UPDATE:</strong> Some of the latest forged emails have been made to appear to be coming from naderexplore04.org. Again, we are not responsible for this unfortunate abuse of email, and there is little in the technical sense that we can do to prevent this as it has nothing to do with our actual infrastructure. We are collecting information. </p> <p> <strong>NOTE:</strong> The emails with malicious code (viruses, worms, etc.) often have attachments. <strong><em>Our campaign will NEVER send attachments</em></strong> in our announcement emails to you. Please be sure that you have anti-virus software and have the latest updates available for your anti-virus software. </p> <p> Our hosting service has alerted us to say that Nader for President 2004 appears to be the target of what is called a "<a href="http://catb.org/~esr/jargon/html/J/joe-job.html">Joe Job</a>." Such an event is where a spammer forges email to make it appear to have come from some other domain (such as ours — or yourself). This is hard to prevent on our end and part of the insecure nature of the email protocol in general. </p><p>Members of our actual email list must request to receive email from us (either through Ralph's signup sheets or subscribing during our exploratory phase, or now on our campaign site). When one signs up for email they must reply to a confirmation message before they receive our list announcements. </p> <p>Our public announcement emails come from "campaign@votenader.org," contain a "Paid for by Nader for President 2004" statement at the bottom, and have "updates@lists.votenader.org" in the "To:" header. Unfortunately, some of these indicators can be forged as well. </p> <p>Most of the Spam that we have received complaints about appear to be forged from email addresses not associated with votenader.org (often forged to appear to be coming from government email addresses), and have our website code embedded in the body of the email with hidden tags that contain random words that work to subvert anti-spam software.</p><p>If you are on our lists, you can ALWAYS unsubscribe at ANY time by following the instructions included at the end of our announcements. You can also use our <a href="http://www.votenader.org/unsubscribe/index.php">unsubscribe page</a> using the email address you signed up with.</p><p>If you are receiving this SPAM, we extend our apologies.</p> <p>We will pursue the spammers to the full extent of the law.</p><p>For more information, please review these resources:</p><ul><li /> <a href="http://www.aota.net/Email_Spam_Prevention_and_Mgmt/emailsource.php4"> How Do I Determine the Source of an Email?</a><li /> <a href="http://www.aota.net/Email_Spam_Prevention_and_Mgmt/spamfrom.php4"> Why Does This Spam Look Like I Sent It?</a><li /> <a href="http://www.sitepoint.com/article/sabotage-coping-joe-job/2">Coping with a Joe Job</a> </ul> <p> Please contact <a href="mailto:abuse@votenader.org">abuse@votenader.org</a> with any questions. We have received many samples of the spam and are working to identify the source, if possible. </p>   <br> <br> <table border="0" borderStyle="solid" borderColor="#000000" cellpadding="0" cellspacing="0" width="100%"> <thead> <tr valign="top"> <td width="100%" align="center" class="bottomNav"><div id="boxBGBN" name="boxBGBN"> <div id="mainContentBN" name="mainContentBN"> <strong><a href="http://votenader.org/contact/spam.php">Spam Notice</a></strong><span class="bnPipe">|</span> <a href="http://votenader.org/privacy_policy/index.php">Privacy Policy</a><span class="bnPipe">|</span><a href="http://votenader.org/legal/index.php"> Legal Info</a><span class="bnPipe">|</span><a href="http://votenader.org/why_ralph/index.php">Why Ralph?</a><span class="bnPipe">|</span> <a href="http://votenader.org/get_involved/index.php">Get Involved</a><span class="bnPipe">|</span><a href="http://votenader.org/ballot_access/index.php">Ballot Access</a> <br /> <a href="http://votenader.org/issues/index.php">Issues</a><span class="bnPipe">|</span><a href="http://votenader.org/calendar/index.php">Calendar</a><span class="bnPipe">|</span><a href="http://votenader.org/media_press/index.php">Media & Press</a><span class="bnPipe">|</span><a href="http://votenader.org/contact/index.php">Contact</a><span class="bnPipe">|</span><a href="http://votenader.org/subscribe/index.php">Subscribe</a><span class="bnPipe">|</span><a href="http://votenader.org/contribute/index.php">Contribute</a> </div> </div> </td> </tr> </tbody> </table>   <br> <br> <table border="0" borderStyle="solid" borderColor="#000000" cellpadding="0" cellspacing="0" width="100%"> <thead> <tr valign="top"> <td width="100%"><div id="boxBGPaid" name="boxBGPaid"> <div id="mainContentPaid"> Paid for by Nader for President 2004 <br /> (202) 265-4000 - P.O. Box 18002, Washington, DC 20036 - <a href="mailto:info@votenader.org">info@votenader.org</a> </div> </div> </td> </tr> </tbody> </table>  </div> </td> <td class="rightRuleGray" width="1" height="100%" rowspan="3"><img src="http://votenader.org/img/s.gif" width="1" height="1" border="0" alt=""></td> </tr> </tbody> </table> <script language="JavaScript1.2" type="text/javascript"> </script> </body> </html>  ignored, how long will humanity remain slave. last updated: 21st of May 2003 Table of contents Some of you may not know :) Assalam u?Alekum all ;) I am sure most of average Muslims are not aware of the fact that today in Mecca and Medina there are Jewish Muslim scholars in our leading mosques and universities. How did I find out, well we will insha?Allah answer this in future. But in my case I knew about presence of bad guys in Vatican City long before I found out that these guys were present in Mecca and Medina as well. Look at it this way there rarely are leading Muslims who are either not with bad guys are else not working for any other groups or so. Which is a bit tragic but true. That is why I say good guys should define their limits, I mean now the whole world is a "play ground? so we rather define out limits and keep our issues outside the houses build to worship God, if you are going to win then develop the attitude of winners not mice, because in future I am going to make this part of story public too. I need to know more about this part of story, so can good guys let me know the exact situation in a few months time, with names and proof thanks, no not now in a few m Tag: Do I use a Join statement? Tag: 290701
  - 8
    - ws-ftp WS-FTP: great! the noise: terrible*!* How do I quit the noise? Tag: Do I use a Join statement? Tag: 290698
  - 9
    - problem with IIS Yesterday my ASP works fine in IIS (Xp Pro) This morning i had a power power breakdown. After restart the same ASPages works fine except non of the images want load in MSIE 6.0. After i copied the path to the pictures in the adressebar the picture shows up in MSIE. But when i run the ASP in the Localhost text, links, everything shows up. In the status the message "still X object to load" and the progressbar stays. Nothing happens even if i wait 10 minutes. At the same moment InetInfo.exe is running as process and takes 99% of the activity. The same pages run ok on the internet server or on another machine. I'm thinking that one of the IIS or MSIE setting in the registry is wrong due to the power breakdown. I removed and reinstall IIS and MSIE without succes. Any idea how to fix this problem? Maarten. Tag: Do I use a Join statement? Tag: 290693
  - 10
    - Losing Session Variables Hi All, I'm rather new to ASP but I'm running into a problem that has me stumped. I am developing some websites on my home computer (WinXP Pro, IIS 5.1). Basically, I have an ASP login page that once a user is authenticated a session variable is set to show they have logged in successfully. For example: Session("loggedin")= "True" They are then redirected to the "member" page, which checks the session variable and displays the member page if it is true, or jumps them back to the Login page if False. For example: If Session("loggedin") <> "True" Then Response.Redirect ("login.asp") Response.End End If The problem I'm running in to is that the session variable does not seem to be saving any data so even registered users (i.e., me at the moment) get bounced back to the login page. (I've tried switching to cookies, but have the same problem - not surprising I guess, since sessions use cookies). This was all working a few months back, but has now stopped. I was working on a few different projects for the past couple of months and have just returned to these older projects. Any ideas as to what might be the cause of this behavior and how it might be corrected? Could a Windows or IE update be responsible? Thanks for any help. Cheers, Jimbo Tag: Do I use a Join statement? Tag: 290679
  - 11
    - ***Send mail to hotmail.com When a test user input information on a webpage and click on Send button, an ASP page will use CreateObject("CDONTS.NewMail") to send the information to my hotmail.com mailbox. When I tested the ASP page, my hotmail.com mailbox did not receive the message. When I changed the code to send the mail to my other email accounts, I got the message. Does anybody know why? Thanks. Tag: Do I use a Join statement? Tag: 290676
  - 12
    - Cookies on MySite.com VS www.MySite.com ' I have some pretty standard "load/save a cookie" ASP/VBscript code. ' Would any of these things cause a problem: ' Works.... if uploaded to MySite.com ' Doesn't work.... if uploaded to www.MySite.com ' ' Or the fact that my cookie-name is called "Test_Cookie_Data" instead of "DATA"... ' ... or the fact that I'm using ASP... and my hosting company supports both ASP and ASP.net? ' ... or the fact that I'm passing the value via a URL variable that is similar to my cookie name? ' www.MySite.com?data=12345 ' ' (My code *ALWAYS* works at MySite.com (but only "sometimes" works at www.MySite.com) Dim cookieName, cookieValue, cookieReturned cookieName = "Test_Cookie_Data" 'cookieValue = TIME cookieValue = request.queryString("data") response.cookies(cookieName) = cookieValue ' Save this as a cookie for next time response.cookies(cookieName).Expires = DateAdd("d", 90, Date) cookieReturned = request.cookies(cookieName) response.write "(" & cookieName & ") (" & cookieValue & ") (" & cookieReturned & ") <hr>" Tag: Do I use a Join statement? Tag: 290674
  - 13
    - Looking for UPS Com Object Testers I am about to release a beta version of a com object for retrieving UPS shipping rates directly from UPS.COM. I am looking for a few interested parties to try it out and give me feedback. Additional com objects will follow shortly to make using the UPS tools extremely easy for those programming in VB/ASP/ASP.NET or any language that lets you use com objects. Please reply via this thread or fix my return email address and drop me a line if interested! Tag: Do I use a Join statement? Tag: 290671
  - 14
    - SQL Stored Proc - ASP Page - Return Value I have a SQL Stored Procedure that is I am passing several parameters to and doing an insert into a table. The proc is doing a few other things and one of the process is to return a confirmation number back to the the ASP page that called the Stored Proc. How ever the DBA that created the stored proc for me does not want to use an OUTPUT Parameter, but rather, as you can see at the bottom of the proc, he is setting the return parameter like a result set. My problem is, I am not sure how to get that "result set" back can you help me. Attached is a copy of the head and tail part of the stored proc and the part of the ASP code where I call the procedure in my site. Everything within the procedure is working fine, I just need to know how to get what is being returned in the "confirmation" parameter. I am not sure if I pass it over as blank and it returns what I need or what? Hope this makes sense. Thanks in advance for all the help. STORED PROCEDURE: create proc p_eft_InsertPayment @AgentID int, @UserID int, @AccountNumber varchar(50), @Amount Float, @PaymentType varchar(25) = null, @CheckNbr int = null as set nocount on .... .... ... ... set nocount off commit tran select @ConfirmationNbr - ***** this is what I need ********* GO ASP CODE: cmdpay.ActiveConnection = connpay cmdpay.CommandText = "SYSTEM..p_eft_InsertPayment" cmdpay.CommandType = adCMDStoredProc cmdpay.Parameters.Append (cmdpay.CreateParameter("RetVal", adInteger, adParamReturnValue)) cmdpay.Parameters.Append (cmdpay.CreateParameter("@AgentID", adInteger, adParamInput,, Session("UserAgentID"))) cmdpay.Parameters.Append (cmdpay.CreateParameter("@UserID", adInteger, adParamInput,, Session("UserID"))) cmdpay.Parameters.Append (cmdpay.CreateParameter("@AccountNumber", adVarChar, adParamInput, 50, Session("UserPaymentAcctNo"))) cmdpay.Parameters.Append (cmdpay.CreateParameter("@Amount", adDouble, adParamInput, 10, Request.Form("txtPaymentAmount"))) cmdpay.Parameters.Append (cmdpay.CreateParameter("@PaymentType", adVarChar, adParamInput, 25, Request.Form("drpPaymentType"))) cmdpay.Parameters.Append (cmdpay.CreateParameter("@CheckNbr", adInteger, adParamInput,, Request.Form("txtCheckNumber"))) Tag: Do I use a Join statement? Tag: 290665
  - 15
    - ASP file Upload and hidden fields Good afternoon, I have an .htm page with "input type=file" box, as well as .asp page to which that file is posted. It works. Since the path for the file to be uploaded is constant, how can I use the current setup of .htm and .asp pages to upload a file from a client machine without a utility. I read on one of the forums that "hidden" field cannot be used for files. If there is no way to use my current structure, I am also looking into FSO object, using one .asp page to post to itself, specifically .getFile method to start. What are the next steps to take? The code for the single .asp page is below. File.move works also, not sure if I need it though. Thank You, Igor. <% Set fso = CreateObject("Scripting.FileSystemObject") Set file = fso.getfile("C:\_WebApps\igor\file_upload\scripts.txt") 'response.write file.name file.move("C:\_WebApps\igor\file_upload\test\") 'file.copy("C:\_WebApps\igor\file_upload\test") %> <html> <body> <form name="upload_form" method="post" enctype="multipart/form-data" action="upload_link_old.asp"> <input type="hidden" id="isdone" name="isdone" value></input>  <br> <input type=submit value="Upload File"> </form> </body> </html> <script type="javascript"> </script> Tag: Do I use a Join statement? Tag: 290659
  - 16
    - sessions, global.asa and performance Hi. I wonder if anyone could shed some light. I have a site, with a MSSQL DB, of about 1.5GB. Now, the DB connection string is in global.asa, and I'm moving this to a .asp file, hoping it would improve performance. Another thing I would like to try: On two of the pages, the DB is being queried for companies who have subscribed, and companies who haven't yet. The problem is, this list is long, and lot of info id being pulled, like the company name, id, and some other info. Can I save this list of info in a session? Is it safe todo so, and will it improve performance? Cause then, when a user moves around those two pages, he get's cached info. alternatively, what can I do / look at, to increase performance? When the site was designed, performance wasn't an issue, but now that the list of both the subscribed company list, _and_ the temp company list has grown to a very long list, the site is slow. -- 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: Do I use a Join statement? Tag: 290653
  - 17
    - subtraction questions I have a numeric field in my database. How do I subtract? frequencypercent is a decimal and in this case is .20 multiplierrate= 100 - rs_fees("classified_freq_percent") Tag: Do I use a Join statement? Tag: 290649
  - 18
    - subtraction questions I have a numeric field in my database. How do I subtract? frequencypercent is a decimal and in this case is .20 multiplierrate= 100 - rs_fees("classified_freq_percent") Tag: Do I use a Join statement? Tag: 290648
  - 19
    - If then statement not working I am trying to use the statement below but it is not picking up the first condition. When severity1 = S1 and severity = "" I get Severity = "" instead of severity=S1. I get the correct one if the severity is S2. Is the format correct. Thanks Ken if RSupdate("severity1")= "S1" and RSupdate("severity2")= "" then Severity = "S1" else if RSupdate("severity1")= "" and RSupdate("severity2")= "S2" then Severity = "S2" else severity="" end if Tag: Do I use a Join statement? Tag: 290646
  - 20
    - How to Pass Querystring to Value and into ASP page Hi, I am trying to pass some information to a value field then to an ASP page. My html page:- <% dim x_Day, x_Date, x_Time, x_Desc x_Day=Request.Querystring("c_Day") x_Date=Request.Querystring("c_Date") x_Time=Request.Querystring("c_Time") x_Desc=Request.Querystring("c_Description") %> <input type=hidden name="x_description" value=("x_Day, x_Date, x_Time, x_Desc")> My ASP page:- <%= Request("x_Description") %> It passes the whole exact content(word) in the value as, x_Day, x_Date, x_Time, x_Desc. Does anyone know how to resolve this? Thanks in advanced, Jessica Tag: Do I use a Join statement? Tag: 290638
  - 21
    - XMLHTTP.status and Oracle Portal? Until recently I was able to use XMLHTTP to check the existence of a document on our intranet. Now all the documents have been moved into Oracle Portal. Does anyone know how to check the presence of a document there? If I use XMLHTTP the status indicates 200 for everything because Portal always returns something. If the document desired is missing Portal returns a documents index by default. thanks LJB Tag: Do I use a Join statement? Tag: 290637
  - 22
    - Using Post but losing data due to spaces??? I am generating a list with checkboxes from a database: Response.Write (" <FORM METHOD='POST' ACTION='listpage.asp?Verified=True' NAME = 'Subscriptor' onsubmit=""return howManyChecked('Subscriptor','ITitle'',9,9,'Inservice');"">") <Input Type='CheckBox' Name='ITitle' Value=" & rsData("Name") & ">... <% 'Response.Write Request.Form("ITitle") %> I have some code that verifies if 5 titles are checked (howManyChecked), then I send this list of 5 titles to the next area. Problem is I am asking for the "Name" from the database, and the name contains spaces. When I go to generate the list on the next area I get only the first Word, if there is a space in the "Name" the collection takes this as the end of the Name data, and goes onto the next Name, taking only the first word again. I can get around the issue by changing it to the ID being transferred in the ITitle, and then calling database to collect the data (Name) again. This seems an unnecessary step. Any ideas how I can drop the problem of losing data after the spaces? D Tag: Do I use a Join statement? Tag: 290633
  - 23
    - ADODB.stream hangs with some cases of downloading zip files hello to all the experts, The following is a code taken from and ASP file, called downloadgivenfile.asp, that uses the adodb.stream class in order to download a file from a server. If one wants to download a file, then typing http://mywebsite/downloadgivenfile.asp?FileName=myfile.exe would prompt the user with a save open message and followed by a 'save' common dialoog box. Everything works fine with exe files and cab files, but when I try to download a zip file, something weird is happens. From all the zip files that I tried to download (i.e., .zip extension) there very few successes. In those failing cases, I was prompted with 'save or open' dialog box, and when I press save it hangs forever without any progress in terms of downloading or reporting of downloading. If one waits long enough, the an error message will appear, saying that the server had to disconnect the connection -- i guess the server noticed thah nothing happens so it disconnects the connection. In one case where the downmload was successful with zip file, I renamed the file adding it another character (e.g., changed the file name from myfile.zip to myfile.zip1) and the success turned into failure. I did some research on the internet for quite some time bu I have not founf any answer to that, maybe because I'm not so familiar with the adodb.stream. Actually the code you are about to see now is an improvement of some code that another user on the internet published to the extent of claiming that it can be used to download any file. Here Any assitance in figuring out what is going on here an dhow to tackle the problem will be greatly appreciated. is the code the populates the ENTIRE asp file: Thank you in advance, Avi <html> <head> <meta name="GENERATOR" content="Microsoft FrontPage 5.0"> <meta name="ProgId" content="FrontPage.Editor.Document"> <title>New Page 1</title> </head> <body bgcolor="#33ccff"> <% call DownLoadTheFileInTheQuesryString function DownLoadTheFileInTheQuesryString() Dim objStream RelativeFileNmaePath=Request("FileName") ThePath="D:\my new web site\" PathPlusFileName=ThePath & RelativeFileNmaePath FileName=ReturnFileNameOnlyGivenFilePlusPath(PathPlusFileName) IsThereSuchFile=DoesFileExist("D:\my new web site\Company_Packages\" & FileName,objFile) if IsThereSuchFile=false then response.Write "<p>File not found Error</p>" else Response.Expires = 0 Response.Buffer = true response.clear Response.AddHeader "Content-Disposition", "attachment; filename=" & FileName lSize =objFile.Size Response.AddHeader "Content-Length", lSize Response.Charset = "UTF-8" ThecontentType=ReturnFilterPropertyForCommonDialogControl(FileName) Response.ContentType =ThecontentType' "application/zip" '= ThecontentType'"application/octet-stream" Response.CacheControl = "public" Set objStream = Server.CreateObject("ADODB.Stream") objStream.Open objStream.Type = 1 objStream.LoadFromFile PathPlusFileName CHUNK=2048 NumberofBlocks=(lSize -(lsize mod chunk))/chunk For lBlocks = 1 To NumberofBlocks If Response.IsClientConnected = False Then Exit For Response.BinaryWrite objStream.Read(CHUNK) Response.Flush Next lSize = lSize Mod CHUNK If lSize = 0 And Response.IsClientConnected = True Then Response.BinaryWrite objStream.Read(lSize) Response.Flush end if objStream.Close set objStream = Nothing Set objFile = Nothing 'response.end end if end function function ReturnFilterPropertyForCommonDialogControl(FileExtension) select case ucase(FileExtension) case "EXE" ReturnedValue="Application/exe" case "ZIP" ReturnedValue="Application/zip" end select ReturnFilterPropertyForCommonDialogControl=ReturnedValue 'response.write "<p>" & ReturnedValue & "</p>" end function function ReturnFileNameOnlyGivenFilePlusPath(PathPlusFileName) ISItFirstLoop=true PreviosPosition=0 do while PositionOfForwardSlash<>0 or ISItFirstLoop=true ISItFirstLoop=false PreviosPosition=PositionOfForwardSlash PositionOfForwardSlash= InStr(PositionOfForwardSlash+1, PathPlusFileName, "\") loop ReturnFileNameOnlyGivenFilePlusPath=mid(PathPlusFileName,PreviosPosition+1) end function Function DoesFileExist(TheFilePlusPath,FileObject) Set fso = CreateObject("Scripting.FileSystemObject") 'msgbox fso.getfile(TheFilePlusPath).size DoesFileExist=fso.FileExists(TheFilePlusPath) if DoesFileExist=true then set FileObject=fso.GetFile(TheFilePlusPath) end function %> </body> </html> Tag: Do I use a Join statement? Tag: 290629
  - 24
    - processing a form to email Hello I am trying to create a basic feedback form that when submitted, posts to my email address. So far so good as I have taken a cdonts script and made some modifications to it, but I need a little help. In my form I want my visitors to select items of interest, selecting from a range of products with checkboxes alongside them, these appear in the form page www.tripakltd.com/contactme.asp . The data to the right side of the checkbox is taken from my database, and the checkbox is dynamic. When submitted you are taken to a page www.tripakltd.com/sendemail.asp My question is very simple. When processing, the form, I want, just like all the other fields on the form get processed and output html styled to my email address, so to, the checkbox fields. I.E if there is a tick next to the "Barrier Tapes" checkbox on my form, I receive in reply "Person X is interested in Barrier Tapes etc." I am just not sure how to code it? Can anyone help me on this? Here are the two pages, in code format if anyone wants to see it www.tripakltd.com/contactme.txt www.tripakltd.com/sendemail.txt Thanks so much Raphael Tag: Do I use a Join statement? Tag: 290625
  - 25
    - Services running I'm not sure if I have selected the correct newsgroups here but is there a simple was to test which servers are running? I have apache and IIS installed and if I run http://localhost I am not sure which it is using or if they can both run simultaneously. Any ideas? Tag: Do I use a Join statement? Tag: 290624

I am not sure how to use join all that well. Here is my set up. I
have two tables. Tables are Orders and VendorDetails. I would like
to pull the Subtotals of all Orders that I have received an invoice
from the vendor on.

So, basically, if OrderID exists in the table VendorDetails, then give
me the Subtotal for the OrderID in the Orders table. OrderID is set
up with a relationship to both tables. Thanks.

-Darren

Top

Re: Do I use a Join statement? by Bob

Bob
Mon Apr 12 09:18:28 CDT 2004

Enjoy Life wrote:
> I am not sure how to use join all that well. Here is my set up. I
> have two tables. Tables are Orders and VendorDetails. I would like
> to pull the Subtotals of all Orders that I have received an invoice
> from the vendor on.
>
> So, basically, if OrderID exists in the table VendorDetails, then give
> me the Subtotal for the OrderID in the Orders table. OrderID is set
> up with a relationship to both tables. Thanks.
>
> -Darren

You should always tell us the type and version of database you are using. It
is always relevant.

It is always best when requesting help with a query to provide a few sample
rows of data in tabular format (just show us the minimum number of columns
needed to illustrate the problem). This will allow us to see the field
names. Next you should show us the results you wish to obtain from that
sample data. The keyword is "show" - do not describe the results: show us
the results you would want the query to return from the provided sample
data.

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Top

Re: Do I use a Join statement? by Enjoy

Enjoy
Mon Apr 12 09:35:45 CDT 2004

Thank you for the quick response Bob. Next time I will show you some
more details, that was my fault. Anyway, I figured out a solution.

-Darren

On Mon, 12 Apr 2004 10:18:28 -0400, "Bob Barrows [MVP]"
<reb01501@NOyahoo.SPAMcom> wrote:

>Enjoy Life wrote:
>> I am not sure how to use join all that well. Here is my set up. I
>> have two tables. Tables are Orders and VendorDetails. I would like
>> to pull the Subtotals of all Orders that I have received an invoice
>> from the vendor on.
>>
>> So, basically, if OrderID exists in the table VendorDetails, then give
>> me the Subtotal for the OrderID in the Orders table. OrderID is set
>> up with a relationship to both tables. Thanks.
>>
>> -Darren
>
>You should always tell us the type and version of database you are using. It
>is always relevant.
>
>It is always best when requesting help with a query to provide a few sample
>rows of data in tabular format (just show us the minimum number of columns
>needed to illustrate the problem). This will allow us to see the field
>names. Next you should show us the results you wish to obtain from that
>sample data. The keyword is "show" - do not describe the results: show us
>the results you would want the query to return from the provided sample
>data.
>
>Bob Barrows

Top