Hi All, I face with problems while inserting variable with apostrophe sign (') into the database... I receive error message everytime while the variable to add into databases include a ' sign. The sample coding are as below: set Con=createobject("adodb.connection") Con.open "dsn=Indicator...more >>

Hi, I have a input with type checkbox. I want it to be automatically checked if the value from the corresponding field in the database is also checked. I tried this: <% set objdc = Server.CreateObject("ADODB.Connection") etc ... sql="select maa13 from mytable" dim rsArray Set rs = objdc.e...more >>

Hello, I have read a bunch of topics on this issue but none seems to have resolved my problem. I have set up a user account in my SQL server database. e.g. User: TheUser Password: Password and assigned it as a datareader with the ability to issue SELECT statements on one table. On a sepa...more >>

Hello, this is strange and has all of us here scratching our heads. I am doing a simple test to return the value of a "Name" comumn in a SQL Server 2000 table: <% ' Open Connection to the database set objConn = Server.CreateObject("ADODB.Connection") strConnection = "Provider=SQLOLEDB; Data So...more >>

Hi, My requirement is for the user to be able to view/update the DB via an ASP application.To save him from remembering too many passwds, I want to be able to authenticate him without creating a separate 'user' table with another passwd et al in the DB.Can I have a login page where he supplie...more >>

hi there we have an Intranet site ( hosted on IIS 6 on Windows 2003 ) that connects to a SQL DB via an ASP page ( hosted on SQL 2000 on Windows 2000 ). Both servers are located in the same AD site, and users can use the ASP page with no problems However from another AD site ( same domai...more >>

Hi All Just been looking through the excellent ASPFaq site and wanted to dissucss Aaron's (??) comments re better to create your own session ID rather than use ASP classic's in-built one and then use this through various posts and gets to keep the state. Only issue I've got with this is ...more >>

Hi, I run this sql in Access and it runs fine. Then I cut and paste it as a literal constant into an ASP page in VS2003 and it returns this error.. Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. /...more >>

Hello, I have an edit form where the name is already populated. When the user submits this form, it posts to a process email page which loops through a separate lookup table. Sometimes the name from the form will not match the name in the table, which is fine. We don't need to update the name on...more >>

I have to connect to a SQL server database held on our network from a hosted server that we rent. I have written a VB6 application for use in the business and we need to be able to connect a website to it so that field agents can connect view there diary from the backend database. We dont w...more >>

Sorry I not making it clear, If the dynamic filed on the asp page from recordset 1 was, for example, London I neeed the code below to match 'London' to a list of entries in Recordset 2 and return a row background colour based on the match. Recordset 2 is another table with a list of towns only...more >>

Hi I need to compare a dynamic field in an asp page to a field in another table, if there is no match then i would like to chane the row colour ( see code below). The problem Im having is that the comparison should be one of many entries in that db field, at the moment it only compares the...more >>

Hi I have an asp page that shows dynamic data from the db, I only want to show the first 3 letters / digits from the db on the ASP page. Thanks in advance Simon ...more >>

Hi I need to Flash dynamic text on ASP page if the time in the record is less than 20 minutes from NOW() time. Thanks in advance Simon ...more >>

Hi, I have already posted this problem but without result, so ... I run IIS on windows 2000 sp6. Clicking on any htm (html) page (with only html code) gives nothing (viewing the code, i see nothing between <body> and </body>). If i change the extension into .asp, it works. Which option or...more >>

Hi, I downloaded aspsmartupload in order to let the visitors of my site upload files (their picture in jpg). It works perfect. But in fact, i need to collect not only their picture, but also name, address etc ... So i combined both input types in one form like this: <FORM METHOD="POST" ACTIO...more >>

Dear All; I have two databases (db1 and db2) with the same structure. I need ASP or ADO code to apprend record from db1 to db2. How to do? Please help, it is important for me! thanks Vichet ...more >>

Dear All I have one function to convert mdb database as follow: Function ConvertMDB(SourceDB,DestDB,Format) Set FSO = CreateObject("Scripting.FileSystemObject") oldDB = SourceDb newDB = Replace(SourceDb,fso.getfilename(SourceDb),"NEW_"& fso.getfilename(SourceDb)) ...more >>

Hi, I have an ASP.NET web application that runs certain tasks at a given time. Sometimes the task is scheduled to run at a time that coincides with when IIS is recycling an application's worker process. This causes my web application task not to run. Is it possible to query IIS usi...more >>

I have 2 developper machine running visual studio 2003 and Windows 2000. On the first machine (Machine A) I may create a new asp project without problem. On the second (Machine B) I cannot create a new project. Visual Studo create the project but not the initial files and freezes. But I may c...more >>

Hi, I made a form in order to collect data from new students, like name, address etc ... but i also ask a picture in jpg format. My problem is: how to get the jpg fiel into MS Access? I tried with an OLE field (field foto) but i t doesn't work a,d with a text field, but the i get only the pat...more >>

I want to take database backup using asp code. So what is the code to be written? ...more >>

I know this is a weird request, but lets say I create a recordset with 5 row and 5 columns. How can I, for instance, pull out the record from row(3) column(2).. I know i can pull from a column by just doing this, Recordset(2).value, which pulls the record from the 3rd column. Is there a way to...more >>

Good morning, I'm encountering the following problem: I have an ASP page with a form in which most of its values are loaded from a recordset into hidden fields. I have second ASP page used to process the parameters passed from the first page (insert and update MS Access tables). When requ...more >>

Suppose an ASP application retrieves 100 records from a SQL Server 7 database table. How many roundtrips (between the front-end & the back-end) are involved in retrieving the 100 records? Thanks, Arpan ...more >>

×𾴵ĸ÷λÅóÓÑ£¬´ó¼ÒºÃ¡£»¶Ó­¹âÁÙ»¨Ç°ÔÂÏÂÍøÉÏÉÌ ³Ç¡ª¡ªhttp://www.huaqianyuexia.com ¡£±¾É̳ÇÓµÓм¸Ç§ÖÖ³ÉÈËÓÃÆ·£¬ÈçÄÐÐÔÓÃÆ·£¬ Å®ÐÔÓÃÆ·£¬ÇéȤÓÃÆ·µÈ£¬ÈÎÄúÑ¡¹º¡£¿°³Æ°®ÇéµÄÌí¼Ó¼Á£¬ÐÔ¸£Éú»îµÄÖúÍÆÆ÷¡£²¢³Ðŵ³ä ·Ö×ðÖظöÈ˵ÄÒþ˽Ȩ£¬×öµ½±£ÃÜÅäËÍ¡£ ...more >>

Hi! Im planning to encrypt the password that was stored on msaccess database and also the text inputed from a password textbox. Also, if I want to get the password from the database, I need to decrypt it so it can be comparable to the one that is inputed on the textbox. Is there a way on how t...more >>

I came across something rather odd when updating a value in a database table. Instead of updating the record with the new value, it updates ALL the records in the table. Make a database table with fields ID (int, PK) and DATE1 (smalldatetime). Add three records 1, 2, and 3 with null DATE1. ...more >>

Does anyone have a good example of how to pull out the link and title from an MS Access Hyperlink field into an ASP link? Thanks, Doug ...more >>

Hi all, Something really odd is happening on one of my asp pages. The page causing the trouble is being called by a form and it is in charge of inserting values on an Access DB. After inserting the values I want the page to redirect the user to the input page where the form resides so the u...more >>

Hello group, I want to delete the oldest rows of a table with ms-access/jet-engine/ADODB, keeping only the newest 2000 rows. Can I do this: "DELETE * FROM myTbl WHERE myDate NOT IN (SELECT TOP 2000 myDate FROM myTbl ORDER BY myDate ASC)" ?? -- Evertjan. The Netherlands. (Re...more >>

I want to create a tabular/columnar ASP form with data from a Access table. I want this form to be editable. Greatly appreciate if somebody can share the code. Thanks Karen ...more >>

Greetings, I cannot quite figure out how to accomplish the following results. My table is "Products" with the following fields: ID Item Metal Size Price 1 Ring 18ctGold 4-7 $23.00 67 Ring 18ctGold 8-11 $30.00 70 Ring Silver 4-7 $10.00 75 Ring S...more >>

A number of our online forms with client side JS validation appear to have been the subject of a 'injection' hack but I am novice of the reperucussions or exact meaning of what is going on here. Somebody appears to be cycling through all our online forms and and inserting strange code. Some...more >>

Dear Sirs, I have the following select query and i need to update the field EmailLastReceivedDate (showing null in the select) to the values in the field MaxOfSentOn using access 2000 query SELECT Max(EmailsDatabase.SentOn) AS MaxOfSentOn, CoEmails.CoCode, CoBank.EmailLastReceivedDate FROM...more >>

I am looking for ASP code that accepts a table name in a SQL database and display the contents of the the table by finding the column names of the table in the SQL Server table. Thanks Karen ...more >>

Hello, I want to have have a table like this in Microsoft Access 2000: id Autonumber userID Number timeStart Date/Time timeEnd Date/Time where I can store time ranges for which users can meet for a presentation. For example, a user, Mike, could have the following time ranges in which ...more >>

Does anyone know how I can set up up something that would automatically generate a message or alert to notify me that a new entry has been added to guestbook which I have developed in ASP on my website? The records are held in an Access table. I have already developed an administrator page whi...more >>