Sort and list by month

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
    - Showing date as May 10 2006 not 05/10/2006 How do I get dates stored in Access to show on asp page as May 10 2006, or even better May 10th 2006? Is there a special format I should store the date as? Have tried various formats, long/short, but keep getting it to show up as 05/10/2006. Any asp code I can slap in there to fix this before it drives me nuts? I have no control over the web server. Torbjorn Tag: Sort and list by month Tag: 321836
  - 2
    - formatcurrency() places $ after number??? Does anyone know how to correct or why formatcurrency() places the dollar sign after the number? thanks LJB Tag: Sort and list by month Tag: 321832
  - 3
    - Request.Form 'and' cdo.message USING IIS 5.1, and Windows XP pro, the following form works on my system, and I can use as many form elements as I wish, as long as all form elements have the same name: "words", in this example. Help -- why can`t I give each form element a different name? Any suggestions will be gratefully appreciated. Also,See example at very bottom of something that once worked on a remote server, but doesn't on IIS 5.1, windows xp pro <%@LANGUAGE="VBSCRIPT"%> <% Dim MyMail Set MyMail = Server.CreateObject("CDO.Message") MyMail.TextBody = Request.Form("words") MyMail.From = "postmaster@localhost" MyMail.To = "postmaster@localhost" MyMail.Subject = "CDOSYS for Windows 2000/XP" MyMail.Send() Set MyMail = Nothing %> <HTML> <FORM NAME="TextBody" METHOD="post" ACTION="gusto44444444.asp"> <P><BR> <input type="text" NAME= "words" ID="words" COLS="28" ROWS="1"> Name <br> <input type="text" NAME= "words" ID="words" COLS="28" ROWS="1"> <SPAN CLASS="book_antigua">E-Mail</SPAN><BR CLEAR="all"> <input type="text" name= "words" id="words" cols="28" rows="1"> Phone</P> <BR> <TEXTAREA NAME = "words" ID="words" COLS="18" ROWS="2" wrap="VIRTUAL"></TEXTAREA> <SPAN CLASS="book_antigua">Write Here </SPAN><BR CLEAR="all"> <P> <INPUT TYPE="submit" NAME="Submit" VALUE="Submit, e-mail required" ALIGN="DEFAULT"> <input type="reset" name="Reset" value="Reset"> </P> <P> </P> <P> </P> </FORM> <% dim words words=Request.Form("words") If words<>"" Then Response.Write("Thanks " & words & "!<br />") Response.Write("We'll respond soon") End If %> EXAMPLE AT BOTTOM -- WORKED IN PAST BUT NOT NOW Dim myMail Set myMail = Server.CreateObject("CDONTS.NewMail") Request.Form("email1") Request.Form("name") Request.Form("phone") Request.Form("words") Tag: Sort and list by month Tag: 321822
  - 4
    - HTML Tab pages I ahve an asp page which has many controls. I have identified that I can arrange then into different tab pages. are there any samples of the tab pages in ASP which can be cross browser. Simple HTML/JavaScript way will be fine. We want to avoid the third party tab controls. Thanks Tag: Sort and list by month Tag: 321821
  - 5
    - wscript.shell error People; i'm from argentina so , sorry, but my english isn´t good... Now, the question is; I'm trying to run a *.bat program on an ASP page, with the wsh script, but i can´t do it... because i obtain an error code (5 access denied) I let you the code that i´m using, so you can help me Dim wshell, proc set wshell = server.createobject("wscript.shell") prg="%comspec% /c net stop dns" set proc = wshell.exec(prg) Do While proc.Status < 1 Loop Response.Write prg & "<br>" Response.Write proc.StdOut.ReadAll & "<br>" Response.Write proc.stderr.readAll & "<br>" set wshell = nothing .... I tried besides, the "run" methon instead of "exec", but the result is the same... so ... help!!! I have gave permissons (total control) to IWAM and IUSR users on the page folder, and on cmd.exe program and net.exe program; but there isn´t case, it doesn´t work... Thanks for your suggestions; and sorry about my english... If you don´t understand my , let me knot that, and i try to explain better... Ferg Tag: Sort and list by month Tag: 321818
  - 6
    - Session variables are not getting initialized in global.asa file I have initialized some session variables in Global.asa for our web application. But these session variables are returning null values; it is was working fine before; Recently we have rebuild our servers. Please let me know if anyone of you have some idea? Tag: Sort and list by month Tag: 321815
  - 7
    - Explorer waiting indefinitely for IIS response Strange and curious problem I'm experiencing. I implemeted a web site asp solution IIS 5.0. The site performe long calculations. What's happening is the following: if I connect through a ADSL connection I don't have problems, the browser (IE 6.0) wait also for 20/30 minutes and then receive correctly the response from the IIS server. If I connect through a dial-up connection, if the calculations duration is more that 10/15 minutes, than the browser wait undefinitely, without any signal, and doesn't receive the response from the server, although the calculations ended correcly. The browser didn't freeze or crash, simply wait forever! I've tried everything: I checked the "current connections" counter of performance monitor on the server host running IIS. But it seems that the connection isn't lost. I checked with a sniffer TCP/IP packets, and I noticed nothing strange, apart that the response was not being sent/received. Anyone experiencing a similar problem? Any suggestion, or idea to solve the problem? Thank's a lot for your help. Andrea Tirabosco Tag: Sort and list by month Tag: 321810
  - 8
    - data sending i used a check box in a loop: <input type="checkbox" name="Inv" id="Inv" value="<%= rstMain("TR_ID") %>"> n transfered the value to the next page...wats the best way to transfer the data to a 3rd page Tag: Sort and list by month Tag: 321809
  - 9
    - Includes I have an asp page. Now I know this is sortof OT, but I am not sure of the forum to get an answer. I have an include on this asp page  now, it gives me this error: File attribute '\forum\includes\consts-inc.asp' cannot start with forward slash or back slash. i can't use .. either, because it gives me this error:The Include file '..\forum\includes\consts-inc.asp' cannot contain '..' to indicate the parent directory. I tried with the slashes going / and \ if i use this:  i get this: The include file 'forum/includes/consts-inc.asp' was not found. for some information. i the file that gives the error is in the includes folder, which is in the root web. the forum folder is also in the root web. so i am in folder unthe root, and trying to include a file from another folder under the root. how can i do this?? thanks in advance Jeff Tag: Sort and list by month Tag: 321806
  - 10
    - Problems with Access I get this error: ------------------------------------------------------- ADODB.Connection error '800a0e7a' Provider cannot be found. It may not be properly installed. /inc/DBconnect.asp, line 6 ------------------------------------------------------- I have just set up a new server, Win 2003 Std x64 bit It seems like the driver for connecting to the database does not work on x64 bit!?! Is there any workarounds on this, or do I have to get myself a new Win edition? Best regards, Christopher Brandsdal Tag: Sort and list by month Tag: 321795
  - 11
    - CDOSYS help needed hi i'm new to ASP and have to deal with some email scripting at the very start.I've collected some script pieces from a variaty of tutorial pages but haven't been able to send any mails yet. I'm pasting the latest version of the code: <% Dim sMsg Dim sTo Dim sFrom Dim sSubject Dim sTextBody sTo = "test@blabla.com" sFrom = "crush@bonbon.com" sSubject = "Insert here your subject text" sTextBody = "Insert here your plain body text" Dim objMail, oMailConfig 'Create the mail object Set objMail = Server.CreateObject("CDO.Message") Set oMailConfig = Server.CreateObject ("CDO.Configuration") oMailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "localhost" oMailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25 oMailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 oMailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = 60 oMailConfig.Fields.Update Set objMail.Configuration = oMailConfig 'Set key properties objMail.From = sFrom objMail.To = sTo objMail.Subject= sSubject objMail.TextBody = sTextBody 'Send the email objMail.Send 'Clean-up mail object Set objMail = Nothing %> As I said before i'm very new to ASP so i might be even missing a very basic stuff. I've tried the code without the configuration part as well but nothing has changed. Actually it seems that the problem is about objMail.Send part. When I comment it the script runs fine but when I activate it the page is not accessible (that's another problem that i've come up with ASP. There's no error messages but a page error. Should I catch an exception to see what's wrong or do I need to check some other stuff?) I wasn't sure about the VB syntax style so I also tried objMail.Send() My script is running on IIS 6 server so I don't think there's a support problem with CDOSYS Any help and/or advise is appreciated muchly Thanks :) Tag: Sort and list by month Tag: 321791
  - 12
    - Storing Session State HI All Looking for some advice on session in ASP. We are running windows 2000 with dot.net framework 1.1 on IIS 5.1 This is an NLB architecture with the session being stored in an SQL DB. We have been coding and deploying using ASP.NET with no problems however the 'powers that be' have recently bought an online booking application which has been coded using classic asp. We have set the session location in the machin config of the framework stating mode="SQLServer". Will this ASP use this or continue to store the code InProc? Thanks Michael D Tag: Sort and list by month Tag: 321783
  - 13
    - Simultaneous fill out and display of a form I would like to make a form that multiple people can access and update at same time with their web browser. The form would have fields that each would fill in and I would like for all to see what the others fill in. Is there an automatic way or would they have to refresh? Any books, etc. to help would be great. Thank you. Tag: Sort and list by month Tag: 321782
  - 14
    - Partial downloads Has anyone got any experience with getting partial downloads working with ASPX pages? I am unable to .AddHeader("Accept-Range", "bytes") - ASP.NET eats the header, and refuses to transmit it. I am trying to enable partial/resumable downloads for PDF/DOC content that I am streaming up from a SQL image column. Any thoughts? -- Regards, Fil. Tag: Sort and list by month Tag: 321778
  - 15
    - Checkbox Issues Hello, I have the following problem with the checkbox. The issue seems to be that when I click on the following checkbox: <input type= checkbox id="checkbox1" name="<%response.Write "recount" & CoCount%>" value="<%=idx%>" > with the following values below: <input type=hidden name="recount" value=<%=idx%>> <input type=hidden name="contactname" value="<%=oDodgeCos3("f_person") %>" id=hidden1> <input type=hidden name="drnum" value="<%=request("dr_num")%>" id=hidden2> <input type=hidden name="companyname" value="<%=oDodgeCos3("f_comp_name")%>" id = hidden3> <input type=hidden name="address" value="<%=oDodgeCos3("f_addr1")%>" id=hidden4> <input type=hidden name="city" value="<%=oDodgeCos3("f_city")%>" id=hidden5> <input type=hidden name="state" value="<%=oDodgeCos3("f_state")%>" id=hidden6> <input type=hidden name="zip" value="<%=oDodgeCos3("f_zip")%>" id=hidden7> <input type=hidden name="phone" value="<%=oDodgeCos3("f_phone")%>" id=hidden8> <input type=hidden name="fax" value="<%=oDodgeCos3("f_fax_nbr")%>" id=hidden9> The problem is that when I click on the box, it seems that the all values is being passed over to the next page. How would I have the values passed over based upon the checkbox that the user select? Thanks! Kevin Davis Tag: Sort and list by month Tag: 321776
  - 16
    - MS Access + ASP + ADO + OpenSchema + error - Unspecified Error I am using MSAccess 2003 as my DB, ASP page my front end. My access file is in the temp folder which ahs IUSR_Machine permissions. My asp page works fine, connects to DB and retrieves what I want. Now, when I open my db file in Microsoft Access in Exclusive mode my ASP page doest establish a connection which is correct as exclusive open locks the files and prevents further connections. Upto here no problem. Now when I close that opened Microsoft Access instance, my web page resumes working. If I refresh it, it works. The third time I refresh the page I get "Unspecified Error". Again if I refresh it works and again if I refresh I get "Unspecified error" when I debugged it fails at connection open. Here is my code snippet.. if strConnString <> "" then objConn.Mode = 3 objConn.ConnectionTimeout = 30 objConn.CursorLocation = 3 'adUseClient objConn.open strConnString set oTmpRs.ActiveConnection = objConn Set oTmpRs = objConn.OpenSchema(4, Array(Empty, Empty, tmpStrTable,Empty)) Set oTmpRs.ActiveConnection = Nothing set rsColumns = oTmpRs.Clone set oTmpRs = nothing objConn.Close end if set objConn = nothing Can anybody tell me what's wrong here..what could be the root cause of this problem.. I tried almost all solutions I know and found in search engines..but not yet solved this issue.. thanks Tag: Sort and list by month Tag: 321775
  - 17
    - Date Prob In Sa the date format is dd/mm/yy. in sql server the format the format is mm/dd/yy. What code can be used to chnge the format to the SA date format eithout chnging sql servers regional settings? Tag: Sort and list by month Tag: 321771
  - 18
    - Connection Via ADO to AS400 Hi Can anyone please help as I am going nuts This script fails and I cannot get it to work in any fashion. I have the following simple code <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <html> <head> </head> <body> <% Dim Parent Dim BomSet Dim SelectString Dim conn Set conn = Server.CreateObject ("ADODB.Connection") conn.Open "Provider = Mapics; User ID = XXXXXX ;Password = XXXXXX;" Parent = "NEW3WTFB3-1" Set BomSet = Server.CreateObject("ADODB.Recordset") SelectString = "Select PINBR, USRS1, CINBR, QTYPR From AMFLIBA.PStruc WHERE Pinbr = "'" & Parent & "'" With BomSet .CursorType = 0 .CursorLocation = 2 .LockType = 1 Open SelectString End With While not BomSet.Eof Response.Write Parent & " - " & BomSet.Fields.Item("Cinbr").Value BomSet.MoveNext() Wend BomSet.Close Conn.Close Set Conn = Nothing %> </body> </html> ------------------------------------------------------------------- The error displayed at run time is ADODB.Connection error '800a0e7a' Provider cannot be found. It may not be properly installed. /DundeeMIS/BOMXplosion.asp, line 12 ------------------------------------------------------------------- The actual line is conn.Open "Provider = Mapics; User ID = XXXXXX ;Password = XXXXXX;" The provider Maipcs is one we use for other applications ie using Delphi, Lotusscript etc I have also tried providing the connection data directly (dsnless connection) Data Source = "xxx.xxx.xxx.xxx" Provider = "IBMDA400.DataSource.1" Password = "XXXXXX" User ID = "XXXXXX" Protection Level = None Initial Catalog = "MAPMODF" Transport Product = "Client Access" SSL = "DEFAULT" Force Translate = 65535 Cursor Sensitivity = 3 but that does not work either Anyone have any ideas? Thanks in advance Iain Tag: Sort and list by month Tag: 321770
  - 19
    - Asp and script Iv gt an asp page that has two buttons on it. one button uses a form and the other uses scrpit to go to the next page. I need both buttons to submit data. Iv usesd this on page1: public varform varform = "" '"Activity_Rpt_Inv4.asp?klient=response.write(request.querystring("klient"))&adviseur=response.write( session("Pers_ID"))&ActId=response.write(request.querystring("ActId"))" <script type="text/vbscript" language="VBScript" event="onClick" for="btnPrint"> InvDisp.action = "Activity_Rpt_Inv5.asp?klient=<%= request.querystring("klient") %>&adviseur=<%= session("Pers_ID") %>&ActId=<%= request.querystring("ActId") %>" InvDisp.submit </script> <form action=<%= varform %> method="post" name="InvDisp"> But they nt working. The code used to go to a page using the scrpit works in the sense that it goes to the pasge,bt the data is nt transferred. please help Tag: Sort and list by month Tag: 321766
  - 20
    - FREE Work At Home Job Finder FREE Work At Home Job Finder Find the perfect work at home job for you using our FREE Work at home Job Finder! Get matched with a Home Based Job or Business Plan that suits your needs and skills. Simply visit our website and fill in the short form to receive your Job Match Details for FREE Today! http://www.typeinternational.com/idevaffiliate/idevaffiliate.php?id=3586_65_3_99 Tag: Sort and list by month Tag: 321765
  - 21
    - error insert into access from asp Scenario: Error: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. I have xp professional with iis6. the folder is under wwwroot with asp file and mdb file. Is there something with permission and LDB? I have try everything with permission. Help / tw Tag: Sort and list by month Tag: 321762
  - 22
    - Host online or Host Offline? Hi, I would like help to get started on an idea. I have prior knowledge of how to do this so please be gentle with me as I am a complete beginner when it comes to ASP. I have a website hosted by an internet host and want to add a PHPBB2 forum hosted on my own server. What I would like to introduce to my website is something like this The forum is online (with a little green image) OR The forum is OFFLINE (with a little red image) I have no idea how to or where to get started on this. Can anyone offer a sample script please? Regards Malcolm Tag: Sort and list by month Tag: 321757
  - 23
    - Severside Hey all!!! I have a question about web forms. I've downloaded the MS Frontpage Personal Web Site Template and uploaded it to Cox's Personal Webspace Apache' servers. I've run the "Verify Test" for FP Extentions, and they are working properly. The 'Action" attribute is pointing to the vti-bin (is not typed correctly "here") and to finish the path -it points to the /shtml.exe/feedback.htm, or the /shtml.exe/html. When a visitor presses the submit button it appears that the process is uploading the info, but when I check to find out if it has written to the default form_results.txt, ot the feedback.txt file, it appears none. "Quite frankly -I am perplexed." I do wish to have MS FP working in its respective true form. Thanks for your comments is advance, thanks again. Tag: Sort and list by month Tag: 321754
  - 24
    - MS Access + ASP + ADO + OpenSchema + error - Unspecified Error I am using MSAccess 2003 as my DB, ASP page my front end. My access file is in the temp folder which ahs IUSR_Machine permissions. My asp page works fine, connects to DB and retrieves what I want. Now, when I open my db file in Microsoft Access in Exclusive mode my ASP page doest establish a connection which is correct as exclusive open locks the files and prevents further connections. Upto here no problem. Now when I close that opened Microsoft Access instance, my web page resumes working. If I refresh it, it works. The third time I refresh the page I get "Unspecified Error". Again if I refresh it works and again if I refresh I get "Unspecified error" when I debugged it fails at connection open. Here is my code snippet.. if strConnString <> "" then objConn.Mode = 3 objConn.ConnectionTimeout = 30 objConn.CursorLocation = 3 'adUseClient objConn.open strConnString set oTmpRs.ActiveConnection = objConn Set oTmpRs = objConn.OpenSchema(4, Array(Empty, Empty, tmpStrTable, Empty)) Set oTmpRs.ActiveConnection = Nothing set rsColumns = oTmpRs.Clone set oTmpRs = nothing objConn.Close end if set objConn = nothing Can anybody tell me what's wrong here..what could be the root cause of this problem.. I tried almost all solutions I know and found in search engines..but not yet solved this issue.. thanks Tag: Sort and list by month Tag: 321745
  - 25
    - Session time out/log out in .asp with windows authentication? Hello. Is it possible to have a session expire/time out or log out for a windows regular domain user logged into an .asp application? Thanks in advance. J Tag: Sort and list by month Tag: 321735
- Next
  - 1
    - Change domain user password? Hello. I apologize if this isn't the appropriate group for this question but I was wondering if it's possible to allow regular windows domain users to change their passwords through an .asp page? I'm trying to figure out the best way to handle domain users to log into an .asp application tied with SQL Server 2000 on the back end since I keep reading that windows authentication is better practice to log into SQL Server. Thanks in advance. J Tag: Sort and list by month Tag: 321732
  - 2
    - Invalid Procedure Call or Arguement I am receiving the following error from the simple script below. This works fine from a .NET form but when I access the dll from a Classic ASP page it fails. Microsoft VBScript runtime error '800a0005' Invalid procedure call or argument: 'GetGroups' Dim oUser 'As mnaSecurityUser Dim oDBAdapter 'As mnasecurityDBAdapter Dim group 'As mnasecurityGroup Set oUser = Server.CreateObject("mnaSecurityControl.mnasecurityUser") Set oDBAdapter = Server.CreateObject("mnaSecurityControl.mnasecurityDBAdapter") Set oUser = oDBAdapter.GetUser("mamarsha") 'This works ok Response.Write "'" & oUser.FirstName & "'" 'This line returns the error Set oUser.Groups = oDBAdapter.GetGroups(oUser) For each group in oUser.Groups Response.Write "'" & group.name & "'" Next GetGroups is a method that accepts an mnasecurityUser object as a parameter. Groups (in oUser.Groups) is a collection object property of the mnasecurityUser object. Tag: Sort and list by month Tag: 321729
  - 3
    - save and load Adobe PDF xml I have found that with Adobe LifeCycle Design 7.x, you can save a dynamic PDF that will send xml to the browser when a button is clicked. I'm able to pull the data I need from the xml I'm sent, but I'm not sure how ( after saving this xml to the database ) I can recreate the PDF in a later request. Is there a transform that someone can point me to that will transform this XML to a PDF? Any ideas how to do this??? I've posted this question to an Adobe newsgroup, but since Adobe tends to use Javascript instead of .net for everything I'm not sure if I'll get an answer from them. Any help would be greatly appreciated! Thanks! Tag: Sort and list by month Tag: 321722
  - 4
    - Script timed out Message added to Binary File End Hi Friends, I have code that will "BinaryWrite" a EXE file of 20mb to client using the ADO Stream. After the download the EXE file works fine without any problem. When I verified the EXE that gets downloaded to client machine that EXE has the below text added to the bottom: --------------------------------------------- <font face="Arial" size=2>.<p>Active Server Pages</font> <font face="Arial" size=2>error 'ASP 0113'</font>.<p>.<font face="Arial" size=2>Script timed out</font>.<p>.<font face="Arial" size=2>/Roctek/ProcessDownload.asp</font>.<p>.<font face="Arial" size=2>The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools..</font> ---------------------------------------------- So I can see that it is a Script TimeOut Error. So can you please guide me where the problem is comming and how can I rectify this. (Including the ASP code that BinaryWrite the file) --------------------------------------------- Function DownloadFile(strFilename) dim stFile Response.Buffer = True Response.Clear Set stFile = Server.CreateObject("ADODB.Stream") stFile.Open stFile.Type = 1 'Set as BINARY On Error Resume Next Set fso = Server.CreateObject("Scripting.FileSystemObject") if not fso.FileExists(strFilename) then Response.Write("<h1>Requested file does not exists! Please contact Roctek Support.</h1><P>") Response.End end if Set fFile = fso.GetFile(strFilename) iFileLength = fFile.Size stFile.LoadFromFile(strFilename) Response.AddHeader "Content-Disposition", "attachment; filename=" & fFile.Name Response.AddHeader "Content-Length", iFileLength Response.Charset = "UTF-8" Response.ContentType = "application/octet-stream" Response.BinaryWrite stFile.Read Response.Flush Response.Buffer = False Response.Clear Set fso = Nothing Set fFile = Nothing stFile.Close Set stFile = Nothing End Function ----------------------------------------------------------- I am using IIS 5 on Windows 2000 Server. Please guide me to solve the problem Thanks Prabhat Tag: Sort and list by month Tag: 321715
  - 5
    - Close window after binary download Hi All, I have an ASP page that is sent a file location as a parameter. It opens this file, loads the ADODB.Stream object and does a binary write to the page forcing the download dialog to appear. If the user selects "Open", "Save" or "Cancel", the window closes, which is the desired behavior. This all works fine, until I installed Windows XP SP2. The newly created browser window remains open after clicking one of the buttons. I've tried a number of things to get the window to close automagically, but nothing has worked so far. I'm calling the ASP page using window.open() because any error encountered while trying to load the file should display the message to the newly created window. Please see this link (http://www.aspfaq.com/show.asp?id=2161#) for reference. Any help will be greatly appreciated! Thanks, Tag: Sort and list by month Tag: 321707
  - 6
    - breaking a string I usesd this to display info on a page: <% While not rstMain.eof %> <tr> <td><font size="-1"><%= rstMain("Datum") %></font></td>  <td><font size="-1"><%= rstMain("Act") %></font></td> <td><font size="-1"><%= rstMain("Item") %></font></td> <td><font size="-1"><input type="checkbox" name="Inv" id="Inv" value="<%= rstMain("TR_ID") %>"></font></td> </tr> <% rstMain.movenext Wend%> on the next page i want the data from the checkbox.it comes as a string,numerics concatanated with a "," i want to query according to this checkbox n tried this code: For i=1 to (len(request.form("Inv"))) If left(request.form("Inv"),i) = "," Then count = count + 1 End If Next 'For i=1 to count do 'var1=instr(request.form("Inv"),",") 'sql="SELECT * From V_Transaksie Where ID=" & left(request.form("Inv"),var1-1) 'set rstMain = CreateObject("ADODB.Recordset") 'rstMain.Open sql, "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;password=admin@sql;Initial Catalog=GIS;Data Source=172.16.4.180",1,4 All above ASP.Please help Tag: Sort and list by month Tag: 321704
  - 7
    - Server.CreateObject Hi, I try to Use Excel.Application Library on an ASP page like this Server.CreateObject("Excel.Application") i get this error: ASP error '800a01b0' File name or class name not found during Automation operation: On the server is installed Excel 2000 and the OS is Win2K. Can Someone Help me? thanks Tag: Sort and list by month Tag: 321702
  - 8
    - Troubleshoot ASP.NET website Hello, We have a cluster of 5 w2003 servers running an asp.net application talking to a SQL backend. The ASP requests queued frequently gets over 500 and the server will display the "server busy error". The application seems to be riddled with problems. What tools are available to help diagnose where the problem might be? Are there any profiling tools for .net that show request that take longer than x to process? Im not a developer so excuse my ignorance if this is a silly question. Thanks, Richard. Tag: Sort and list by month Tag: 321698
  - 9
    - Get the server name from ASP when accessed by IP address Is there a way to display the server's host name or computer name from ASP when the page was accessed by IP address? I tried dumping all the variables and header information, but when the URL is accessed using the IP address, the variables like SERVER_NAME and HTTP_HOST are sent to the web browser as the IP address. Tag: Sort and list by month Tag: 321695
  - 10
    - Asp.Net V1.1 I need to insall version 1.1 but the download link from Microsoft returns page cannot be found. Does anyone know where I can donwload this from? Thanks Sam Tag: Sort and list by month Tag: 321693
  - 11
    - Cant not upload file to destination location Dear, We have 2 IIS server on win2000. we use the web server for upload file from server1 IIS to server2 IIS. We can connect from IIS1 to IIS2 success but the file unable to upload with below message. Would u help? If FileUpload_TXT.PostedFile.ContentLength = 0 Then Panel_FileInfo.Visible = False Exit Sub Else Panel_FileInfo.Visible = True str_UploadFilePath = GetUploadPath() FileName_LAB.Text = FileUpload_TXT.PostedFile.FileName FileSize_LAB.Text = CStr(FileUpload_TXT.PostedFile.ContentLength) FileType_LAB.Text = FileUpload_TXT.PostedFile.ContentType Dim str_Filename As String = GetUploadPath() Dim FileSplit() As String = Split(FileUpload_TXT.PostedFile.FileName, "\") Dim FileName As String = FileSplit(FileSplit.Length - 1) str_FilePathName = str_UploadFilePath + FileName Dim str_xmlSpName As String str_xmlSpName = Request.QueryString("str_SpName") Response.Write("BEFORE - " & str_FilePathName & "<BR>" & "<BR>") Response.Write("<a href=" & str_FilePathName & ">Name</a>)<BR>") Response.Write("<a href=" & str_UploadFilePath & ">Path</a>)<BR>") FileUpload_TXT.PostedFile.SaveAs(str_FilePathName) <--------------------- Cant not upload file to destination location . Response.Write("END ---- " & str_FilePathName & "<BR>") If File.Exists(str_FilePathName) Then If Request.QueryString("str_BtnKey") = "XLS" Then Read_XLS(str_xmlSpName) Message_LAB.Text = "æ?? å?? ä¸? è¼? æª? æ¡? ã??" Else '-- Read Xml data Read_XML(str_xmlSpName, str_FilePathName) End If Else Panel_FileInfo.Visible = False Message_LAB.Text = "ä¸? è¼? æª? æ¡? å¤± æ??ï¼? è«? é?? å¾© å?? è©¦ã??" End If End If ManyThanks Tag: Sort and list by month Tag: 321676
  - 12
    - pass int to become a variable Hi, Could you please advice, can javascript accept this kind of code? function resone(cnt) { alert("document.all.txt_note"+cnt) // cnt is the textbox index } txt_note are textboxs, ( name= txt_note1, name=txt_note2 .... ) There are buttons be allocated near every textboxs, when the button be pressed, I want to get its text string. and I have other questions: 1. does javascript do auto type conversion? ( int to string ) 2. does it possible to do pass value as variable ex: int boki1 =0; int a =1; printf ("%d", boki & a.toString ); // I sure that is not C or java programming, but I want to sure that is not doable by pass value to become a variable, I knew it should try array, but I saw somebody is try to do this... Best regards, Boki. Tag: Sort and list by month Tag: 321674
  - 13
    - Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype. ADODB.Recordset error '800a0cb3' Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype. I am moving my webserver from NT4 using SQL to win2003 using SQL 2003 I get the above error when my asp page does teh line: Rs.absolutepage = intCurrentPage I tested teh value of intCurrent page and teh value is 1. Any ideas? The .asp Page works perfectly fine on teh old machine. Tag: Sort and list by month Tag: 321673
  - 14
    - something funky I currently have my website on a NT4 box, all pages work fine. I am working on moving it over to a win200k web edition server. I have my connection to my SQL working, copied all the pages to the new machine without making ANY changes to the pages. Now when my .asp page queries the database, it takes forever for it to return any data, and not only does it display incorrectly, it does it without putting anything in any of the tables that the data is suppose to be in. I have the data displayed in a table so it's all nice and neat, but the table is not being written. When I view the source code after the data is returned, it only has the data from the database, no mention of any tables, or the pictures or anything else. Is there something that has to get done so 2003 will write the tables properly?? Tag: Sort and list by month Tag: 321663
  - 15
    - Can't get the variable Hi All, I have many buttons that mapping many textbox, when I click button, I want to show a string that contains button number( and the mapping string ), but it failed. Here is the code: ///////////////////////////////////////////////////////////////////// <%response.write"<input type='button' name='bt_resone"& a &"' value='Save' onclick='resone("&a&")'>"%> function resone(cnt) { alert("document.all.txt_note"+cnt) } //////////////////////////////////////////////// It seems that the component I called is not there... Could you please advice? Thank you so much! Best regards, Boki. Tag: Sort and list by month Tag: 321662
  - 16
    - cdo transport error Hi all i was using cdo object for sending email to a customers. when use win2000 server or windows xp my script works correctly. but not on win2003 server r2. Different thing on my script is i use external smtp server to send my emails. for example, i dont use the iis' virtual smtp server. i assign an another smtp server like smtp.example.com what is the different between environments.. thank you Tag: Sort and list by month Tag: 321660
  - 17
    - Tooltip on Dropdown (Combo Box) Hi! I have posted this since last week but receive no response. I really need this to run on my system. I use ASP (not .NET) for my web applications. I use IE6 SP1 for all my clients. Since title attribute doesn't work on IE6SP1, I cant get the tool tip running. I use tooltip to lessen the dropdown width. Hope you could help me solve my problem. regards, M P Tag: Sort and list by month Tag: 321652
  - 18
    - server.transfer second parameter I read somewhere that server.transfer had a 2nd parameter so control and input values were 'passed' to the transferred to page, but it's giving me an error of wrong number of parameters. I have IIS5, is that the problem? or is it that it's an ASP page (not ASPX) Tag: Sort and list by month Tag: 321648
  - 19
    - How do I do this? I am storing user entered form data from an ASP page in a MSSQL 2000 database. I would like to give my administrators a way to download a tab file with the entries. Is writing an ASP page the best way to do this? And if so, how can I convert database records into a file that will download through the browser? Thanks, Kevin Tag: Sort and list by month Tag: 321644
  - 20
    - newbie Hello, well I made my first asp-project and uploaded it through VWD 2005 Express. I tested the project locally and it works fine. Now I see on my server the page, but only with texts, no labels, no buttons. Where is the bug? My server supports FrontPage. Extensions. I set the free access for the local folder too. Thank you Barbara Tag: Sort and list by month Tag: 321640
  - 21
    - Viewing a Database On a shared hosting account, I've got access to an SQL 2000 database on a remote server. Stats are data size: 12MB, Log Size: 25MB. I set it up five years ago, and, uh, forgot how I set it up... Anyway, I need to be able to view and browse the structure of my SQL 2000 database - and it would be nice to do it with an interface like a Microsoft Access style GUI? I need to be able to see what tables, columns, etc. my db contains. Is there a web-based, or client-based, interface I can use that will allow me to view and browse my SQL 2000 database? (Would it be easier if I had my web host provider convert it to SQL 2005?) Thanks! Bill. Tag: Sort and list by month Tag: 321638
  - 22
    - Active Users I need to display information a list of Active users on a web site. I can do the count using the global.asa but need to display individual information about each "active user" without writing it all to a database and then pulling it out again. Info I need : IP Address - Request.ServerVariables("REMOTE_HOST") The page they are on - Request.ServerVariables("SCRIPT_NAME") the page they were on - Request.ServerVariables("HTTP_REFERER") Can I write this stuff into sessions and call them all out? Thanks ven Tag: Sort and list by month Tag: 321637
  - 23
    - I wan't your help in Inserting and selecting image from DB Hello Every One , I need Help in inserting the user image in my data base. but unfortunatly I don't know how.I'm using asp with sql server. I tried to insert the image and i geuss it worked.for the field in the db in not null and it have this value <Binary> . but when i try to select it in gives me this error "An unhandled data type was encountered". this is my code : To insert the image sql="insert into users_img (user_image,user_id) values ('"&image&"','"&userid&"')" set rs=conn.Execute (sql) to Select the image : sql="select * from users_img where user_id='"&userid&"'" set rs=conn.Execute (sql) Response.ContentType = "image/jpg" Response.BinaryWrite rs("adv_image") Realy Need Your help thanx alot Yours, Maii Ali *** Sent via Developersdex http://www.developersdex.com *** Tag: Sort and list by month Tag: 321635
  - 24
    - FLASH MOVIE WONT PLAY ON SECURE ASP PAGE I have been working with ASP classic on this current project im involved in. Well the problem im facing now is there is a page where a flash movie should play in a particular section on the page but it wont play on the secure pages, on the unsecure pages it plays fine. I had added an Active X work in accordance with the Lawsuit issue but it still wont play. Has any body faced this problem and if so could you point me in the right direction? Thanks Tag: Sort and list by month Tag: 321629
  - 25
    - FLASH MOVIE WONT PLAY ON SECURE ASP PAGE I have been working with ASP classic on this current project im involved in. Well the problem im facing now is there is a page where a flash movie should play in a particular section on the page but it wont play on the secure pages, on the unsecure pages it plays fine. I had added an Active X work in accordance with the Lawsuit issue but it still wont play. Has any body faced this problem and if so could you point me in the right direction? Thanks Tag: Sort and list by month Tag: 321628

This one is related to my previous question.

My (Access) database contains events. I'd like to
sort and list by month and year, like the example
under here.

Any tips on how to do this would be appreciated.

2005
November
Event
Event
Event

2005
December
Event
Event
Event

2006
January
Event
Event
Event

2006
February
Event
Event
Event

Top

Re: Sort and list by month by ferg

ferg
Wed May 10 17:00:20 CDT 2006

Torbjorn ,
if you have a Date field in your d.b. (i.e. EventDate ) you have to
write the next SQL...
SQL = "Select event from TABLE1 group by year(EventDate), month(EventDate)"

Ferg

"Torbjorn Pettersen" <torbjorn@fantafiction.com> escribió en el mensaje
news:1264nspr9ndps19@corp.supernews.com...
> This one is related to my previous question.
>
> My (Access) database contains events. I'd like to
> sort and list by month and year, like the example
> under here.
>
> Any tips on how to do this would be appreciated.
>
> 2005
> November
> Event
> Event
> Event
>
> 2005
> December
> Event
> Event
> Event
>
> 2006
> January
> Event
> Event
> Event
>
> 2006
> February
> Event
> Event
> Event
>

Top