Picking out top three out of database

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
    - Microsoft Word error '800a1528' 'the setting could not be created' I've just migrated a web-based vbscript process to w2k, which uses server- side word to create a new doc from a template and populate it from a form. Now, this was working fine on NT4, but now, when wordapp.options.defaultfilepath(wdUserTemplatesPath) = strpath is called, it throws the above with 'the setting could not be created' I'm assuming its a perms issue, but the iusr account has exe perms on the office folder, and the perms on the template folder are fine. ??? Tag: Picking out top three out of database Tag: 304651
  - 2
    - learning ASP on XP Home Edition My daughter wants to learn ASP but her PC runs XP Home Edition which doesn't allow IIS. Is there any way she can still learn ASP? Tag: Picking out top three out of database Tag: 304649
  - 3
    - How to Q (Resx) This is my Flow: 1. Create New project. 2. Add new item 3. Select "Assembly resource file" and name it "MyRes". 4. In the resx designer click on "Create Schema". 5. In the Schema remove the "Reshader". 6. Add new attribute named Data1 to "data" table. 7. Go Back to "MyRes" and add records. Now all I want is to read the data from the imbedded resx file. If I use the "ResourceManager" or the "ResourceReader" or the "ResXResourceReader" I can read the "value" attribute and not the new "Data1" attibute. I tried to create a Dataset based on the XSD but the dataset is empty without the data. Please help what should I do? Tag: Picking out top three out of database Tag: 304647
  - 4
    - numeric value and string okay.. this should be long.. I made up a table in database with access consists of columns with text type. Some of them I put in data with numeric value and some of them I put in "Unlimited" as the value. Then, I allowed people to insert data but only with conditions. They can insert data if the value they are trying to insert is smaller than the one in the database. For "unlimited" value, they can insert any value. My problem is.... if the limited value in the database is 35, we cant insert data of 40 but we can insert data of 100. It seems that the code only takes the first number to be compared to the value in the database. Can anyone help me to overcome this? here''s part of my code If (diff = 0) OR (diff = 1) Then If (maxunit1 < strnoofunit) OR (maxdoc1 < strnoofdoc) Then rs2.close conn.close set rs2 = nothing set conn = nothing Server.Transfer("maxunit2.asp") End If ElseIf (diff = 2) Then If (maxunit2 < strnoofunit) OR (maxdoc2 < strnoofdoc) Then rs2.close conn.close set rs2 = nothing set conn = nothing Server.Transfer("maxunit2.asp") End If ElseIf (diff = 3) Then If (maxunit3 < strnoofunit) OR (maxdoc3 < strnoofdoc) Then rs2.close conn.close set rs2 = nothing set conn = nothing Server.Transfer("maxunit2.asp") End if ElseIf (diff = 4) Then If (maxunit4 < strnoofunit) OR (maxdoc4 < strnoofdoc) Then rs2.close conn.close set rs2 = nothing set conn = nothing Server.Transfer("maxunit2.asp") End If ElseIf (diff = 5) Then If (maxunit5 < strnoofunit) OR (maxdoc5 < strnoofdoc) Then rs2.close conn.close set rs2 = nothing set conn = nothing Server.Transfer("maxunit2.asp") End If Else If (maxunit6 < strnoofunit) OR (maxdoc6 < strnoofdoc) Then rs2.close conn.close set rs2 = nothing set conn = nothing Server.Transfer("maxunit2.asp") End If End If '' ------------------------------------------------------------------------- '' finish '' ------------------------------------------------------------------------- rs.Open "SELECT * FROM timesheet", conn, 3, 3 ''Add a record rs.AddNew ''Put username and password in record rs("memberid") = Session("memberid") rs("reference_no") = strrefno rs("entry_date") = date() rs("lspid") = Session("lspid") rs("solicitorid") = Session("solid") rs("code") = strcode rs("no_of_unit") = strnoofunit rs("no_of_document") = strnoofdoc rs("note_legalmatter")= strlegalmatter rs("note_entitlement")= strentitle ''Save record rs.Update Thanks guys ----------------------------- This message is posted by http://asp.forumszone.com Tag: Picking out top three out of database Tag: 304641
  - 5
    - How to use MAPI using VB Script? Hi Kindly please give me a sample code to send email by using MAPI control with VB Script. I am planning to use it in my ASP pages on the server side. Thanks Michael Tag: Picking out top three out of database Tag: 304640
  - 6
    - Do I need Dreamweaver or is NET Framework sufficient for good desi Are there things offered by products like Dreamweaver that I need to complement the Net Framework design in Visual Studio? I find that Javascript routines and special graphics are non-existent in Visual Studio. I code most of my html pages manually and use C# for my asp pages. Drop down menus and such I have to rely on third party products. So, will Dreamweaver fill these gaps? Dave Tag: Picking out top three out of database Tag: 304634
  - 7
    - Blank ASP pages. Hello, We use Vignette V5.6 to display our site. In our CMA site, we have a page which has FRAMESET and in one of the frames we call a ASP page. There seems to be some problem that the frame shows the ASP page is blank. When we restart the IIS it works fine. But after some time it again shows the blank. If we get one blank page, all the asp pages under the same virtual directory, called in the Frame shows blank. FYI. The Vignette template which contains the frame is marked for NO caching & For itnernal use only. Any help on this front would be greatly appreciated. Thanks, Chandra Tag: Picking out top three out of database Tag: 304628
  - 8
    - Locking all text boxes in asp page Hi, I need advise as to how to do the following. In a asp page, the user can input information via text boxes which goes to a database. If users click a check box named final and submit the asp page, then next time they come, they will not be able to change any information. This means, I would like to grey out the text boxes so that users are unable to edit the values in the text boxes. The only way to allow edit is via adminstrator's intervention. Any article, asvise, help to handle the concept and approach the problem is appreciated. Thanks. Tag: Picking out top three out of database Tag: 304624
  - 9
    - runat="server" Hi, I have a BoundColumn in a DataGrid: <asp:BoundColumn DataField="lastname" SortExpression="lastname" ReadOnly="True" HeaderText="Last Name"></asp:BoundColumn> Column is sorted. I am wondering why this code is working properly as there is missing the statement runat="server". When I click on a header of the column, the grid posts back to the server and sorting is done. Why does it work without runat="server"? In my books is always used runat=â??serverâ?? expression. Is it a preferable way? Thanks, Lubomir Tag: Picking out top three out of database Tag: 304620
  - 10
    - How To? How can I display the entry point URL Link after calling another .ASP?p=param Explain. assuming you are here www.mydomain.com and there's a login request within the login.asp there is a Method="POST" action=login.asp?p=loginid" I do not want the browser show the following www.mydomain.com/login.asp?p=param on the HTTP:// address bar just show the default URL www.mydomain.com Can this be possible.? TIA Tag: Picking out top three out of database Tag: 304617
  - 11
    - session vars Is possible to terminate all session variable created without closing the browser I do not want users to click on BACK button on browser or paste the url link in the http:// and shows the record displayed after logout. This works fine if users close the Browser. Tag: Picking out top three out of database Tag: 304614
  - 12
    - Creating Excel like form in asp application Hi, Currently, our clients use excel spreadsheet to give details of expense for a particular grant. e.g. expenseid type amount date ............. ..... ......... ...... ............. ..... ......... ...... ............. ..... ......... ...... ............. ..... ......... ...... This spreadsheet can run into 8-9 pages. I am working on a web application where the above process need to be converted into asp page allowing to add or delete detail expense line item. I would like to know if there is any knowledge base article or concept that will help me to build the above functionality in an asp page. Thanks in advance. Tag: Picking out top three out of database Tag: 304611
  - 13
    - Consuming Web Services from ASP? Has somebody got an example of consuming web services from an ASP "client" web site? I saw mentions of "Soap Toolkit" but the Microsoft download area specifies that this will not be supported beyond April 2005... Is it a viable alternative to create a small .Net Library project to do the Web Services bit and expose the methods through COM (Interop)? Thanks Eric Mamet Tag: Picking out top three out of database Tag: 304610
  - 14
    - Request.form doesn't wotk with this IIS config Hi i got a strange problem but it's true i don't make thing like anyone... First Config: + IIS5.0 SP2 (yes i know...) WebSite Security Root : Digest Authentication, NT Authenticated SubFolders : Anonymous Login Anonymous login is set to use a domain user to enable a sql server authenticated connection. Permissions are based on Page/action/user Membership So i know it is a bit strange but let me explain 1 I need a secured connection to a sql server 2 The Webserver is running multiple websites and i don't want to make it run under an account 3 I should avoid to request user and pass Now the way it works 1 Page default on the root is NT authenticated and i retrieve user and group membership. I put this in a Cookie. 2 When i click on one of the page linked it checks if an entry in the database exists for specified page, user(from the cookie), action. this page is with Anonymous login and so it uses the Account i set as anonymous user. 3 If it's ok i show the form mixing querystring and form 4 on submit (javascript function) when i echo all the content of the request i only see the querystring. NOW if i put Basic authentication on the Page... i see the request.form and the request.querystring... But i don't want basic authentication as password is sent in clear text and this is an administrative (System Admin) web site. here is a page as you'll see it is simple... if anyone has an idea... <HTML> <head> <link rel="stylesheet" href="/ERA/Lib/ERA.css" type="text/css"> <title>EB Automation : Da Vinci</title> <SCRIPT TYPE="text/javascript" LANGUAGE="JavaScript">  </SCRIPT> </head> <a name="Show_Environment_Create"> <TABLE width="800px" cellspacing="0" cellpadding="1" class="Pink" > <TH>Create an Environment</TH> <tr><td> </td></tr> <tr> <td colspan="2"> <FORM id="frmBody" name="frmBody" target="Contents" method="POST"> <TABLE width="800px" cellspacing="0" cellpadding="1" class="Pink" > <tr> <td class="pink">Name </td> <td class="pink"><input type='text' size=50 name='txtName' value='' > </td> </TR> <tr> <td class="pink">ShortName </td> <td class="pink"><input type='text' size=8 name='txtShort' value='' > </td> </TR> <tr> <td class="pink">Type</td> <td class="pink"> <select size='1' name='cmbType' class='pink'> <option value=''> </option> <option value='1'>Physical </option> <option value='2'>Logical </option> <option value='3'>Rollout </option> </select> </td> </TR> </table> <input type="button" value="Next" name="btNext" OnClick="return SubmitBody('Environments.asp?Action=CreateDb')"> </form> </td> </tr> </table> </body> </html> Tag: Picking out top three out of database Tag: 304594
  - 15
    - MSXML2.XMLHTTP I wrote a small script that grabs two CSV files [links to the data files] from a remote web site, parses them out and displays them in scrolling divs. The first file has a little over 27k records, the second has less. It retrieves the data pretty quick but it takes awhile to write the page. Is there a better alternative to this approach? This is my page: http://kiddanger.com/lab/getsaveurl.asp This is the relevant code to retrieve the data: function strQuote(strURL) dim objXML set objXML = CreateObject("MSXML2.ServerXMLHTTP") objXML.Open "GET", strURL, False objXML.Send strQuote = objXML.ResponseText set objXML = nothing end function I split the data into an array and then split that into a new array because the delimeters are line feed and comma, respectively. TIA... -- Roland Hall /* This information is distributed in the hope that it will be useful, but without any warranty; without even the implied warranty of merchantability or fitness for a particular purpose. */ Technet Script Center - http://www.microsoft.com/technet/scriptcenter/ WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp MSDN Library - http://msdn.microsoft.com/library/default.asp Tag: Picking out top three out of database Tag: 304593
  - 16
    - Auto-lock out module after 3-5 unsuccessful logins Hi, I would like to create an auto-lock out module where users are unable to continue login attempt after 3-5 unsuccessful logins. In addition, the user account are automatically suspended after stipulated unsuccessful logins. Is there any sample coding in ASP or Javascript for me to refer to?? Thanks alot!!! Tag: Picking out top three out of database Tag: 304588
  - 17
    - ASP & Excel Hi, I'm trying to export an ASP based report to Excel while preserving its display properties. I've added: Response.ContentType="application/vnd.ms-excel", and it works fine for several clients. For other clients it displays an emptry excel sheet. I'm not sure, but i think it has something to do with the excel version installed on clients - empty sheets were displayed for Excel 2000 clients while clients running Excel 2002 displayed the report correctly. If I add: Response.AddHeader("attachment","file_name=%file_name%"), all clients display the data correctly but the styles are lost. If anyone knows of a solution other than reformatting the report for excel, it will be very helpful. Thanks Tag: Picking out top three out of database Tag: 304587
  - 18
    - How to use a variable in a server control Instead of using <asp:sqldatasource selectcommand="select * from Table1">, how can I use a variable in place of the 'Select * from Table1' ? Thanks! Tag: Picking out top three out of database Tag: 304581
  - 19
    - Mutex page operations I have a site which is using caching for some frequently used pages. When the page-level cache expires, or is expired by me, the page will get re-rendered to a static HTML file and then shown to the user, after it has been rendered. Assume the cache is stale. Somebody comes along and requests the page. It will then get re-generated, but whilst this is happening, if somebody comes along and requests the page again then they can get an error because the static HTML page file is still being recreated by the previous page request. What I think I need is a mutex for the page to stop this from happening, for the second page request, during cache refresh. So: 1st request owns the mutex until finished, and, whilst it's updating, all other page requests wait on the mutex. How can I implement a 'mutex' style operation for this scenario in ASP or handle it better to avoid this situation from happening? I've got my code able to understand if the page being requested is actually being updated, so I could just redirect the client back to the same script again, but at the same time the update process itself takes less than a second, so if the page could somehow wait for the operation to complete it would be a cleaner operation. I tried wrapping the Sleep API in a COM object, but this didn't seem to work and I'm just looking for a bit of a sanity check on the best way to go about this. Thanks Richard Tag: Picking out top three out of database Tag: 304576
  - 20
    - ASP and Telnet I need to communicate with a POP3 server using ASP. Does anybody have any ideas how I can set up a telnet connection using an ASP script? There are some components out there, but my host won't allow them. Thanks for any ideas, R Tag: Picking out top three out of database Tag: 304575
  - 21
    - HELP, keep getting 2 errors HI All, 1st post here, i wonder if you can help. We are about to upload CMS t a windows server and keep getting 2 errors below. We need to go LIVE an it's delaying us. An error occured when updating the database. The likely reason is that write permissions are not set on th 'database' folder. Please remember that write and delete permissions are also required o the 'content' folder and its subfolders. SQL Query: UPDATE tblMenu SET [count] = 228 WHERE menuid=666; IIS Said: Operation must use an updateable query. An error occured when trying to creat /nukedit/content/cache/menu1.js. The likely reason is that write and delete permissions are not set o the 'content' folder and its subfolders. IIS Said: Object required: Microsoft VBScript runtime error424 That's it - any ideas? Cheers Iai - iain ----------------------------------------------------------------------- Posted via http://www.codecomments.co ----------------------------------------------------------------------- Tag: Picking out top three out of database Tag: 304574
  - 22
    - Recommend search engine for protected pages? Can anyone suggest a (preferably site based ) component for searching asp pages that are protected by sessions? A client wishes to enable a search that can index pages irrespective of security. thanks. Tag: Picking out top three out of database Tag: 304573
  - 23
    - Prevent unwanted comma This may not be possible on the server side, so apologies if this is the wrong group for this post. My form consists of an unknown number of pairs of text boxes. They are named textbox_a and textbox_b. I then split the comma separated list that gets posted: textbox_a = split(Request.Form("textbox_a"),",") for i = ubound(textbox_a) ...insert into db then do the same for textbox_b If anyone puts a comma into one of the text boxes, this will result in unmatched pairs. How can I deal with the comma, or prevent it? Morris Tag: Picking out top three out of database Tag: 304571
  - 24
    - Understanding exception handler example in SDK I would appreciate some help in understanding the simple C# example relating to handling exceptions. This one relates to catching an error thrown by dividing number by zero. There are a few things I don't understand which I hope you can help me with: 'using System; class ExceptionTestClass { public static void Main() { int x = 0; try { int y = 100/x; } catch (ArithmeticException e) { Console.WriteLine("ArithmeticException Handler: {0}", e.ToString()); } catch (Exception e) { Console.WriteLine("Generic Exception Handler: {0}", e.ToString()); } } } 1. Is this class 'ExceptionTestClass a 'test' class for demonstration purposes...why is there is not a general Exception class one could call rather than the author's test? 2. The variable 'ArithmeticException' and 'e' ...are these standard incoming variables from the excpection class or the author's exception class? 3. Why does he have two 'catch' classes....does the second one check the first one to see if there was an error.... 4. What is the difference between the 'ArithmeticException Handler and the 'Generic Exception Handler'. I realise these are proabably naive questions but I am just starting out. Thanks Jason Tag: Picking out top three out of database Tag: 304565
  - 25
    - ASP will not serve requests because it could not perform the first request initialization / HTTP 500.1.1 SERVER ERROR Hi, I'm spend many hour to fix this problem, read many articles about it but no article gave a solution. To isolate the problem I've created in IIS6 (WServer2003) a virtual directory test to the local C:\test, in this directory I have index.htm and test.asp (just a simple Response.Write "TEST"). Opening the server/test/index.htm show the page, server/test/test.asp gives an internal error (500). The event log gives me the "ASP will not server..." error. I cannot find any ASP errors (friendly message turned of etc.) so I guess the page ASP script is not started. ASP is enabled, if I disable ASP I get could not load page in IE. IIS was re-installed, didn't solve the problem. Maybe can give me a clue where to look of what to try next because I'm out of options. TIA Rene Tag: Picking out top three out of database Tag: 304557
- Next
  - 1
    - newbie - updatable query in asp Hi folks, I'm new in ASP so I need some help on a updatable query. I have an access db with the table SID_Master_Archief. From this table I would like to run a query showing six fields. The doc_date(date), doc_link(hyperlink), regio1(boolean), regio2(boolean), regio3(boolean),regio4(boolean). The boolean fields have to be checked by the user. So I need a asp form with a grid showing these records and have the users click on one of the regio fields (I guess with a checkbox) to check or uncheck and then confirm with a button somewhere on the form to send the update to the server. Anyone how I should do this? Regards Marco The Netherlands Tag: Picking out top three out of database Tag: 304554
  - 2
    - what URL did client come from I have 2 URL's like this xy.abc.com yz.abc.com They bolth point to an IP where page1.asp is the default. Hosted on a IIS 6 server. What code do I use inside page1.asp to determine which of the 2 sites above the user used to access page1.asp. Thanks Paul Tag: Picking out top three out of database Tag: 304552
  - 3
    - asp question about text file I wrote an asp program that displays some information line by line such as name, address, town, state, zip and it prints about 200 lines to their browsers when the asp file is called. It is comma delimted so they can import into their database using access for example. 1. when they do file-save as to a txt file, it does not import right for them. It seems the lines blend into each other. 1. the only way they can do it is if they view the source code, then save as txt file. then when they import into access, it parses right. odd, what can i do on my asp end to make sure they can just do a file save as right from browser instead of viewing source. Thanks Tag: Picking out top three out of database Tag: 304550
  - 4
    - CSS and excel I use ASP to generate spreadsheets. That works fine. Is there a way to use CSS to influence the way the data is presented in the excel spreadsheet? I tried setting the font family, size, nowrap, etc. None of it seems to be effecting the way the spreadsheet is built. The spreadsheet uses all it's own defaults. thanks Tag: Picking out top three out of database Tag: 304547
  - 5
    - How to using connection pool technlogy in ASP Thanks~~ Tag: Picking out top three out of database Tag: 304543
  - 6
    - Is this possible in ASP? Hi, I have a detail asp form where the user inputs as following: expenseid expense type of expense comment .............. ............ ....................... ............... ............. ............ ....................... ............... TotalExpense ........... The above total expense needs to be transferred to a summary form. I believe this can be done by server side coding. Any advise as how to transfer the TotalExpense value to the summary page? Thanks Tag: Picking out top three out of database Tag: 304541
  - 7
    - Pass data between tables This is my scenario: I develop a .asp app that reads its data from an Access DB "A", and I have a desktop app with a FoxPro DB "B". How can I insert data from a table in DB "A" to a table in DB "B". Im new to asp and I really know only the basic's, so who can guide me to a tutorial or where can I dowload an example... it would be great. Tag: Picking out top three out of database Tag: 304531
  - 8
    - Form with diferrent action forms depending on the context Hi all, I have a form with 3 combobox whitin a asp page called data.asp, whose action form is itself; the first combobox drives the behaviour of the other two. The onchange event of the first combobox is related to a javascript function in which I call the submit method for the form, whose action form is itself. This works fine. The problem is that if I want to save the changes done by the user (clicking the OK button) I need to set the action of the form to another page, for example save.asp. The question is: how to do this? I had written a function inside the onclick method of the OK button that is similar to the following one document.MyForm.action = "save.asp"; document.MyForm.submit(); But it doesn't work properly, because the page save.asp is never invoked. Thanks in advance for the help, Michele. Tag: Picking out top three out of database Tag: 304523
  - 9
    - Exchange of files Is it in ASP possible to make a webpage with folders and subfolders where people (if they have the right password) can download and upload files. An uploadet file should appear on the webpage for others to use as soon as it is there. There is probably a name for this system. I would prefer if it could work like the Total Commander, on the internet. Best regards Lars Tag: Picking out top three out of database Tag: 304514
  - 10
    - Problems with displaying // Hi, I'm pulling data into ASP from Sybase IQ. When the data is in the database its displayed correctley: //C://.... When I pull it into an asp page, the formating changes, and a few of my slashes disappear. Is there a special method of pulling slahes into asp? Thanks, Yuval Tag: Picking out top three out of database Tag: 304508
  - 11
    - ASP Email Issue I need to send an .ASP page as an email template using VBScript. I'd like to do so using CDONTS or CDOSYS. this is the dynamic email template http://www.womentowomen.info/emailtemplates/grid23.asp?id=122 the script needs to loop through a recordset and send emails using data from SQL 2000. when i try to send using a script i built the asp page pulls in without rendering the asp. how can i pull the rendered asp into my vb for emailing? Please help??? Tag: Picking out top three out of database Tag: 304500
  - 12
    - Web server not running ASP.NET v1.1 I have just moved a project to my laptop and get the message "Visual Studio .NET has detected that the specified Web server is not running ASP.NET v1.1. You will be unable to run ASP.NET Web applications or services" Presumably there is a d/l on MSDN to rectify this, but I can't find it. Does anyone know the URL? Many thanks. Tag: Picking out top three out of database Tag: 304499
  - 13
    - confused about posting & execute permissions so i am using Dreamweaver; and I need to be able to have multiple pages post to a page called page6_1.asp from there; i give people the ability to either '1 - save definition as new report'; '2 - overwrite existing report definition'; or '3 - new draft for existing report' I have these 3 functions written as seperate pages.. Because Dreamweaver starts getting confused when you put too much on one page. So i basically want to pass data between multiple paes and page6_1.asp; and then if someone clicks option 1; i want to be send them to page6_2.asp; if someone clikcs option 2; send them to page6_3.asp; and if someone clikcs option 3 then send them to page 6_4.asp Basicaly; I can't get this data to post between multiple pages; and i had to drop the Execute Pemrissions from Medium to Low-- because Medium wasn't workig for me at all. Does this mean that i can't use session variables to do this? I've had the hardest time getting it to work. Tag: Picking out top three out of database Tag: 304496
  - 14
    - Session Object Question... I'm wondering where the data is stored for Session objects. Is it passed to the browser, and then passed back to the server during page requests? Or, is the Session data always on the server, and the browser simply passes the server it's unique session id? Thanks... Tag: Picking out top three out of database Tag: 304492
  - 15
    - passing date variable to sp in asp i have this line: .... Set paramsx = cmdUpdatex.CreateParameter ("@invdate", addate, adParamInput, 50, invdate) cmdUpdatex.Parameters.Append paramsx .. (the invdate value is a dd/mm/yyyy date) AND in sql server 2000 sp i have: ... @invdate nvarchar(100)= null, ... insert into inv ( invdate, ) values ( @invdate, ) when i run this it does not work... so i run profiler and extracted the problem line. in query analyser it gives me the: Syntax error converting character string to smalldatetime data type. what do you guys think is the problem? --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.808 / Virus Database: 550 - Release Date: 08/12/2004 Tag: Picking out top three out of database Tag: 304488
  - 16
    - Validate Date in text box Hello to all, I am developing an application ASP and desire to validate the fields of dates before jumping to consultation SQL, the dates is entered text boxes and the idea is that been worth when losing the Focus. How I can do that? Thanks. -- Marco Antonio Artus S. Lakromsoft INC. 09-9594663 Tag: Picking out top three out of database Tag: 304486
  - 17
    - MultiDimensional Array I have the value of checkboxes coming into an asp page. All checkboxes have the same name and the same number of values: e.g. jid(1) = 1,4,38 jid(2) = 18,233,0 etc. How do I put the above into multidimensional array that I can loop through and call a stored procedure for populating a table? dim ar(3) y=0 for x=1 to request("jid").count ar(y) = request("jid")(x) y=y+1 next for x=0 to Ubound(ar,2) response.write ar(0,x) & "=" & ar(1,x) & "=" & ar(2,x) & "<br>" next Thanks a bunch. Tag: Picking out top three out of database Tag: 304477
  - 18
    - ASP code in browser window When I hit an asp page the code for the page is displayed, not the actual page. I am running IIS locally for development. Any ideas of why this would be? If the pages are loaded on the server, they load properly. Thanks Tim Tag: Picking out top three out of database Tag: 304470
  - 19
    - value of checked box!? Hi, I've got the following problem: I'm retrieving data from an SQL Server database (the data itslef was entered by an ASP form). And on an 'edit form' I want to display a checked box in the state corresponding to the value saved in the DB. But somehow that doesn't work!? SQL tells me the value is 1. My ASP page tells me it's 'True'?? So I tried it like this: <input name="checkbox" type="checkbox" value="checkbox" <%If rsDemande.Fields.Item("lien").Value = 1 Then Response.Write(" checked='checked'") : Response.Write("")%>> and like this: <input name="checkbox" type="checkbox" value="checkbox" <%If cstr(rsDemande.Fields.Item("lien").Value) = "True" Then Response.Write(" checked='checked'") : Response.Write("")%>> But neither works. The checkbox remains unchecked!? What am I doing wrong? Thanks a lot, Jerome Tag: Picking out top three out of database Tag: 304466
  - 20
    - value of checked box!? Hi, I've got the following problem: I'm retrieving data from an SQL Server database. And I want my form to display a checked box in the state corresponding to the value saved in the DB. But somehow that doesn't work!? SQL tells me the value is 1. My ASP page tells me it's 'True'?? So I tried it like this: <input name="checkbox" type="checkbox" value="checkbox" <%If rsDemande.Fields.Item("lien").Value = 1 Then Response.Write(" checked='checked'") : Response.Write("")%>> and like this: <input name="checkbox" type="checkbox" value="checkbox" <%If cstr(rsDemande.Fields.Item("lien").Value) = "True" Then Response.Write(" checked='checked'") : Response.Write("")%>> But neither works. The checkbox remains unchecked!? What am I doing wrong? Thanks a lot, Jerome Tag: Picking out top three out of database Tag: 304465
  - 21
    - Session("locked") issue I have a form that has few text boxes to input. However, after saving, if the user comes back to the same form, then the input boxes should be locked. I would like to know whether this can be handled by session("locked") variable or any other way. Any information to handle this concept is appreciated. Thanks. Tag: Picking out top three out of database Tag: 304464
  - 22
    - Class Problem(cross) i have 3 class.. Dim ws As New WebReference1.ProductDefinitionType() i can write this class's variables like this ws.LargeImage = "xxx" how can assign a value of Features in Public Class ProductDefinitionType class ////////////////////////////////////////////////////// Public Class ProductDefinitionType Public Features As FeaturesType Public LargeImage As String Public LargeImageLinkText As String end class ////////////////////////////////////////////////////// ///////////////////////////////////////////////// Public Class FeatureType Public Value As String End Class /////////////////////////////////////////////// ///////////////////////////////////////////////// Public Class FeaturesType Public Feature As FeatureType End Class ///////////////////////////////////////////////// Tag: Picking out top three out of database Tag: 304460
  - 23
    - Server object, ASP 0177 (0x800401F3) Error while instantiating this component in ASP page. <% Dim oDms oDms = Server.CreateObject("DmsMod.Document3") Set oDms = Nothing %> The dll is registered using regsvr32. I think it is registered correctly because, I can use this dll perfectly in a VB6 application by adding to the references. IUSR_MyMachineName and IWAM_MyMachineName also have Read & Execute permission on the System32 folder (System32 folder is housing the dll). Clueless! Tag: Picking out top three out of database Tag: 304458
  - 24
    - Make ASP page that polls to wait for a document to be produced Hi! I have a webapp. that holds a lot of documents. Some of the documents needs to be produced from a database on-the-fly, some are static documents like PDF, Word documents, etc... In the end, a user can do a request to produce a large amount of documents as one huge PDF document. Today the creation of documents is working, but all code is done in ASP. In Visual Basic, I was thinking about making an ActiveX EXE server that generates the PDF document. The ASP page will be polling until the file is generated. When this is done, the file will be displayed. I have only written down my thoughts on the subject. Is there a good way to do this?? Any help is appreciated! Henning :-) *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: Picking out top three out of database Tag: 304457
  - 25
    - Week Number Hi, I am trying to figure out a way to get the week number of the current week. I know this is relatively easy using the calendar year (starting from January to now). However, I want to do it so I start in October on the first monday of the month, so today's date would be the 10th week. Any ideas? Shahid Tag: Picking out top three out of database Tag: 304456

Sorry for not answering earlier... to much do at the moment, christmas
time and all.

The database used is an access, simply because I don´t know how to do
with any other db. Would like to try out something else (sql-server?)
but don´t know what. I need it to be free though...

/Thomas

Top

Re: Picking out top three out of database by s_m_b

s_m_b
Tue Dec 14 10:00:52 CST 2004

thomasemilson@hotmail.com (Thomas) wrote in
news:eeb0a9ba.0412140408.2b70ef8c@posting.google.com:

should work on access. msde 2000 is free, but fussy to set up.
mySQL is free but kind of limited

all depends on the amount of traffic expected and the location.

> Sorry for not answering earlier... to much do at the moment, christmas
> time and all.
>
> The database used is an access, simply because I don´t know how to do
> with any other db. Would like to try out something else (sql-server?)
> but don´t know what. I need it to be free though...
>
> /Thomas

Top