To send the resultset to printer

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
    - Scripting problem Can someone help me understand why this script sets only some of the div.InnerText proerties of my page. If I set the language to VBScript and remove the semicolons it works. I'm just getting started with javascript so I appologize it this so simple. <script language="javascript"> oFirstName.InnerText = <%=chr(34)&sFirstName&chr(34)%>; oLastName.InnerText = <%=chr(34)&sLastName&chr(34)%>; oMI.InnerText = <%=chr(34)&sMiddleName&chr(34)%>; oEmpIDFld.InnerText = <%=chr(34)&sEmployeeID&chr(34)%>; oTitleField.InnerText = <%=chr(34)&sTitle&chr(34)%>; oDepartField.InnerText = <%=chr(34)&sDepartment&chr(34)%>; oDivisionField.innerText = <%=chr(34)&sDivision&chr(34)%>; oCompanyField.innerText = <%=chr(34)&sCompany&chr(34)%>; oTelephone.innerText = <%=chr(34)&sTelephone&chr(34)%>; oFaxPhone.innerText = <%=chr(34)&sFaxPhone&chr(34)%>; oMobilePhone.innerText = <%=chr(34)&sMobile&chr(34)%>; oStreet.innerText = <%=chr(34)&sStreetAddr&chr(34)%>; oCityField.innerText = <%=chr(34)&sCityName&chr(34)%>; oState.innerText = <%=chr(34)&sState&chr(34)%>; oZipCodeFld.innerText = <%=chr(34)&sZipCode&chr(34)%>; oLocationFld.innerText = <%=chr(34)&sLocationCode&chr(34)%>; oEMailField.innerText = <%=chr(34)&sEMailAddr&chr(34)%>; oWebLinkField.innerText = <%=chr(34)&sWebLink&chr(34)%>; oDisplayName.innerText = <%=chr(34)&sDisplayName&chr(34)%>; oAssistant.innerText = <%=chr(34)&sAssistant&chr(34)%>; oTeamURL.innerText = <%=chr(34)&sTeamWeb&chr(34)%>; oThumnailPhoto.src = <%=chr(34)&bBinObject&chr(34)%>; </script> Tag: To send the resultset to printer Tag: 309403
  - 2
    - Virtual Directory Setting Webhost4life has their on control panel, which includes a button labeled: "Set IIS Application". It takes the user to a page which has a form that looks like this: http://yourdomain.com/______________ IIS App ON/OFF You fill in the rest of the URL and then select IIS App ON or IIS App OFF. QUESTION: What is this supposed to accomplish? There is no browse feature, so I am not sure if this is supposed to create a FOLDER or enable a FOLDER for asp, or what? Help will be greatly appreciated. Tag: To send the resultset to printer Tag: 309397
  - 3
    - ado and xml? Hi, I have some questions about replace with mdb file with xml file: Can I use ado and xml to store info instead of Ms access database, what will be the diff? can ado and xml support mult-user Concurrent access? Thansk... Tag: To send the resultset to printer Tag: 309382
  - 4
    - download file protect Hi, how to do this: the page is to be able to allow a user to enter a password so as to download documents. It does not meant for any users to download. It is for some specific users. What I want is to send them a password through email, but I want to know who's has downloaded. Please adivce. thanks... Tag: To send the resultset to printer Tag: 309381
  - 5
    - How to instantiate an Adobe Distiller object from ASP ? How can I instantiate an Adobe Distiller object from ASP ? Thank you. Tag: To send the resultset to printer Tag: 309365
  - 6
    - Cannot get to format the date field correctly yet Hi, I cannot get the date format correctly in dynamic sql statement, after trying various ways of handling it. I need some help with the date format in the following dynamic sql statement. Any help is appreciated in advance. While running the asp page, I still get an error as Error Type: Microsoft VBScript runtime (0x800A000D) Type mismatch: 'Format' DYNAMIC SQL STATEMENT: sql = " INSERT INTO tblExpense (ENO, EntryDate, ContractedServiceExpense, " sql = sql & "TravelExpense, PersonnelExpense)" sql = sql & " VALUES('" & l_ENO & "', " & Format(l_Date, "\#mm\/dd\/yyyy\#") & ", " & l_contractedserviceexpense & ", " &l_travelexpense & ", " &l_personnelexpense & ")" Tag: To send the resultset to printer Tag: 309361
  - 7
    - asp version I need the official version number for asp in Windows 2003 Server Standard edition for documentation. I believe it is 3.0 but is it? Mike Tag: To send the resultset to printer Tag: 309352
  - 8
    - Missing CDONTS property I am using CDONTS in an ASP program to accept input from a Form and send an E-mail. The form includes the following as well as some other information : From (the name of the sender) To ( the name of the recipient) From E-Mail ( the senders E-Mail Address i.e. the Reply to address) To E-Mail ( The recipient's E-Mail Address ) I am having trouble with two properties. What property do I use to set the From (the name of the sender) ? What property do I use to set the From E-Mail ( the senders E-Mail Address i.e. the Reply to address) ? Thanks Tag: To send the resultset to printer Tag: 309350
  - 9
    - Formatting output - Part 2 Here is a little more info, sorry should have explained what my final goal was. I am creating a .vcs file from a form to import into Outlook. I was just testing the output on screen then pasting that into a file, after removing the extra white space, and inserting line breaks. The data is valid, but the formatting into the file isn't working. Was I doing the formatting right if I was generating a file? I need it to create the .vcs without any white spaces and a 'return' after each line to match the output at the very bottom. Here is the code again, and the bit to generate the file: strvCalendar = "BEGIN:VCALENDAR" & vbCrLf & _ "VERSION:1.0" & vbCrLf & _ "BEGIN:VEVENT" & vbCrLf & _ "DTSTART:" & strStart & vbCrLf & _ "DTEND:" & strStart & vbCrLf & _ "LOCATION;ENCODING=QUOTED-PRINTABLE:" & strLocation & vbCrLf & _ "UID:" & strStart & strSubject & vbCrLf & _ "DESCRIPTION;ENCODING=QUOTED-PRINTABLE:" & strDescription & vbCrLf & _ "SUMMARY;ENCODING=QUOTED-PRINTABLE:" & strSubject & vbCrLf & _ "PRIORITY:3" & vbCrLf & _ "END:VEVENT" & vbCrLf & _ "END:VCALENDAR" & vbCrLf Response.ContentType = "text/x-vCalendar" Response.AddHeader "Content-Disposition", _ "filename=Event" & "cal.vcs" Response.Write strvCalendar Response.End This gernerates an error message in Outlook stating it can't import the calendar file. But, again, if I paste the data into a text file with a .vcs extension, and delete white space and insert line breaks I can double click the file and it imports into Outlook fine, this is why I think I just don't know how to format the 'output' correctly. I appreciate the help!!! Final .vcs contents: BEGIN:VCALENDAR VERSION:1.0 BEGIN:VEVENT DTSTART:20060208T180000Z DTEND:20060208T190000Z LOCATION;ENCODING=QUOTED-PRINTABLE:Library UID:20051022T220000ZI-request DESCRIPTION;ENCODING=QUOTED-PRINTABLE:test SUMMARY;ENCODING=QUOTED-PRINTABLE:I-request PRIORITY:3 END:VEVENT END:VCALENDAR Tag: To send the resultset to printer Tag: 309349
  - 10
    - IIS wont start I have been running IIS on Windows 2000 for several years with no problem. Today, when I clicked on the system tray icon and clicked start service, nothing happened - no error messages. IIS just ignored me completely and would not start. I am about to try a computer restart - but has anyone else run into this problem? Thanks John B Tag: To send the resultset to printer Tag: 309345
  - 11
    - Real time site monitoring ASP script Hi, A client of us asked to write a script to View live visitors as they browse her website and to get the information such as, what page they are viewing, what browser type they are using, IP address/host name, visitor time on site and screen resolution. Is this possible in ASP scripting without a server side or client side application? How to get the realtime stats of a visitor? Any ideas will help us much. Thanks, Benny Tag: To send the resultset to printer Tag: 309342
  - 12
    - Restricting Application to Public (Making an "intranet") Hi! I'm very new to ASP.NET and really need some good advice from experts here. I'm creating a web application for my company now. This application has 2 parts. 1 part for the customers to access. The 2nd part is for our staff to access only. My director hopes to make the 2nd part to be something like an intranet, such that only our company's computers (maybe only 1 or 2 in the company) can login to this part of the application. 1. My company's intending to put the application on shared server with a web host. Windows Authentication is NOT allowed. 2. My company doesn't have a static IP address. 3. My manager suggested using Network Card number (which I don't really quite understand. Is there a way to get the Network Card number that's on a client PC?). How?? Some ISP told us that they can provide a firewall management feature such that it will restrict access to the website from anyone that is not coming from my company's network. This requires Static IP. Another told me that IIS Manager has the security feature that restrict access based on IP address. This requires Static IP again. Is it possible to implement the 2nd part (the part that is to be accessed by my company's PC) as a windows application instead? Then we only put the windows application on one computer. So, 1st part (for the public) will be a web application, 2nd part (for my company) is a windows application, both accessing the same database server from an ISP. Will the ISP allow the windows application to access its database server? I've no experience in making a windows application at all, is it the same as making a web application? Please advise. Do my company really have to get a Static IP? Any comments or other suggestions please? Thank you. Tag: To send the resultset to printer Tag: 309332
  - 13
    - Restricting access to website from public Hi! I'm very new to ASP.NET and really need some good advice from experts here. I'm creating a web application for my company now. This application has 2 parts. 1 part for the customers to access. The 2nd part is for our staff to access only. My director hopes to make the 2nd part to be something like an intranet, such that only our company's computers (maybe only 1 or 2 in the company) can login to this part of the application. 1. My company's intending to put the application on shared server with a web host. Windows Authentication is NOT allowed. 2. My company doesn't have a static IP address. 3. My manager suggested using Network Card number (which I don't really quite understand. Is there a way to get the Network Card number that's on a client PC?). How?? Some ISP told us that they can provide a firewall management feature such that it will restrict access to the website from anyone that is not coming from my company's network. This requires Static IP. Another told me that IIS Manager has the security feature that restrict access based on IP address. This requires Static IP again. Is it possible to implement the 2nd part (the part that is to be accessed by my company's PC) as a windows application instead? Then we only put the windows application on one computer. So, 1st part (for the public) will be a web application, 2nd part (for my company) is a windows application, both accessing the same database server from an ISP. Will the ISP allow the windows application to access its database server? I've no experience in making a windows application at all, is it the same as making a web application? Please advise. Do my company really have to get a Static IP? Any comments or other suggestions please? Thank you. Tag: To send the resultset to printer Tag: 309331
  - 14
    - Functions = Type mismatch Could you help me understand why this isn't working. I have a function: Function evaluateSwitch(x) if x = "T" then evaluateSwitch = "border" else evaluateSwitch = "altborder" end if End Function When I do this: response.write evaluateswitch(highlightSwitch) It displays correctly (border) But when I try to incorporate it into a division like this: <div class="<%=evalutateSwitch(highlightSwitch)%>"></div> It does not work and gives me a type mismatch error. Do you have any ideas on why this isn't working. Thanks, James Tag: To send the resultset to printer Tag: 309327
  - 15
    - Suggestion Assistance I have my webserver and a database. Things started to slowdown a ton with access, permissions denied (it is on a Windows XP machine, 10 session limit, etc). I moved my database off the webserver to a faster and more secure location. I can't access the database through the webserver anymore. I am using Windows Authentication. I understand that the webserver will be using the IUSR_xxxx account to access the database. I am at a loss on how to access the database Please help. Thanks Tag: To send the resultset to printer Tag: 309324
  - 16
    - ASP/CDO Mail and Exchange 2000 on AD Domain I have no idea how to get started, really, but I am looking for a way to have an email sent via an ASP page via our Exchange 2000 server. I have a fairly simple asp page that displays data from a SQL 2000 database in the form of web links. A part of this page allows people to post links to the database for display. When someone posts a link, I would like an email sent to me with the data (link) that they posted through the ASP page. This page is on our internal web server only and only our domain users can access this web server. We have a single exchange 2000 mail server. I did look at ASPFAQ 2026 on using CDO for sending e-mail but this doesn't help me much because it doesn't say anything about connecting to the exchange server or anything about proper authentication with the exchange server. Any help would be appreciated. Thanks, Jim Tag: To send the resultset to printer Tag: 309313
  - 17
    - Response.BinaryWrite for one JPEG is Very Slow I am using Response.BinaryWrite to display JPEG's to the browser. The problem is that in IE, one particular JPEG is loading very slow. Normal JPEG's take a few seconds, but this one sometimes takes up to 30 seconds. THe weird thing is that if I refresh really quick, the JPEG appears for quick second, and then the new Response.BinaryWrite kicks in. So, it looks like the browser has the image, but for some reason it is not finishing loading it into the browser. I found another article with a similar issue at http://groups-beta.google.com/group/microsoft.public.data.ado/browse_thread/thread/9d61f1f9e4800ebd/0c071cbb27813992?q=jpg+slow+response.binarywrite&rnum=1#0c071cbb27813992 This seems to be something related to the exact size of that JPEG. Any help would be greatly appreciated. Tag: To send the resultset to printer Tag: 309312
  - 18
    - ASP -> Excel Hello all.. I'm working on some reports, and have added the ability to "download" the reports to excel. Not a big deal, fairly straight forward. However, PHB wants to be able to create some pivot tables from said reports (again.. no biggie) and when he goes to save the file, Excel wants to save the file as a web page instead of and Excel spreadsheet. Now.. I know the simple thing here is to just pick Excel from the drop down box in the save as dialog.. but.. PHB would "prefer" to not have to do that. Has anyone been able to jump this hurdle before? My good friend google hasn't turned anything up. My preference is to give PHB the middle finger.. but alas.. the paycheck is keeping me from doing that. Thanks! Tag: To send the resultset to printer Tag: 309309
  - 19
    - Fronpage access from MacOS software Hi, I have a client who want to edit ASP page but from her Machintosh (MacOS 9.1) and I wonder if anyone here know about any web editing software for Macintosh that supports the Frontpage Server extension? I can't find a copy of the old Frontpage 98 for Mac anymore. Thanks in advance Christian Tag: To send the resultset to printer Tag: 309308
  - 20
    - 2 WebServices with the same name on 1 Server? Hi, I have developed a WebService (with .net) and have to install it on a Windows2003-Server for TEST and PRODUCTION (my Customer has only 1 Windows-Server). It it possible, to use the same name (of the asmx-file) for TEST and PRODUCTION (same files in 2 different folders; I have installed the PRODUCTION-WebService and want to copy it to another folder) or do i have to deploy the WebService for TEST with a different name (and a second installation)? (I have tried the first way, and now I have some Security-Problems (Access is denied), when accessing dll's in the BIN-Subfolder) thank you for your help Ulrich Haverkamp Tag: To send the resultset to printer Tag: 309306
  - 21
    - IIS6/worker processes/performance counters Hi... We're looking at moving an ASP app from IIS 5 to IIS 6. In general things seem to be working okay, but there are some oddities around the edges. One of those unanticipated changes has to do with the new process model and the option to have more than one worker process per web instance. We found that each worker process has its own Application() state and anything your app puts there/uses gets a new copy for every worker process. So depending on how much initialization your app does in Appication() that expense could get paid over and over as IIS 6 cycles worker processes based on idleness, load, memory use, etc. The facet I still have a question about is performance counters. When you have multiple worker processes for a web instance, are the usual performance counters like Active Server Pages/Requests Total, Requests Queued, etc aggregated across worker processes? How are they impacted by worker process cycling? How about custom performance counters? I assume we'd probably have to take extra effort to aggregate custom pcounters across worker processes - is that right? Are there any faqs on the new IIS 6 process model and/or implementing custom pcounters for them? Thanks _mark Tag: To send the resultset to printer Tag: 309305
  - 22
    - Site navigation question Completely new to technologies like CSS, but trying to learn fast.... I've seen a few sites with "very sophisticated" navigation tools that provide menus that both drop down and expand horizontally...very similar to the menu tools we're used to in Windows applications. Anyhow, in an attempt to mimic this, I've looked at a web few sites and studied the source files. It appears that there are two schools of thought here. The first uses unordered lists and the second uses tables to hold the information. Both then use a combination of CSS and JavaScript to control the behaviour. Which really is the method of choice? Thanks Griff PS - not using ASP.NET (yet) Tag: To send the resultset to printer Tag: 309302
  - 23
    - Developing a "google-like" search engine for intranet Hello guys, I've been building a search facility for an intranet site I'm part of developing and we've been building a search engine using Index Server. It mostly works, however there have been a few niggling problems and fixing it seems to be a case of patching errors as we find them so I'm thinking that it might be worth starting the logic from scratch and rebuilding this again. Basically we have a simple search, which is simply a text box with a submit button. I would like some boolean search functionality, ie. search term - would search for all items, search OR term - would search for documents containing either words, search AND NOT term - and so on. We also have an advanced search, with a number of fields - 'all words', 'any words', 'exact phrase' and 'not containing'. Does anyone have any information on building this kind of search, either sample code or simply just a text on how someone might have done this kind of thing. I've had a good look around and am yet to find what I'm looking for. Must have been done a million times before though! Cheers and thanks in advance. Alastair Tag: To send the resultset to printer Tag: 309301
  - 24
    - Trapping ScriptTimeout Error Hi, i want to trap the ASP ScriptTimeout Error. Its okay if i can do it in the same page or redirect to any other page via coding or via any changes in IIS. This is very important to us. Waiting for ur reply. Thanks in advance -- Deepson Thomas Tag: To send the resultset to printer Tag: 309292
  - 25
    - Send mail and auto submit a form? Hi All, I am working on a script and I have a form to a page to be submitted (POST-ed) to an external site. I need that when the user submits the form, first step is to send an email using an asp script and only after that to post the information to the web site. I can send the email but I don't know how to post the form automatically after I send the email. I think I can use javascript, but maybe there is a better way of doing it? Regards, Nicolae Tag: To send the resultset to printer Tag: 309290
- Next
  - 1
    - Sample needed for DB management Hi, Could anyone provide some example/template/links for a web-based access database management (CRUD) system? Thanks a bundle. newbie Tag: To send the resultset to printer Tag: 309288
  - 2
    - fso fails when connecting to mapped drives from asp on IIS 6.0 I've seen posts similar to this, but have not found the magic bullet to solve my problem.. I have an asp page (see source code below) running on IIS 6.0 on Win2003 Server that tries to get file and folder information on a Novell Server. I am able to successfully connect to the share on the Novell box if I use the UNC path. But, unfortunately, I need to have the mapped path for my application. I created a simple vbs script and saved it to the server desktop and run it to verify connectivity to the Novell box. I am logged in to the server with the same user as set up in my website as the anonymous user. The vbs file runs perfectly. But as soon as I move the code into an asp file, I get the following error "Microsoft VBScript runtime error '800a004c' Path not found". If I go into my asp file and change the path to the novell box to a UNC format, then it works. Below is the asp file: <% dim fso, fil, fldr, sbfldr set fso = server.CREATEOBJECT("Scripting.FileSystemObject") set fldr = fso.getfolder("g:\doc_test") for each sbfldr in fldr.subfolders response.write sbfldr.name & "<br>" next %> At this point, I don't feel like it's an authentication issue because I can get it to work with UNC. Any help is greatly appreciated. -- lhansen ------------------------------------------------------------------------ Posted via http://www.webservertalk.com ------------------------------------------------------------------------ View this thread: http://www.webservertalk.com/message988327.html Tag: To send the resultset to printer Tag: 309284
  - 3
    - How do you know if IIS 5.1 is running? I had a windows xp professional and I install the windows component so that I can use the IIS 5.1 to test an ASP file. I went to start and click the run button and then type mmc. As soon as the mmc window opens I click the console but there is an error saying that there is nothing into it. I need help! Thank you-- :) Tag: To send the resultset to printer Tag: 309282
  - 4
    - Problems with building sql statement Hi, I have a sql statement in asp page as below sql = " INSERT INTO tblExpense (ENO, EntryDate, ContractedServiceExpense, " sql = sql & "TravelExpense, PersonnelExpense)" sql = sql & " VALUES('" & l_ENO & "', '" & l_Date & "', '" & l_contractedserviceexpense & "', '" & l_travelexpense & "', '" & personnelexpense & "')" The response.write on sql gives the following: INSERT INTO tblExpense (ENO, EntryDate, ContractedServiceExpense, TravelExpense, PersonnelExpense) VALUES('1', '03/01/2005', '5', '5', '10') However when I am trying to open the recordset, it gives me the following error: Error Type: Microsoft JET Database Engine (0x80040E07) Data type mismatch in criteria expression. I suspect the variables are not properly used to build the above statement. The ENo is of text type, EntryDate is of date type while the rest of the last three fields are of number type. I appreciate any help. Thanks in advance. Regards. Tag: To send the resultset to printer Tag: 309281
  - 5
    - Formatting output I am using a response.write to test the formatting of the output. I am supposed to get this: BEGIN:VCALENDAR VERSION:1.0 BEGIN:VEVENT DTSTART:20051022T090000Z DTEND:20051022T090000Z LOCATION;ENCODING=QUOTED-PRINTABLE:Library UID:20051022T090000ZI-request DESCRIPTION;ENCODING=QUOTED-PRINTABLE:test SUMMARY;ENCODING=QUOTED-PRINTABLE:I-request PRIORITY:3 END:VEVENT END:VCALENDAR But instead I get this: BEGIN:VCALENDAR VERSION:1.0 BEGIN:VEVENT DTSTART:20051022T090000Z DTEND:20051022T090000Z LOCATION;ENCODING=QUOTED-PRINTABLE:Library UID:20051022T090000ZI-request DESCRIPTION;ENCODING=QUOTED-PRINTABLE:test SUMMARY;ENCODING=QUOTED-PRINTABLE:I-request PRIORITY:3 END:VEVENT END:VCALENDAR I am sure I am missing something very simple, but I can't figure out what I am doing wrong. Here is the code: strvCalendar = "BEGIN:VCALENDAR" & vbCrLf & _ "VERSION:1.0" & vbCrLf & _ "BEGIN:VEVENT" & vbCrLf & _ "DTSTART:" & strStart & vbCrLf & _ "DTEND:" & strStart & vbCrLf & _ "LOCATION;ENCODING=QUOTED-PRINTABLE:" & strLocation & vbCrLf & _ "UID:" & strStart & strSubject & vbCrLf & _ "DESCRIPTION;ENCODING=QUOTED-PRINTABLE:" & strDescription & vbCrLf & _ "SUMMARY;ENCODING=QUOTED-PRINTABLE:" & strSubject & vbCrLf & _ "PRIORITY:3" & vbCrLf & _ "END:VEVENT" & vbCrLf & _ "END:VCALENDAR" & vbCrLf Any ideas? TIA!!! Tag: To send the resultset to printer Tag: 309277
  - 6
    - Email link in message through msgbox I am trying to include an email link in the message displayed through a msgbox function. How can I do that? or can I? Thanks. Tag: To send the resultset to printer Tag: 309273
  - 7
    - IIS Stops working after 2-3 days I am working on a project using classic ASP. Every time I install Windows and IIS, it works for 2-3 days and then starts having problems. Specifically, things that have to do with the FileSystemObject stop working. I have tried Win2k, WinXP, the IISs that go with them, different partitions (fresh install), turning Windows Update Off as well as doing full updates, and cannot find a solution that works for more than 2 or 3 days. Is it a worm? A virus? A windows update glitch? It is driving me crazy. Are others having problems like this recently? Thank you, A.L. Tag: To send the resultset to printer Tag: 309271
  - 8
    - ASP Database Problem I have a windows200 server running iis5. I have a number of websites on the server, most of them using asp and either MSAccess or Sql Server databases. Every now and then all the pages that access a database slow way down or time out. I have spent a lot of time trying to track this down and have not found anything that would work. Here is my story. I know it's not a "pure" asp problem because test asp pages that don't access a database will load just fine. Around the time of the problem I often time see the following error, but not always. Access denied attempting to launch a DCOM Server. The server is: {00020906-0000-0000-C000-000000000046} The user is Unavailable/Unavailable, SID=Unavailable. (I have done this. http://support.microsoft.com/default.aspx?scid=kb;en-us;290398) Other websites on other servers that access the same SQL Server work just fine. VB programs running on other computers that are running against a database on the server with the websites that are having problems sometimes error out. at about the same time. The processor on the server always drops to almost zero during the time the pages are not working right. Sometimes the problems clears all on it's own. Sometimes I have to run iisreset to stop and start the server. Sometimes it won't restart and I have to reboot. My gut tells me that it's not related to iis or asp but I don't know that. I have always had some network problems with this server where from time to time a workstation may take a few seconds to browse the files. Confused? I am!!! Please help!!!!! Thanks, Tom Tag: To send the resultset to printer Tag: 309267
  - 9
    - Post file from server to another server - Urgent help required I accept a few user inputs and a file from the user, post it to my ASP page. I'm able to receive the data as well as the file properly in Receiver.asp. In my receiver.asp, I need to process the user inputs and subsequently POST this data and the file again to a different server. I would like to use ServerXMLHttp. Now, how do I simulate Form creation in receiver.asp. I use the following code to post to the second server MyXmlHttp.open "post", myTargetURL,false MyXmlHttp.setRequestHeader "Content-Type", "multipart/form-data" Now here's where I get stuck. 1) How do I construct the form data? How can I put together the data i received (which is text) as well as the received file (which is Binary) in the same Send statement for the Post? -- I assume that if HTML forms do it in some format, I should be able to simulate the same through ASP, but how??? 2) The received file will not be stored anywhere in my server. It has to be forwarded in memory. Should it look somewhat like the following? MyXmlHttp.send ("userId=" & someUserId & "&privateLabelID=" & someLabel & "&File=" & receivedBinaryFileInMemory) Thanks in advance for any help Tag: To send the resultset to printer Tag: 309260
  - 10
    - create an access database using asp+javascript How can I create a database access using asp+javascript withen the code?Is there (createdatabase)?If yes how can we use it? thanks for all -- fad ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ Tag: To send the resultset to printer Tag: 309256
  - 11
    - Web Hosting - what do you suggest? Hi all, I'm italian and I'm planning to manage a web site using a web hosting in the US. Do you have some suggestions? I'm looking for asp, asp.net and ms sql support or in alternative php and mysql, with 24/24 support Thanks in advance PGei Tag: To send the resultset to printer Tag: 309249
  - 12
    - classes in vbscript Hi, i'm trying to create a class which one of its properties is another class. this is what i'm basicly trying to do : public bbb public aaa end class class bugi public ccc as new subbugi public ddd end class set a=new bugi a.ccc.aaa="ds" the problem is that for somereason this doesn't work. any solutions? Roy. Tag: To send the resultset to printer Tag: 309248
  - 13
    - Problem setting InnerText value I hope this illustrates my question a little better. Consider the following script; why does the client side script change the div object's innerHtml property but the server side script does not? Debug reports that the server script does not see the document's div object but I thought I read that varibles created with page scope are available throughout the page. <%@ language="VBSCRIPT" %> <html> <head> <script language="vbscript"> Sub chgDivText oDiv1.InnerHtml="Div changed by button" End sub </script> </head> <body> <div id="oDiv1">Div Label</div> <button onclick="chgdivtext">"Change Div Text"</button> </body> <% oDiv1.InnerHtml="Div changed by server" %> </html> Thanks for your help. Tag: To send the resultset to printer Tag: 309241
  - 14
    - non ascII char probleme hello, when i do .... set xmlhttp = CreateObject("WinHTTP.WinHTTPRequest.5.1") ..... StrXmlhttpResponseText = xmlhttp.responseText StrXmlhttpResponseText = replace(StrXmlhttpResponseText, "../", "/") response.write StrXmlhttpResponseText i have an probleme is the responseText contain non ascii char such as ? or é ! how can i correct that ? thank you by advance stéphane Tag: To send the resultset to printer Tag: 309236
  - 15
    - Want recursive SQL query function to generate breadcrumb navigation I'd want to make a custom class that will generate breadcrumb navigation for my site via a recursive query, e.g. Home > Page1 > Subpage 1. I've structured my database with hierarchical parent/child relationships. Can someone help me set up the code structure? I'm using ASP VBScript, and I have a table structure similar to the following: NavItems ---------- NavitemID (PK) Nav_ParentID Nav_Name The top level record in the entire table is "1", but it would be nice if I could parameterize the function so that I could specify the ID of the current page and the ID of the topmost ID I want to trace to, e.g. GetTrailOfBreadcrumbs(CurrentNavitemID, TopmostNavitemID) The least expensive approach from the standpoint of the database would be something that used something besides ADO recordsets to grab the data. If someone has some code lying around or can offer some guidance, I'd sure appreciate it. Thanks. -KF Tag: To send the resultset to printer Tag: 309232
  - 16
    - Unable to use variables in asp page I am trying to change text in the div tags of my page with values from an object obtained from a server side script but the object is not accessable to the client script. I get an object required error but I know the object exists and is correct becuase I can write the query string value and properties of the object with a server script. I also tried to access the div tags from the server script but this also resulted in an object required error. <body> <% sLdapStr = request.QueryString("ldapurl") set usrobj = GetObject(sLdapStr) %> <div id=oFirstName>label1</div><br> <div id="oLastName">label2</div><br> <div id="oEmpNum">label3</div><br> <% sLdapStr = request.QueryString("ldapurl") response.Write sldapstr & "<br>" response.Write usrobj.Get("givenName") %> <script language=vbscript> oFirstName.InnerText = usrobj.Get("givenName") oLastName.InnerText = usrobj.Get("sn") oEmpNum.InnerText = usrobj.Get("employeeID") </script> </body> Tag: To send the resultset to printer Tag: 309231
  - 17
    - Cannot grab some of the values from a form Hi, I got a simple form where one needs to input data. The data is being processed in an asp page. However, I cannot figure out why couple of values I am typing in the form is not being retrived in the asp processing page. Instead it shows as a null value. Any help is appreciated. I have attached the major code for the form, the processing page and output on the screen including sql output. Any help is appreciated. Regards. FORM CODE: <TABLE border = 0 width= "80%" > <TR> <TD> <INPUT id=chk_0 name = chk_0 type = hidden> <B><Font size = 2 color=darkblue>Add</font></B> </TD> <TD> <INPUT type = "text" size = 12 value = "" name = "ID_0" style = "FONT-SIZE: 10"> </TD> <TD> <INPUT type = "text" size = 12 value = "" name = "date_0" style = "FONT-SIZE: 10"> </TD> <TD> <INPUT type = "text" size = 12 value = "" name = "contractedserviceexpense_0" style = "FONT-SIZE: 10"> </TD> <TD> <INPUT type = "text" size = 12 value = "" name ="travelexpense_0" style = "FONT-SIZE: 10"> </TD> <TD> <INPUT type = "text" size = 12 value = "" name = "personnelexpense_0" style = "FONT-SIZE: 10"> </TD> </TR> </table> PROCESSING CODE: l_ENO = Request.Form("ID_0") Response.Write l_ENO & "<br>" l_Date = Request.Form("date_0") Response.Write l_Date & "<br>" l_ContracedServiceExpense = Request.Form("contractedserviceexpense_0") Response.Write l_contractedserviceexpense l_TravelExpense = Request.Form("travelexpense_0") Response.Write l_travelexpense & "<br>" l_PersonnelExpense = Request.Form("personnelexpense_0") Response.Write l_personnel & "<br>" 'Create the UPDATE SQL STATEMENT sql = " INSERT INTO tblExpense (ENO, Date, ContractedServiceExpense, " sql = sql & "TravelExpense, PersonnelExpense)" sql = sql & " VALUES('" & l_ENO & "' , '" & l_Date & "', '" & l_contractedserviceexpense & "', '" & l_travelexpense & "', '" & personnelexpense & "')" Response.Write sql & "<BR>" OUTPUT FROM THE PROCESSED ASP PAGE 1 03/29/2005 5 INSERT INTO tblExpense (ENO, Date, ContractedServiceExpense, TravelExpense, PersonnelExpense) VALUES('1' , '03/29/2005', '', '5', '') Tag: To send the resultset to printer Tag: 309228
  - 18
    - IIS 6 I am trying to run vb6 webclasses from a NT IIS6 webserver. For a few years we have been running these successfully on IIS4. I'm having a little trouble getting the initial asp page to load. Is there anytning special that needs to be installed for webclasses or asp on IIS 6? Thanks, Ellie Tag: To send the resultset to printer Tag: 309222
  - 19
    - how to retrieve windows login/pwd in ASP ? hi, I want to redirect my user to another page. With ASP (not .Net) and IIS 5.0, under windows 2000 server. We have installed the component WinHTTP that is used to manipulate http requests. We want to automatically identify the user through his Windows login/pwd (NTML) He does not need to type it. How do i get the login/pwd from windows, and perfom an authentification control ? A subsidiary question: then how do i set up a cookie in the client computer ? thanks Tag: To send the resultset to printer Tag: 309218
  - 20
    - ASP -> Database (Insert) Hi, i'm having problems with the insert command in .NET The Select statement works perfectly, but insert.. He gives an error when he executes the command: ExecuteNonQuery() Check the code below.. Thanx in advance! Public Sub voegToe(ByVal aproduct As Product) Dim oConn As New OleDbConnection(mStrConn) Dim sqlCmd As String = "INSERT INTO Product (ProductName, Color, Sizes, M_F, Price, ProductTypeID, ProductClassID, UnitsInStock) VALUES (@ProductName, @Color, @Sizes, @M_F, @Price, @ProductTypeID, @ProductClassID, @UnitsInStock)" Dim oCmd As New OleDbCommand(sqlCmd, oConn) oCmd.Parameters.Add(New OleDbParameter("@ProductName", aproduct.Naam)) oCmd.Parameters.Add(New OleDbParameter("@Color", aproduct.Kleur)) oCmd.Parameters.Add(New OleDbParameter("@Sizes", aproduct.Maat)) oCmd.Parameters.Add(New OleDbParameter("@M_F", aproduct.M_F)) oCmd.Parameters.Add(New OleDbParameter("@Price", aproduct.Prijs)) oCmd.Parameters.Add(New OleDbParameter("@ProductTypeID", aproduct.TypeID)) oCmd.Parameters.Add(New OleDbParameter("@ProductClass", aproduct.ClassID)) oCmd.Parameters.Add(New OleDbParameter("@UnitsInStock", aproduct.Voorraad)) Try oConn.Open() oCmd.ExecuteNonQuery() oConn.Close() Catch ex As Exception Throw New Exception("Database niet gevonden") oConn.Close() End Try End Sub My DB is added in the config file so i don't know what the problem COULD be.. I have the same problem with UPDATE & DELETE... Only SELECT works.. Tag: To send the resultset to printer Tag: 309199
  - 21
    - Generate Excel File Using ASP Hi experts, With response.contenttype = "application/vnd.ms-excel", I can easily export my data to Excel which is embeded and shown within a browser. If I'm going to save the Excel file through ASP programming, which method can I use? I need to save the data to Excel file with dynamic name (the file name should contain key values and appended with system datetime). Thanks a lot Tag: To send the resultset to printer Tag: 309198
  - 22
    - ASP/database problem I hope I can make this clear: I have an Access 2000 database that drives an ASP web site to track sales leads. There is a combo box , "units", that lists the inventory of models we sell. Here's a code snippet Fills the combo box: <select name="units" id="units"> <% While (NOT leads1.EOF) %> <option><%=(leads1.Fields.Item("units").Value)%></option> <% leads1.MoveNext() Wend If (leads1.CursorType > 0) Then leads1.MoveFirst Else leads1.Requery End If %> This code works perfectly to fill the combobox with the model names from the units table of the units db. Leads1 is the recordset that is connected to the db The 'units' table has three fields: ID (autonumber - PK) units - Text field AnnValue - currency field The form also has a readonly textbox, "AnnVal" to display the Annual cost of the service contract for that unit. Displays textbox: <td valign="top"><input name="AnnVal" type="text" id="AnnVal" size="15" readonly> </td> I want to populate that textbox with the data in the AnnValue field of the units db. Based on the choice the user makes in the combobox, I want the corresponding price to populate the read-only textbox. I have seen several solutions that employ some Javascript with ASP to get this to work but I have no idea how to implement these suggestions. Being a real newbie, can someone offer some nicely commented code to help me make this work the way I have described? Thank you so much. You folks have always been so helpful! Tag: To send the resultset to printer Tag: 309197
  - 23
    - cdosys with windows 2003 error Hi, I'm using windows 2003 with asp. However I'm having problems sending email using the cdosys object. My code is below and I don't believe its the code but on the send command. <% dim sch dim cdoConfig dim cdoMessage sch = "http://schemas.microsoft.com/cdo/configuration/" Set cdoConfig = Server.CreateObject("CDO.Configuration") cdoConfig.Fields.Item(sch & "sendusing") = 2 cdoConfig.Fields.Item(sch & "smtpserver") = "127.0.0.1" cdoConfig.fields.update Set cdoMessage = Server.CreateObject("CDO.Message") Set cdoMessage.Configuration = cdoConfig cdoMessage.From = "test@gmail.com" cdoMessage.To = "test@gmail.com" cdoMessage.Subject = "Sample CDONTS NewMail" cdoMessage.TextBody = "This is a test for CDONTS message" cdoMessage.Send Set cdoMessage = Nothing Set cdoConfig = Nothing %> error '8004020f' /tad/testing.asp, line 30 I'm not sure what's wrong. When I go to my SMTP Virtual Server settings in IIS --> Properties --> Delivery --> Advanced . The FQDN is localhost and the smarthost is blank. Any expertise/help would be greatly appreciated. Thanks :D Tag: To send the resultset to printer Tag: 309195
  - 24
    - developing asp with Access database open Hi All, I have some asp pages which use a local Access database. I want to add different records to the database and also to be able to browse the page. When the database is open in MS Access, I can't open the asp pages, because I get an error (Microsoft JET Database Engine (0x80004005) Could not use ''; file already in use.) I wonder if there is a way of being able to read records from the database in an asp script while the database is open in Access. Regards, Nicolae Tag: To send the resultset to printer Tag: 309192
  - 25
    - Read binary record from Database with ADODB.Stream Hello! I wanna read binary data from database with ADODB.Stream object. So I wrote code.. --------- <% query = "SELECT * FROM Categories" adoDB.DefaultDatabase = "Northwind" adoRs.Open query, adoDB, 1 Set rec = Server.CreateObject("ADODB.Record") 'read [Picture] column. rec = adoRs(3) ------------ And the 'rec' TypeName() is 'Byte()' But I can't get it to ADODB.Stream. How Can I do? Or Can I read binary column to another way? Pardon my poor English. Thanks. - GuyV - Tag: To send the resultset to printer Tag: 309190

I want to send the whole resultset i retrieved. now i am retrieving the
resultset and able to print 15 records in one frame. if i want to print
whole the dump records what i have to do.? please help to this scenario.

Top

Re: To send the resultset to printer by Curt_C

Curt_C
Sun Apr 03 16:00:56 CDT 2005

huh? Are you trying to print clientside or serverside? are you saying you
are already getting it to print partial results but not full results?

--
Curt Christianson
Site & Scripts: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com

"guru" <guruprasadmh@gmail.com> wrote in message
news:1112447161.187653.311800@z14g2000cwz.googlegroups.com...
>I want to send the whole resultset i retrieved. now i am retrieving the
> resultset and able to print 15 records in one frame. if i want to print
> whole the dump records what i have to do.? please help to this scenario.
>

Top