Forum

Posts

RECENTLY INDEXED PROGRAMMING SOLUTIONS OF MYSQL


error early binding ado recordset object  

Originally posted by : adam harbour (aharbour@yahoo.com)HiI am trying to create an ado recordset object.dim rs as objectrs= server.CreateObject("adodb.recordset")works fine. I read that aspx supports early binding.as the top of... Continue Reading
Views : 68
Monday 26th of November 2012

How can update and add to multiple tables  

Originally posted by : Richard (rsweeting@bahamas.net.bs)How can i update a table and at the same time add to another table.I used the code from this site:http://www.aspfree.com/asp/startpage.asp?id=23This works well for me BUT i need to know... Continue Reading
Views : 82
Monday 26th of November 2012

retrieve emails and direct to db  

Originally posted by : punu (punz52@hotmail.com)I want to retrieve emails from my mail server and direct them in to access under different heads such as Subject, message etc. please help Continue Reading
Views : 178
Monday 26th of November 2012

Display database fields  

Originally posted by : MM (manal.milad@itworx.com)I am new to ASP+ and I need to display fields from a table. I don't want to use a Datagrid nor a DataList. I want to display the fields separatly. What should I use?I can already connect to the database and have a... Continue Reading
Views : 71
Monday 26th of November 2012

Passing Variables  

Originally posted by : arbil (ricky@rickysantos.com)I have an asp page which contains two text boxes and two buttons besides the two text boxes. By default, the textboxes are empty. When I click the button of the first text box, a popup window will appear which instantly... Continue Reading
Views : 58
Monday 26th of November 2012

How can i display the content of the text file from a ADO  

Originally posted by : Phyllis (tanphyllis@yahoo.ocm)I'm using a Access that thate have "content" as 1 of it's attribute. It is a ole object, txt file. After i query the table For example "Select content from table" How do i display the "content" on to my site? How to... Continue Reading
Views : 84
Monday 26th of November 2012

OLAP problem: Can select clause be used while creating Calculated Members from a MDX query   

Originally posted by : Jalinder Autade (jalinder2k@yahoo.com)I am using MS OLAP services 7.0 to build a cube.I wonder if select, from and where clauses can be used while creating Calculated Members from a MDX query using Calculated mamber Builder?I have... Continue Reading
Views : 80
Monday 26th of November 2012

Counting number of Records  

Originally posted by : Atif (atifh1@yahoo.com)Hi,I need to count the number of records in a recordset. I am using a ASP and Access'97 database. I am trying is to use the "RecordCount" property of the recordset, but its returning -1, which is supposed to mean that... Continue Reading
Views : 65
Monday 26th of November 2012

ASP build page to send by email  

Originally posted by : karine (karine@tista.com)I want to send a page build with ASP by e-mail, I don't want to have a link to this page.Thanks for your interest to my questionkarine Continue Reading
Views : 57
Monday 26th of November 2012

How to upload the character '  

Originally posted by : kaarthik (kaarthik@singnet.com.sg)HelloI seem to have a problem when i try to add the character ' into a database....let's say an article contains these single quotations: ' . When i wish to add the article into the database the... Continue Reading
Views : 229
Monday 26th of November 2012

T-SQL and Stored Procs  

Originally posted by : Paul (pwhite@yahoo.com)i'm trying to do a query where one of the selected fields is the result of a stored procedure. The inputs of the stored procedure are one of the returned values from the query... confused yet??example Continue Reading
Views : 89
Monday 26th of November 2012

File size  

Originally posted by : Mark (mark.lawrence@nireland.com)Hi,Does anybody know how to display the size of a file in an asp page. In my case it is a database.I am using FrontPage and the site is hosted by an ISP, so I do not know the absolute path to... Continue Reading
Views : 197
Monday 26th of November 2012

SQL query performance  

Originally posted by : Hang (f11lhc@yhaoo.com.hk)Hi all,I'm now trying to monitor the performance of my asp page. But I have a doubt when facing the SQL query.For the following code segment:set conn =... Continue Reading
Views : 112
Monday 26th of November 2012

Access and dates are killing me plz help  

Originally posted by : Mathias Koizumi (tech@techshoppen.dk)Please reply if you know the solution to this :I have a table in Access2000. One of the fields is called "meetingstart" and has subtype "date/time"When i add a new record from my... Continue Reading
Views : 123
Monday 26th of November 2012

web server intermittantly locks up when asp queries oracle DB  

Originally posted by : matt clark (mat_clark@ic24.net)Has anyone had this fault. I query an access db and the web server never locks up but intermittantly when query Oracle database.This happens on PWS and IIS. The only way to get the site working again is to shutdown,... Continue Reading
Views : 122
Monday 26th of November 2012

read and update problem  

Originally posted by : Peter Osney (webmaster@osneymedia.co.uk)Hi Im trying to read a record that stores a counter, increment the counter by 1 the update the record. I'm doing something wrong, and get an error. What is wrong with it? code below... ... Continue Reading
Views : 113
Monday 26th of November 2012

Sql Server  

Originally posted by : Anuradha (varada_anuradha@hotmail.com)Hi there, I am a beginner in SQL Server with knowledge only in Access and oracle. If anyone could point me to any good online tutorials then please let me know of any site that can help me in a great... Continue Reading
Views : 53
Monday 26th of November 2012

Trying to get a wildcard  

Originally posted by : Scott Arango (sarango@ford.com)i am trying store an if... then procedure saying that if it finds this as a name (drd____) then ... = false. But my problem lies trying to get the wildcard to work. if i type the name like:if form_id =... Continue Reading
Views : 56
Monday 26th of November 2012

SQL 2000 Slowsdown when using 2 recordset on one connection object  

Originally posted by : Thomas Rojsel (thomas@netit.se)SQL 2000 Slowsdown when using 2 recordset on one connection object. Was running great when using SQL 7.0, other wise like the current.------SQL server waits 4 seconds before returnung records after every... Continue Reading
Views : 88
Monday 26th of November 2012

ADOxxx or SQLxxx objects  

Originally posted by : DevPro (mbsoftware@libero.it)I currently have a web site running on NT4 and linked to an Access database. If I want to upgrade to SQLServer I just need to update the connection string in one file.Now I want to rewrite my site with ASP.NET, but I... Continue Reading
Views : 132
Monday 26th of November 2012

Moving SQL Server 7.0  

Originally posted by : Alex (AlexLut@aol.com)What is the best way to move entire SQL Server 7.0 database from one server to another? Continue Reading
Views : 153
Monday 26th of November 2012

Nulls, zeros, NZ - haaalp  

Originally posted by : Nomit (h.babraa@lse.ac.uk)HelloI have SQL that returns the sum of a field. When there are no entries it returns a null. In access you can use NZ (NVL in Oracle) to force a zero to be returned. How do you do this is with ASP? I get a... Continue Reading
Views : 96
Monday 26th of November 2012

counting records found in a search  

Originally posted by : andrew (harrison@tiscalinet.it)can anyone tell me how to display the number of records found in a database search?like in search engines where it says 12 items found matching whatever.thanks Continue Reading
Views : 111
Monday 26th of November 2012

Combine two DB/RS  

Originally posted by : Raphel (raphel.girma@foveon.net)I have MS Access and SQL Server databases both have to track Employees inf for various uses.I have employees table in both DB that have identical EmpID. Based on this how can I write ASP code that access both... Continue Reading
Views : 99
Monday 26th of November 2012

Sql efficiency  

Originally posted by : Richard (litimel@hotmail.com)Is it more efficient to shoot many small, specific sql count queries at a database - or to make one large query and then count what you want with an asp script? Are there any general guidelines on where to draw the... Continue Reading
Views : 52
Monday 26th of November 2012

Searching my Sql Database  

Originally posted by : Mike (frankr6805@aol.com)I want to put together a serach for my database but I am having trouble. I know the LIKE commmand but is there some other way to make the search 'smarter' and more comprehensive, would a stored procedure in teh sql server and... Continue Reading
Views : 107
Monday 26th of November 2012

How To update Record in SQL  

Originally posted by : Hussain Ali (epilot_pk@yahoo.com)Hello I Am Trying But Fail Please Help Me.I am use This in Asp index.asp File Thanks epilot_pk@yahoo.com Continue Reading
Views : 72
Monday 26th of November 2012

Dupplicate problems inserting record in the database  

Originally posted by : Ezio (samarelli@altavista.com)Hi to all,I've a problem inserting record in the database across ASP and IIS4/5;The problem is that if I write a script that insert a record in the database eg.Once the script has been executed and the "Thank you" message appears, if I reload... Continue Reading
Views : 75
Monday 26th of November 2012

SQL Server 2000 connect with a form in a website using ASP HOW....  

Originally posted by : tino (sdcordero_carter@hotmail.com)how do you connect to a website with server 2000 and enter in data into the database from the website with asp....; Continue Reading
Views : 95
Monday 26th of November 2012

Field disabling based on drop down list selection....  

Originally posted by : ShiftyOk, for example's sake, let's say I'm creating a submission form where the user selects from a list of names in a drop down box, and then fills out information under that name. My drop down list is linked to a DB table consisting of the ID and 2 text fields (first... Continue Reading
Views : 115
Monday 26th of November 2012