how to show more than column value in combo box

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
    - PLEASE HELP! Getting Error -214746259 I wonder if anyone can help me out, or point me in the right direction, in solving my current problem: I have started seeing an error on one of my ASP pages. Id displays totally blank except for two lines, as follows: '80004005' ?, line 0 There is no more information on the page other than that. I have managed to establish that the error number is -2147467259. I haven't got a clue where to even begin looking because there is so little information from the error to suggest what is wrong. Has anyone else seen anything like this? Does anyone have any suggestions? Many thanks in advance - Debbie Tag: how to show more than column value in combo box Tag: 332532
  - 2
    - Page continuously refreshs One of my ASP's was working fine for a long time. Now it has started constantly refreshing itself. Everytime I run it I just get the first part of the page, then it refreshes itself, the rest of the page doesn't get displatyed, and this goes on continuously. The main sympton is that the select box thats being populated gets a different number of rows loaded into it each time. And the last row that gets loaded is always truncated. Its almost like theres some size limitation its encountering. I didn't think there was a limit on select boxes. The ASP is index.asp, and I have a form that submits it to itself. Any help is greatly appreciated. I'm using WinXP Pro SP2, IIS, Access db. Here's the code segment ... <form method="GET" action="index.asp"> <input type="submit" value="Ok" style="width: <%=Session("SystemButtonWidth")%>; height: <%=Session("SystemButtonheight")%>;"> Q-TAGS SELECTION LIST (red lines indicate notes are attached) <br> <SELECT name="lbESCI" size="7" style="font-size:10;color:BLACK;font-family:ARIAL"> <% Do While Not rs1.EOF if len(rs1("NOTES")) > 0 then myOptionText = " class=red " else myOptionText = " class=black " end if if mySearchString <> "" then if rs1("ESCI") = mySearchString then response.write "<option selected " & myOptionText & ">" else response.write "<option " & myOptionText & ">" end if elseif rs1("ESCI") = left(myQueryString,6) then response.write "<option selected " & myOptionText & ">" else response.write "<option " & myOptionText & ">" end if myOption = rs1("ESCI") & " | " & rs1("ESCN") response.write myOption response.write "</option>" rs1.MoveNext Loop %> </select> </form> Tag: how to show more than column value in combo box Tag: 332510
  - 3
    - Newbie: Problem with dsn odbc I am new to ASP (and just started ASP.NET). I successfully rebuilt a site using asp.net that I had previously done in php. This is for me to learned asp (as I did in asp.net). I am having a problem using ODBC to SQL Server on my laptop. I successfully used asp.net, but want to do it here in asp using odbc. I created a dsn called SQLEXPRESS. At first it had windows authentication. Then I created a user called ASPpage with a password. My original code was: <% dim q, num, i, acct, coName set Conn = Server.CreateObject("ADODB.Connection") q = "SELECT * FROM Company" Conn.Open "DSN=SQLEXPRESS" set rs = Conn.Execute(q) set of = Server.CreateObject("ADODB.Field") num = rs.Count for i=0 To num - 1 acct = of("accountNumber") coName = of("companyName") Response.Write(acct & " " & coName & "<br>") next conn.Close When I added the user I changed the Conn.Open line to: Conn.Open "DSN=SQLEXPRESS;UID=ASPpage;PWD=asptest" Both times I got the error message of failing at the Conn.Open line: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "the_default_db_name" requested by the login. The login failed. /MyWeb/HelloWorld.asp, line 15 When I use asp.net the connection string is: "Data Source=LAPTOP\SQLEXPRESS;Initial Catalog=the_default_db_name;Integrated Security=True" providerName="System.Data.SqlClient" Any suggestions? Shelly Tag: how to show more than column value in combo box Tag: 332509
  - 4
    - Search Hosted Files In UNIX, one can use "grep" command to search for string occurrences within a file. How can I do this in Windows Server belonging to a third-party hosting facility? Thanks. Tag: how to show more than column value in combo box Tag: 332498
  - 5
    - Manage 404 Error Page Hello, I created my custom error page and it sends an email with serverVariable("URL") to me, so I know what files users may request which are not found. All of a sudden, I started receiving a large number of emails. My questions are as follows now: 1) what's the best way to log errors: database or flat text file (in terms of speed and use)? 2) what useful info can I collect on error page 404 as you may suggest (serverVariable("URL") serverVariable("REMOTE_ADDRESS") are not just enough) Thanks Tag: how to show more than column value in combo box Tag: 332497
  - 6
    - Http 500 Internal Error dear everyone.. i want to create one attachment which is trigerred once the user click on "approve" button and each time user clicks, there will be one attachment for that particular form. before that, i need to let u know that, for case: "reject", i already put below code. and it works fine. and now, after i put the code for case: "approve", Http 500 error comes out. below is the code which i duno wat's wrong with it. it only give me Http 500 Internal Error. How to solve it? I need your help. Tx a lot for your help! Const ForWriting = 2 ' Input OutPut mode Const Create = True 'allows asp to create the file if it dun exist Dim FSO ' FileSystemObject Dim TSO ' TextStreamObject ' Use MapPath function to get the Physical Path of file Dim strfileName1 : strfilename1 = "" strfileName1 = "DIapp" & strAppAction & "_" & intSesEmpID & "_" & Day(Date()) & Month(Date()) & Year(Date()) & "_" & Hour(now())& Minute(now()) & Second(now()) & ".txt" Dim MyFile Dim MyString1 : MyString1 = "Variables Before Processing : " & vbcrlf MyString1 = MyString1 & "intCHID = " & intCHID & vbcrlf MyString1 = MyString1 & "intEmpID = " & intEmpID & vbcrlf MyString1 = MyString1 & "Status = " & strStatusCode & vbcrlf MyString1 = MyString1 & "intCurrentLevel = " & intCurrentLevel & vbcrlf MyString1 = MyString1 & "intCurrentVersion = " & intCurrentVersion & vbcrlf MyString1 = MyString1 & "strCurrencyId = " & strCurrencyId & vbcrlf MyString1 = MyString1 & "strSolutionGroup = " & strSolutionGroup & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strOrigDate) = " & ReplaceSingleQuote(strOrigDate) & vbcrlf MyString1 = MyString1 & "strProductGM = " & strProductGM & vbcrlf MyString1 = MyString1 & "strProductGMPct = " & strProductGMPct & vbcrlf MyString1 = MyString1 & "strTSGM = " & strTSGM & vbcrlf MyString1 = MyString1 & "strTSGMPct = " & strTSGMPct & vbcrlf MyString1 = MyString1 & "cdbl(strPSGM) = " & cdbl(strPSGM) & vbcrlf MyString1 = MyString1 & "cdbl(strPSGMPct) = " & cdbl(strPSGMPct) & vbcrlf MyString1 = MyString1 & "cdbl(strMSGM) = " & cdbl(strMSGM) & vbcrlf MyString1 = MyString1 & "cdbl(strMSGMPct) = " & cdbl(strMSGMPct) & vbcrlf MyString1 = MyString1 & "strTotalGM = " & strTotalGM & vbcrlf MyString1 = MyString1 & "strTotalGMPct = " & strTotalGMPct & vbcrl MyString1 = MyString1 & "ReplaceSingleQuote(strSalesOrderNo) = " & ReplaceSingleQuote(strSalesOrderNo) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strPODate) = " & ReplaceSingleQuote(strPODate) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strCustomerPONo) = " & ReplaceSingleQuote(strCustomerPONo) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strDCQuotationNo) = " & ReplaceSingleQuote(strDCQuotationNo) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strDeliverDate) = " & ReplaceSingleQuote(strDeliverDate) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strInstallDate) = " & ReplaceSingleQuote(strInstallDate) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strSalesUnit) = " & ReplaceSingleQuote(strSalesUnit) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strCustomerType) = " & ReplaceSingleQuote(strCustomerType) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strCustomerNewInd) = " & ReplaceSingleQuote(strCustomerNewInd) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strPartialShipment) = " & ReplaceSingleQuote(strPartialShipment) & vbcrlf MyString1 = MyString1 & "strPartialShipmentLots = " & strPartialShipmentLots & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strBillToParty) = " & ReplaceSingleQuote(strBillToParty) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strBillAddress) = " & ReplaceSingleQuote(strBillAddress) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strBillContact) = " & ReplaceSingleQuote(strBillContact) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strBillTel) = " & ReplaceSingleQuote(strBillTel) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strBillFax) = " & ReplaceSingleQuote(strBillFax) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strSoldToParty) = " & ReplaceSingleQuote(strSoldToParty) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strSoldAddress) = " & ReplaceSingleQuote(strSoldAddress) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strSoldContact) = " & ReplaceSingleQuote(strSoldContact) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strSoldTel) = " & ReplaceSingleQuote(strSoldTel) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strSoldFax) = " & ReplaceSingleQuote(strSoldFax) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strShipToParty) = " & ReplaceSingleQuote(strShipToParty) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strShipAddress) = " & ReplaceSingleQuote(strShipAddress) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strShipContact) = " & ReplaceSingleQuote(strShipContact) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strShipTel) = " & ReplaceSingleQuote(strShipTel) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strShipFax) = " & ReplaceSingleQuote(strShipFax) & vbcrlf MyString1 = MyString1 & "intCreatedByID = " & intCreatedByID & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strCreatedDateTime) = " & ReplaceSingleQuote(strCreatedDateTime) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strApproveDate) = " & ReplaceSingleQuote(strApproveDate) & vbcrlf MyString1 = MyString1 & "strExchangeRate = " & strExchangeRate & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strRequestorRemarks) = " & ReplaceSingleQuote(strRequestorRemarks) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strProjectName) = " & ReplaceSingleQuote(strProjectName) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strAccountManager) = " & ReplaceSingleQuote(strAccountManager) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strINRJQN) = " & ReplaceSingleQuote(strINRJQN) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strVATServiceTax) = " & ReplaceSingleQuote(strVATServiceTax) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strBGReq) = " & ReplaceSingleQuote(strBGReq) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strWType) = " & ReplaceSingleQuote(strWType) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strSType) = " & ReplaceSingleQuote(strSType) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strRPR) = " & ReplaceSingleQuote(strRPR) & vbcrlf MyString1 = MyString1 & "strIsExcTo5KLmt = " & strIsExcTo5KLmt & vbcrlf MyString1 = MyString1 & "strIsExcToLML = " & strIsExcToLML & vbcrlf MyString1 = MyString1 & "strInsideSalesId = " & strInsideSalesId & vbcrlf MyString1 = MyString1 & "strInsideSalesDOId = " & strInsideSalesDOId & vbcrlf MyString1 = MyString1 & "strSpecSalesId = " & strSpecSalesId & vbcrlf MyString1 = MyString1 & "strInstallNR = " & strInstallNR & vbcrlf MyString1 = MyString1 & "strMS_PrjTracking = " & strMS_PrjTracking & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strMS_PrjCostRefNo) = " & ReplaceSingleQuote(strMS_PrjCostRefNo)& vbcrlf MyString1 = MyString1 & "strPS_PrjTracking = " & strPS_PrjTracking & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strPS_PrjCostRefNo) = " & ReplaceSingleQuote(strPS_PrjCostRefNo)& vbcrlf MyString1 = MyString1 & "strPS_Manday = " & strPS_Manday & vbcrlf MyString1 = MyString1 & "strIsMYMC = " & strIsMYMC & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strPaymentTerm) = " & ReplaceSingleQuote(strPaymentTerm) & vbcrlf MyString1 = MyString1 & "intRegionId = " & intRegionId & vbcrlf MyString1 = MyString1 & "strBlendedAmt = " & strBlendedAmt & vbcrlf MyString1 = MyString1 & "strBlendedPct = " & strBlendedPct & vbcrlf MyString1 = MyString1 & "strBillCustType= " & strBillCustType & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strRefNo) = " & ReplaceSingleQuote(strRefNo) & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strDORemarks)& = " & ReplaceSingleQuote(strDORemarks) & vbcrlf MyString1 = MyString1 & "strAccMgrIDOut = " & strAccMgrIDOut & vbcrlf MyString1 = MyString1 & "ReplaceSingleQuote(strDOSOno)= " & ReplaceSingleQuote(strDOSOno)& vbcrlf MyString1 = MyString1 & "strCompanyIn= " & strCompanyIn& vbcrlf MyString1 = MyString1 & "strMSAT = " & strMSAT & vbcrlf MyString1 = MyString1 & "strCompany = " & strCompany & vbcrlf MyString1 = MyString1 & "intCurrentVersion_DO= " & intCurrentVersion_DO & vbcrlf MyString1 = MyString1 & "strDuration = " & strDuration& vbcrlf MyString1 = MyString1 & "strFastTrackClient = " & strFastTrackClient & vbcrlf MyString1 = MyString1 & "strExcpLMLList = " & strExcpLMLList & vbcrlf MyString1 = MyString1 & "strExcpLMLDO = " & strExcpLMLDO & vbcrlf MyString1 = MyString1 & "strExcpLMLBID = " & strExcpLMLBID & vbcrlf MyString1 = MyString1 & "strExcpLMLGAM = " & strExcpLMLGAM & vbcrlf MyString1 = MyString1 & "strSQLHdr = " & strSQLHdr MyFile = Server.MapPath("check\" & strfileName1) Set FSO = Server.CreateObject("Scripting.FileSystemObject") Set TSO = FSO.OpenTextFile(MyFile, ForWriting, Create) TSO.write MyString1 & vbcrlf ' close TextStreamObject and ' destroy local variables to relase memory TSO.close Set TSO = Nothing Set FSO = Nothing Tag: how to show more than column value in combo box Tag: 332495
  - 7
    - Why this ASP code all of the sudden stopped working? Hi, This classic asp code : <% Dim objXMLHTTP Set objXMLHTTP = Server.CreateObject("microsoft.XMLHTTP") objXMLHTTP.Open "GET", "http://finance.yahoo.com/d/quotes.csv?s=ABX+ABX.TO&f=sl1d1t1c1ohgv&e=.csv", False objXMLHTTP.Send Response.write objXMLHTTP.ResponseText %> Returns the follwoing error: msxml3.dll error '80070005' Access is denied. /tsx/sg.ASP, line 8 Is there any way I can fix that? Any help would be appreciated, Max Tag: how to show more than column value in combo box Tag: 332488
  - 8
    - ASP Programmer for modification to web site shopping cart Hi all Looking for programmer for ASP2.0 based website mod. Located preferably in Melbourne, Australia. Cheers George Tag: how to show more than column value in combo box Tag: 332487
  - 9
    - is there any way to print a stack trace in ASP classic ? I had found some debug examples here: http://www.aspemporium.com/codelib.aspx?pid=115&cid=16 but I am mainly interested in a trace so I could see what functions are on the stack as well as the source file and line number they where called from. You can do this in PHP by some such debug_print_trace() call Tag: how to show more than column value in combo box Tag: 332480
  - 10
    - using dot.net with asp classic ? If we installed .net studio on our development server, I would like to think it would work seamlessly with our existing classic asp code ? I am mainly interested in what debugging features this would give me. Please let me know as I am new to ASP and trying to figure out a large complex code base with no documentation and I am the only developer on the project .. If we installed .net studio, I would hope it would be able to work with the code we have without any changes and it wouldn't cause anything to break . Tag: how to show more than column value in combo box Tag: 332479
  - 11
    - Sub-Description in a Search If you were to Google "Sears," (or other big names), Sears' website pulls up first. Beneath the link is a description that Sears includes in the "description" META tag. That I understand and know how to do. However, after the description are four other links: Baby, Clothing, For the Home, and Computers & Electronics. How would I modify HTML/ASP so that sub-descriptions to pull up in a search engine for my sites? Tag: how to show more than column value in combo box Tag: 332477
  - 12
    - Focus on element not working correctly Here is the scenario. I have an alert that fires if the user has not filled in a field. What I would like to do is have the browser focus on the message (div id="message"). That div is generated only if there is an error, and the server side code is placed within the head. What I think is happening is the js focus is firing BEFORE the div is rendered, because I am getting the js error document.getElementById("") is null or is not an object. This is not something vital, just something I think would be nice for the user (especially if the form and message are below the fold). I have included code and markup below. (no URL - this is stripped down to what's necessary). <% option explicit%>  <% dim fname, isget if request.servervariables("REQUEST_METHOD") = "POST" then ispost = true elseif request.servervariables("REQUEST_METHOD") = "GET" then isget = true end if if ispost then %> if request.form("fname") = "" then required = "fname" message = "First name is required" end if if message <> "" then %> <script type="text/javascript"> alert("<%=message%>"); document.getElementById("message").focus() </script> <% message = "<div id=" & chr(034) & "message" & chr(034) & "><strong>" & message & "</strong></div>" end if fname = "Your first name" end if%> <style type="text/css"> .required, #required { font-weight:bold; color:red; } <% if required <> "" then%> #<%=required%>1 { font-weight:bold; background-color: yellow; color:red } #<%=required%> { background-color: pink; color: black } <% end if%> </style> </head> <body> <form method="post" action="<%=request.servervariables("script_name") %>"> <%=message%> <fieldset><legend>* indicates <span class="required">Required</span> fields</legend> <label for="fname" id="fname1" class="required">First Name </label> <input type="text" name="fname" id="fname" value="<%=fname%>" <%if isget then%>onfocus="if(this.value == '<%=fname%>') this.value = '';"< %end if %>><br> <label for="lname" id="lname1">First Name </label> <input type="text" name="lname" id="lname" value="<%=lname%>" <%if isget then %>onfocus="if(this.value == '<%=lname%>') this.value = '';"<%end if %>><br> </fieldset> <p><input type="submit" value="Submit"></p> </form> </body> </html> Tag: how to show more than column value in combo box Tag: 332459
  - 13
    - IsPostBack but in ASP Hello, Is there the IsPostBack command in ASP (not ASP.net) ? Or How can I detect a refresh in a ASP page ? Thanks Sebastien Tag: how to show more than column value in combo box Tag: 332447
  - 14
    - Trying to get Microsoft Script Debugger working with classic ASP, please help .. I am trying to get the debugger to work for ASP. The server is set up with classic ASP, on IIS 6.0. I just installed the Microsoft Script Debugger version 1.0.7295, and older product (97). Anyway, I followed all the config instructions I could find. I had to run the debugger by finding it in Windows Explorer as the install gave me no icons. At any rate, I noticed when I had the debbuger running and I was looking at help files on the server, the debugger showed those as running documents. To configure for debugging, I enabled debuging asp in the IIS manager I ran dcomcnfg from startup/run found machine debug and set the properties. Location is checkboxed as "run app on this computer" The ASP 3.0 book (1999) says to to start/run: MMC and use that to configure debugging. I figured out how to do that after locating the iis.msc file, and then finally it appears that from that angle it looks correct as well, but when I open a browser session from a remote machine that connects to the server, the debugger doesn't show anything in the running documents window, so I am stumped at the moment and slightly bewildered, any ideas ? things to try ? thanks alot Tag: how to show more than column value in combo box Tag: 332445
  - 15
    - Generic code for "texting" I can send a text message to my cell phone by just sending an email to my cell number @att.com. Where can I get the protocol for other carriers? My boss wants me to set up a form on our internal web site for sending text messages to managers. Their phones are with various carriers (ATT/Cingular, Verizon, T-Mobile, etc.) Thanks! Tag: how to show more than column value in combo box Tag: 332443
  - 16
    - Startdate - Enddate dropdown not working ASP, IIS6 I have a startdate-enddate dropdown in asp that works great on my development machine (XP Pro IIS5) but when I port it over to the web server (Win Server 2003, IIS6), I do not get the desired results. What should happen is that the start-end range should show the current week. Instead, the start-end range defaults to 2 months earlier, when the page was deployed. I have added some code below: <% dim begindate, enddate, startdate %> <form method="post"> <input name="employee_id" type="hidden" value="<%= trim(request("employee_id")) %>"> <input name="office_id" type="hidden" value="<%= trim(request("office_id")) %>"> <select name="weekbegin" onChange="submit()"> <% startdate = formatDateTime(dateAdd("d", 2 - weekday(now), now), vbShortDate) for x = 0 to 365 step 7 begindate = formatDateTime(dateAdd("d", 2 - weekday(now) + x, now), vbShortDate) enddate = dateAdd("d", 6, begindate) if begindate = request("weekbegin") then %> <option value="<%= begindate %>" selected><%= begindate & " to " & enddate %></option> <% else %> <option value="<%= begindate %>"><%= begindate & " to " & enddate %></ option> <% end if next %> </select> </form> Any help or insight would be appreciated. Thanks Tag: how to show more than column value in combo box Tag: 332434
  - 17
    - to access a page in that directory, you have to give a username and a password Hello, info: I'me a rookie with IIS I have on a WinXP Pro the IIS installed, so I can test some pages before uploading to the hostserver online on the hostserver is a possibility (with the program PLESK) to make a directory secure (to access a page in that directory, you have to give a username and a password) in my own server (IIS) is a directory where I want to do the same thing how can I do that with the "Internet Information Services Manager" (IIS-manager) (to access a page in that directory, you have to give a username and a password) C. Tag: how to show more than column value in combo box Tag: 332433
  - 18
    - Classic ASP with Vista Has anyone used the traditional Classic ASP / Access DB / IIS configuration on Vista yet? I haven't, but before I upgrade to Vista I would like to ensure all my websites will work once I do. What version of Vista is best to use (and includes IIS) ? What problems did you have with database connectivity ? Any other issues ? TIA, PW Tag: how to show more than column value in combo box Tag: 332431
  - 19
    - Capturing Logged In User Does anyone know away i can pull the logged in user name from a computer for a web form? this is what i did to pull from the cookie when user log into my site but now i want to get request from non site users but capture non logged in users ids too. ~ <input type="text" name="EmailID" maxlength="10" size="10" Value="<%=Request.Cookies("NPSC")("UserName")%>" ~ Tag: how to show more than column value in combo box Tag: 332429
  - 20
    - Image Resizing in ASP Please, recommend me a good free image resizing tool you've been successfully using up to this date in ASP or ASP.NET. Thanks. Tag: how to show more than column value in combo box Tag: 332426
  - 21
    - Corrupted international characters I'm using international characters on my .aspx files. In order to publish my site to the webserver I'm using frontpage - to allow me to publish only changes (I have 100's of files). However the international characters on the server side are being corrupted. If I transfer the same files using a standard FTP client - everything is OK. I've tried with FP 2003 and with MS Expression Web. Tag: how to show more than column value in combo box Tag: 332423
  - 22
    - Images TIFF in .aspx Web page Hi.... Please help me with this case. I need to show an image .TIFF in a .aspx web page. The web site is developer on Visual Studio 2005. The image control no support this image format, that control i can use to show this format??? Thanks. Tag: how to show more than column value in combo box Tag: 332411
  - 23
    - Sort XML Playlist I use Windows Media Player (WMP) version 9 and have a great deal of WMP playlists. One short coming of WMP is that there is no way to sort playlists. However, WMP's playlists look like there are in XML format (See Sample Code below). I'm a VB/ASP/Access developer, but only have a basic understanding of XML files. I was curious if it would be possible to sort a XML playlist like my sample playlist below? SAMPLE CODE: *********************** <?wpl version="1.0"?> <smil> <head> <meta name="Generator" content="Microsoft Windows Media Player -- 9.0.0.3250"/> <author/> <title>Sample WMP Playlist</title> </head> <body> <seq> <media src="D:\mp3\The Doors\The Doors_L.A. Woman_L.A. Woman_05.mp3" cid="{CBD4C35E-4691-49AE-8194-FE354E48F621}" tid="{29CC328D-F875-41A3-866D-C7303EB3E5C5}"/> <media src="D:\mp3\The Doors\The Doors_The Doors_Break on Through_01.mp3" tid="{61D292E7-A180-4D45-9578-67878763D914}"/> <media src="D:\mp3\The Doors\The Doors_L.A. Woman_Love Her Madly_02.mp3" cid="{1C8D07ED-F2CD-46C8-B785-38D33088764E}" tid="{248770B2-BD01-4E59-BEF4-F24047B5F9B0}"/> <media src="D:\mp3\The Doors\The Doors_Morrison Hotel_Roadhouse Blues_01.mp3" cid="{7DB54FF5-2B9B-4ACA-8747-4B783C0CFFBF}" tid="{7D4E2093-20FE-4317-8DFF-6BE6BBE57AFB}"/> <media src="D:\mp3\The Doors\The Doors_Strange Days_Love Me Two Times_03.mp3" cid="{E0272594-9590-4EBF-94C8-C7918C23B6F0}" tid="{C06CF2E1-9094-4CF3-A7A0-CED6F8683F98}"/> <media src="D:\mp3\The Doors\The Doors_The Doors_Back Door Man_07.mp3" tid="{697A39F8-FBCE-4308-8424-E5E0754005DC}"/> <media src="D:\mp3\Led Zeppelin\Box Set 1 (vol 1)\Led Zeppelin_Led Zeppelin [Box Set] (Vol 1)_Traveling Riverside Blues_11.mp3"/> <media src="D:\mp3\Led Zeppelin\Box Set 1 (vol 1)\Led Zeppelin_Led Zeppelin [Box Set] (Vol 1)_Whole Lotta Love_01.mp3"/> <media src="D:\mp3\Led Zeppelin\Box Set 1 (vol 2)\Led Zeppelin_Led Zeppelin [Box Set] (Vol 2)_Immigrant Song_03.mp3"/> <media src="D:\mp3\Led Zeppelin\Box Set 1 (vol 2)\Led Zeppelin_Led Zeppelin [Box Set] (Vol 2)_Misty Mountain Hop_12.mp3"/> <media src="D:\mp3\Led Zeppelin\Box Set 1 (vol 3)\Led Zeppelin_Led Zeppelin [Box Set] (Vol 3)_Kashmir_01.mp3" cid="{90507084-8561-47BA-8F42-61F9A02B6925}" tid="{8F814FA3-7C8F-4ACB-AE3B-578691B9BE51}"/> <media src="D:\mp3\The Doors\The Doors_Strange Days_Moonlight Drive_06.mp3" tid="{B7BE8CBC-6D8E-47D0-9CDD-96D317C61C7D}" cid="{CED8E89F-E95D-450F-ACEA-AA3DFC34E537}"/> </seq> </body> </smil> Tag: how to show more than column value in combo box Tag: 332405
  - 24
    - ASP->SOAP->Reporting Services? Has anyone constructed a SOAP request with Classic ASP and sent it to SQL Server Reporting Services to render a report formatted as PDF to a browser (and dealt with the SOAP response)? I'm not talking about URL access, but accessing the SSRS web service directly with SOAP (passing credentials, parameters, format, etc.) There seems to be nothing out there for ASP 3.0 - it's ALL .NET. Thanks for any direction or examples. Tag: how to show more than column value in combo box Tag: 332404
  - 25
    - Buy more cheaper runescape gold on www.buy-runescape-money.com We are a professional Store, we supply runescape gold, someone may call it runescape Money, or GP ( Gold Pieces ). All we do is just for your best experience in games. Actually, there are no runescape hacks, runescape cheats, and if there were, it's no useful or your account would get banned. But if you buy gold from us it is very safe. Because we contact you in game and give you the gold face to face. So do not trust any hacks, duplicating items and autominers, as they may be virus's and steal your password, and ban your account. We strive to offer the fastest and most Reliable service on the web for all your gaming needs. We are here for 24 hours a day 7 days a week. With deliveries done within a few minutes from the time your order is placed. Get the most out of your game time and money with the best, only at your most reliable internet gaming services. http://www.buy-runescape-money.com http://www.buy-runescape-money.com/runescape%20gold.html http://www.buy-runescape-money.com/runescape%20money.html http://www.cheap-runescape-gold.com Tag: how to show more than column value in combo box Tag: 332396
- Next
  - 1
    - Getting fragment from URL I have a series of pages I want to put a link on that will allow them to go back to the page they entered from (the referring URL). The problem is that to return to the previous page correctly I need the fragment (page.asp#fragment) along with the referring url. Problem is that ASP does not seem to provide that. Any advice on how to get the fragment along with the URL? For those who might suggest doing a javascript back()... this will not work since the area people are going into can be a group of pages and they may click around a few times before wanting to return, so I was going to save the referring URL when the enter. Thanks Tag: how to show more than column value in combo box Tag: 332393
  - 2
    - Retreiving image from access DB and displaying in an ASP page Hi, I tried retreiving an image from an access data base and display it to the asp page . The code is shown below. But the same is not working. Can someone provide me with some valuable inputs. Save the belo code in an asp ShowPicture.asp <% 'Declare Variables.. Dim sql Dim rs Dim conn Dim userID,str userID = Request("PhotoId") If userID = "" Then userID = 1 'Instantiate Objects Set conn=server.createobject("adodb.connection") Set rs = Server.CreateObject("ADODB.Recordset") conn.open "provider=Microsoft.jet.oledb.4.0;" & "Data source=C: \test\test_image.mdb" 'Get the specific image based on the ID passed in a querystring str = "SELECT * FROM users where user_id =" & userID rs.Open str, conn,3,3 if rs.eof then 'No records found Response.End else 'Display the contents Response.ContentType = "image/jpg" Response.BinaryWrite(rs("user_photo")) end if 'destroy the variables. rs.Close conn.Close set rs = Nothing set conn = Nothing %> 2) Create another asp page image.asp with the belo code <IMG SRC="ShowPicture.asp?PhotoId=1"> image.asp is called first which tries to get the image from ShowPicture.asp. I seem to get the package data in binary format . No image is getting displayed. Thanks in advance, Sobha Tag: how to show more than column value in combo box Tag: 332384
  - 3
    - ASP.Net Hi, I want to open powerpoint presentation file and then want to display all slides of that presentation on my form. Or can i open slidesorterview using ASP.Net? Thank You, Sonali *** Sent via Developersdex http://www.developersdex.com *** Tag: how to show more than column value in combo box Tag: 332382
  - 4
    - treeview event I have a asp.net treeview inside an updatepanel and I need to capture the right mouse click event. I have a context menu that will become visible on the right mouse click and I need to know what node was right clicked - can anyone give an example ? Regards Nicolai Busekist Tag: how to show more than column value in combo box Tag: 332373
  - 5
    - Turn locahost into com Is it possible (for testing purposes) turn a locahost into somename.com? Thanks Tag: how to show more than column value in combo box Tag: 332368
  - 6
    - Push server Can I create a push server using ASP technology? Thanks Tag: how to show more than column value in combo box Tag: 332364
  - 7
    - Sharing Login Credentials in ASP Hi All We have two applications say A and B and both are deployed on different servers. If user has to access B application then user has to login in A application and then user will be redirected to B. It means sharing session or cookies between two application. How can we achieve that? One way I know is storing session details in db and retrieving those details from DB. Can some body suggest a better approach? Thanks in advance Rehan Mustafa Khan Tag: how to show more than column value in combo box Tag: 332360
  - 8
    - Writing to a asp text field I hope I can explain this. I have an asp form that uploads files from the user computer to a server. I want to save some data to some hidden text controls while some of the asp code is running. However, I can't seem to figure out how to referece the control. I tried using document.formname.controlname.value but I get an error that document doesn't exist. How do I reference a control from asp? Gary Tag: how to show more than column value in combo box Tag: 332359
  - 9
    - Simulate form post from Server Side Hi, How do I simulate this from the server side: <form name="SearchForm" method="POST" id="SearchForm" action="http://SOMEURL/Search.ASP?Parm1=1&Parm2=2"> I have generally been posting data using: Set xml = Server.CreateObject("Microsoft.XMLHTTP") xml.Open "POST","http://SOMEURL/Search.asp?" & strParmList, False xml.Send The above is fine for passing URL parameters, but I need to simulate it coming from a form which has a name. How do I pass the form name which is used at the posted URL? Help! Tag: how to show more than column value in combo box Tag: 332349
  - 10
    - Session bug Hello I have a problem with running classic asp on a windows 2003 server. For some reason it doesnt remove the sessions. I reload page and it removes some, reload again and it removes a few more, very odd... Any ideas? :S im clueless For each key In Session.Contents() If instr(key, "Question") >0 Then Session.Contents.Remove(key) Response.Write(key & ":" & Session(key) & "<br>") End If Next Tag: how to show more than column value in combo box Tag: 332344
  - 11
    - ATTN: Bob Barrows - Execute Stored Procedure question Bob pointed me in the right direction yesterday with his response to my question "Operation is not allowed when the object is closed with Insert Stored Procedure", but now I am having problems with his suggestion, In that thread, Bob says, "Actually, this technique is leaving you vulnerable to hackers using sql injection. Part of the reason for using stored procedures with parameters is so you don't have to resort to dynamic sql to execute them. Here is how I would run this procedure: conn.InsertTask "",varTaskID, varDescription,varAssignedTo" I have edited the other SP's on the page, and am now getting the following error, Parameter object is improperly defined. Inconsistent or incomplete information was provided. I am unable to find documentation that cites this example, so I figured I would come back here and see what advice I can get. Thanks, Drew Tag: how to show more than column value in combo box Tag: 332343
  - 12
    - How to Handle Many Page Links in a Search? Search results on my site started to show a large number of page links. I never had to deal with it before but it is time now. I am trying to come up with a good logic / idea how to display a large number of page links without showing all of them at once. For example, if user is searching for "pets" and gets 50 pages back, I want to show 10-20 page links and hide the rest. Also, the closer user gets to the last visible pages, the more hidden page links become visible. Something like Google does... If somebody worked with it before, could you share with ideas, or suggestions, or good examples to look at? Is there a standard way to implement this, perhaps? Thanks. Tag: how to show more than column value in combo box Tag: 332340
  - 13
    - Cannot pass session variable Dear all, I have a session variable session("loginid) which can be passed from A.asp to B.asp. Then In B.asp I have a hyperlink to C.asp e.g. < A href..C.asp>. The session variable cannot be passed to C.asp. The session variable is empty. What can I do to debug this problem? Thanks Tag: how to show more than column value in combo box Tag: 332337
  - 14
    - link for sql server group HI any body can give me a link for sql server group. Thanks in advance Tag: how to show more than column value in combo box Tag: 332334
  - 15
    - program for delete file online in asp dear sir/madam HI can any body give me a program for delete a online file in asp. Actually I have created a program for mail attachment. For attaching the file first of all I have to upload the file in a directory but after sending attach file the file should be remove from directory. So please give me a program or give me a perfect link. Thanks in advance vinod Tag: how to show more than column value in combo box Tag: 332332
  - 16
    - HELP! -- previous page in VB and ASP 3.0 Hello all, I'm writing you because I have a question for you all: how can I capture the previous page from an ASP file? I need to add the URL (with parameters if possible) of the previous page to a table in SQL Server. For example: the page that captures the info is anydomain.com/asppage.asp and if the previous page in the browser history is otherdomain.com/otherpage.asp, I need to be able to capture that information If possible, of course... Thanks in advance for your help and prompt response, SB-R Tag: how to show more than column value in combo box Tag: 332326
  - 17
    - Operation is not allowed when the object is closed with Insert stored procedure I have some insert stored procedures that I am having problems with. The ASP looks like this, 'Execute SP to insert into Task table sql = "DECLARE @Count int " &_ "DECLARE @TaskID varchar(20) " &_ "DECLARE @Description varchar(255) " &_ "DECLARE @AssignedTo varchar(25) " &_ "EXEC InsertTask " &_ "@Count = ''," &_ "@TaskID = '" & varTaskID & "'," &_ "@Description = '" & varDescription & "'," &_ "@AssignedTo = '" & varAssignedTo & "'" set conn = CreateObject("ADODB.Connection") conn.open MM_WorkOrderTracking_STRING set rs = conn.execute(sql) 'Close recordset and connection rs.close: set rs = nothing conn.close: set conn = nothing On the rs.close: line, it keeps giving me the Operation is not allowed when the object is closed error, which I am assuming is caused by the SP returning "The command(s) completed successfully.". I have SET NO COUNT in my SPs... Is there any way to supress the "The command(s) completed successfully." message? Thanks, Drew Tag: how to show more than column value in combo box Tag: 332323
  - 18
    - UPDATE sql HELP needed Hi, I have a form which displays all records for an ID NUMBER as an edit page, where the user can edit 1 or 2 fields per record listed. I wanted to let the user have the ability to edit any number of records at once, rather than 1 at a time. Once the user makes the changes to the fields, which are numbers, they hit submit. The 2 textfields on the form are called 'mqty' and 'mopen' These are the same for all the records listed. How do I run my update sql, to update the correct records ??? at present I have tried the following without success: ----------------------------------------------------------------- ''''' this holds the number of records that were listed for i = 1 to SESSION("count") uSQL = "UPDATE phoenix_orderlines SET " uSQL = uSQL & " P_metal_qty = '" & request.form("mqty") & "'" uSQL = uSQL & ", P_metal_Open ='" & request.form("mopen") & "' " uSQL = uSQL & " WHERE Phoenix_ID= '" & SESSION("PID") & "';" Set RS = adoDataConn.Execute(uSQL) next ---------------------------------------------------------------------- The above seems to update all records with the same info ? I would appreciate any help you can offer Thanks David Tag: how to show more than column value in combo box Tag: 332322
  - 19
    - Loading an ActiveX DLL is superslow I have developed a Visual Basic 6.0 ActiveX DLL to help to interact with some ASP pages. I have copied the compiled DLL in C:\INETPUB\WWWROOT in my XP Pro machine. After making some configuracion changes for solving the problems with the message: Server object error 'ASP 0178 : 80070005' Server.CreateObject Access Error The call to Server.CreateObject failed while checking permissions. Access is denied to this object. Basically, the changes were: 1. In IIS configuration check "Anonimous access"., Application protection in "Low", Execution permissions, "Commands and executables." 2. Use CACLS to give the user IUSR_<computername> full access to MSVBVM60.DLL Now I see that when I call the ASP page that uses the ActiveX DLL, in Internet Explorer 6, it lasts about 5 minutes before I get the results. After this first time, the response time is as usual. Why this first loading is so slow, and how can I correct it ? Tag: how to show more than column value in combo box Tag: 332315
  - 20
    - Is it possible that OLEDB connection is not available on a PC? Hi All I was trying to setup IIS, ASP and MSDE 2000 Rel A on a machine yesterday and my usual SQL server OLEDB dsn-less connection string would not work on this machine. I know it's down to this, as I used a tool called QTADO to setup dummy data in the db and I had to use an ODBC dsn-less connection to connect to the db. I couldn't use the program's default OLE DB method. The machine was WinXP Pro SP2 (might have been SP1), but I thought the OLE DB thingy came as standard on this OS. I didn't have chance to try the standard SQL ODBC connection string, will do this on Wed, but I'm sure it will work. Any ideas why the OLE DB wouldn't? Just kept getting General Network error on Connection (read). Thanks Tag: how to show more than column value in combo box Tag: 332311
  - 21
    - XP update added asp, MSXML and other things, and I need to about t Hello, A few months ago, when I did an update from the windows update, a few of the 'necessary' updates had this like: microsoft net framework, MSXML, iis, asp. What are they and are they really necessary? There are a few more weird things that I have never seen previously, and if they really are not necessary, I would really like to remove them, if possible. Thank you so much! Puff Tag: how to show more than column value in combo box Tag: 332309
  - 22
    - CDOsys asp mail script problems Trying to use cdosys mail, but this is giving me an "no such object" error. the hosting company is not much help, but their list of components offered does include cdosys mail: <form method="post" action="cdosys-godaddy.asp"><p class="bodymd- wh">Your Name: <input type="text" name="uname" id="uname"> <br>City: <input type="text" name="city" id="city"> <br>State: <input type="text" name="state" id="state"> <br> Your Email: <input type="text" name="EMail" id="Email"> <br><br> <input type="submit" name="btnSubmit" class="inputSubmit" value="Submit"> </form> cdosys-godaddy.asp: <% dim strEmail,struname,strcity,strstate strEMail = Request("email") struname = Request("uname") strcity = Request("city") strstate = Request("state") Dim objMail 'Create the mail object Set objMail = Server.CreateObject("CDO.Message") 'Set key properties objMail.From = mailer@lasvegasunions.info objMail.To = strEMail objMail.Subject= "Insert here your subject text" objMail.TextBody = "Insert here your plain body text" 'Send the email objMail.Send 'Clean-up mail object Set objMail = Nothing %> ??? Ed Tag: how to show more than column value in combo box Tag: 332298
  - 23
    - file upload HI can any body give me a perfect link or program for file uploading program. Actually i have to write a program for mail attachment. And for attaching mail I have to give the virtual path of the attachment file and it is possible only when file will be upload within a directory that is under virtual directory from physical path. Thanks in Advance Tag: how to show more than column value in combo box Tag: 332290
  - 24
    - YO Hi .It is me helen what are you doing. Tag: how to show more than column value in combo box Tag: 332288
  - 25
    - Response.Write Date() problems I'm trying to display a weekly calendar with the month and year on top and the current date in an alternate color, but nothing prints out on my test page when viewed in IE7. Is there something fundamentally wrong with my code, is it my browser, or does this not show up when displayed on my PC? Here is all of the code (nice and small): <%@ Language="VBSCRIPT"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <% Dim i As Integer Response.Write("<table><tr><td class=""mmyy"">start1" & Month(Date()) & " " & Year(Date()) & "end1</td></tr><tr>") For i = 1 To 7 Response.Write("<td class=""" & ((i=WeekDay(Date())?"day":"reg") & """>" & Day(Date()) & "</td>") Next i Response.Write("</tr></table>") %> <html> <head> <title>Weekly Calendar</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <style type="text/css"> td { background-color:Black; height:24px; width:24px; font-size: 12pt; color:Red; } td.mmyy { background-color:Silver; height:24px; width:24px; } td.day { background-color:Yellow; height:24px; width:24px; } td.reg { color:White; } </style> </head> <body> <table> <tr><td class="mmyy" colspan="7">start2<% Response.Write(Month(Date()) & " " & Year(Date())) %>end2</td></tr> <tr> <% Dim i As Integer For i = 1 To 7 Response.Write("<td class=""") If (i = WeekDay(Date())) Then Response.Write("day") Else Response.Write("reg") End If Response.Write(""">" & Day(Date()) & "</td>") Next %> </tr> </table> <hr /> <table> <tr><td class="mmyy" colspan="7">start3<% Response.Write(Month(Date()) & " " & Year(Date())) %>end3</td></tr> <tr> <% Dim i As Integer For i = 1 To 7 Response.Write("<td class=""" & ((i=WeekDay(Date())?"day":"reg") & """>" & Day(Date()) & "</td>") Next %> </tr> </table> </body> </html> Tag: how to show more than column value in combo box Tag: 332279

dear sir/madam
I have a problem . I have a table of field name ,roll_name, age
I have to show name and roll_number in combo box list. please help me
i m using it
<select name=id1>
<option value="<rs(0)>"><%=rs(0)%><%=rs(1)%></option>
please correct this syntex

Top

Re: how to show more than column value in combo box by PW

PW
Mon Oct 08 05:50:33 PDT 2007

<vinodkus@gmail.com> wrote in message
news:1191833793.141917.251460@57g2000hsv.googlegroups.com...
> dear sir/madam
> I have a problem . I have a table of field name ,roll_name, age
> I have to show name and roll_number in combo box list. please help me
> i m using it
> <select name=id1>
> <option value="<rs(0)>"><%=rs(0)%><%=rs(1)%></option>
> please correct this syntex
>

I always do something like this when I want to display more than 1 column of
data ...

myOption = rs1("ESCI") & " | " & rs1("ESCN")

Top

Re: how to show more than column value in combo box by vinodkus

vinodkus
Mon Oct 08 22:25:08 PDT 2007

PW wrote:

> <vinodkus@gmail.com> wrote in message
> news:1191833793.141917.251460@57g2000hsv.googlegroups.com...
> > dear sir/madam
> > I have a problem . I have a table of field name ,roll_name, age
> > I have to show name and roll_number in combo box list. please help me
> > i m using it
> > <select name=id1>
> > <option value="<rs(0)>"><%=rs(0)%><%=rs(1)%></option>
> > please correct this syntex
> >
>
>
> I always do something like this when I want to display more than 1 column of
> data ...
>
> myOption = rs1("ESCI") & " | " & rs1("ESCN")

Many - many thanks sir

Top