|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Display unique SQL table ID on ASP page Posted by Ken D. at 2/28/2006 1:44:27 PM I have an ASP page which collects data for an SQL table. The SQL table
assigns a unique ID for each new record. Once the user submits the data, I
display a confirmation page with the data entered. I would also like to
display the unique ID on this confirmation page.
Is that possible? I ...more >>
Weird Stored Procedure Problem - stopping without any errormessage Posted by Christian Peterek at 2/28/2006 12:00:00 AM Hi NG,
Currently I am encountering a weird problem, which even the big google
could not fix.
I've got a stored procedure(SP), that calls two other stored procedures.
SP1 (which i call from the classic asp) calls first the SP2 and then the
SP3.
But for some reason, the SP3 just aborts it'...more >>
ASP delete records problem Posted by Basr at 2/28/2006 12:00:00 AM I have an Acces database classical ASP. In this db I have 2 tables. I am not
really a ASP programmer but with the help of example-scripts I succeeded in
functioning the whole thing. Recently I added a third table and now I have
the problem that I cannot delete records from it. I can delete reco...more >>
help with sql query from asp page Posted by zerbie45 NO[at]SPAM gmail.com at 2/24/2006 3:30:10 PM I'm running this query against a sql 2005 express ed database which
contains several rows; however it only extracts the first one. How
should it be modified so that it returns all data ? It looks ok to
me.....
Set RS= server.CreateObject("ADODB.Recordset")
RS.Open "Select * from logs", dbConn...more >>
IDIOT Posted by deepak at 2/23/2006 12:19:18 PM can sombody help me, well i am new to ASP and i amnot very good in
programming , can somebody tell me where to start, i know basic programming,
i know database handling(not Master of all), basically i am sales guy whos
is having interest in learning Computer
Please help me if u can
tell me the...more >>
Alpha Split Posted by Bryan Harrington at 2/22/2006 10:57:23 AM I'm working on an app that I need to be able to filter a recordset with an
alpha split.
i.e., give me all customers with lastnames between A - M
So.. that's not a problem.. and customer_name like '[a-m]%' It returns
what I need....
PHB wants to expand that functionality to split t...more >>
error '80020009' Posted by Erica at 2/20/2006 12:04:30 PM All that I get is this error: error '80020009' . No description, or anything
else. The error is generated on this line:
getconn.execute("insert into tts_detail values ('" & trim(request("probid"))
& "','1','Assigned','" & RsAssign("priority") & "','" & ttDate & "','" &
RsAssign("phone") & "...more >>
Problems retrieving image from SQL server Posted by Sean at 2/20/2006 12:00:00 AM I need to retrieve a small GIF stored in a SQL server Image field and
display it on an ASP page.
I have a wrapper page to return the image which I call from another page
like this. :
<img src="image_wrap.asp?ProdID=47">
The code to retrieve the image doesn't seem to work, all i get is a...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Error Type: (0x80020009) Exception occurred. Posted by Si at 2/13/2006 5:57:05 PM I get the following error from the code below:
Error Type: (0x80020009)
Exception occurred.
/diary.asp, line 53
The specific part that causes the exception is when I try to access
rsAppsTemp("AppointmentDate") in the While loop. For some reason it works
fine in the If statement above i...more >>
Newbie: simple asp security form with CAPTCHA Posted by blubberpuss NO[at]SPAM gmail.com at 2/13/2006 12:30:06 PM I've created a simple form that creates a .csv and will generate an
email (intro.asp).
For some security, I've been asked to include CAPTCHA. I found Web Wiz
CAPTCHA and it works fine -- I have a name text field and the CAPTCHA.
A correct response redirects to the full form's page, with more tex...more >>
one to many / master detail issue Posted by Marcel at 2/12/2006 4:23:03 PM what is the best way to renerder master detail in ASP with out repeat visits
to the server and recursive queries.
Class 1
Jim jones
Kathy Pho
Class 2
fred smith
scott free
Ive seen code that uses a variable and a loop but they dont seem to be able
to go...more >>
passing wildcard criteria Posted by Wendy Parry at 2/12/2006 12:06:47 PM Hi,
I'm having a little trouble using the SQL LIKE clause with asp.net to an
Access Database...
Dim strSQL as String = "SELECT * FROM tblDickerExtensions WHERE Surname
" & " LIKE " & criteria & "*"
I just can't get the " & ' syntax correct, I'm sure it's a 2 second
thing for you guys.....more >>
difficulty with SELECT SCOPE_IDENTITY(); Posted by Joe Befumo at 2/11/2006 4:42:53 PM This has me stymied, but I'm betting it's something real simple. I'm working
in vb/asp/sql-server, and trying to insert a record into a table, and
retrieve the new index.
Dim objDataConn
Dim strSql
Dim intNewKeyVal
Set objDataConn = Server.CreateObject("ADODB.Connection")
o...more >>
Writing times to Access using ASP Posted by Andrew Virnuls at 2/10/2006 12:00:00 AM Hello all!
I'm working on a system for my colleagues to record meetings with clients.
I've done plenty of ASP pages before and have had run-ins with dates before,
but have never done anything with a time in before.
I've got a table called tbl_times with has one field, in short time format,
...more >>
BeginTransaction in ADO.NET Posted by B.Santha Baktha Shanmugam at 2/8/2006 9:15:25 PM Hi
While using ADO.Net i want to use Begin & Commit Transactions to
prevent the data.
My situation is like this,
I want to read some data from the table using dataset or datareader,
so a loop will run.
Under the main loop two insertions using command object should
happen. Fo...more >>
To Save a file using File Control in HTML Posted by B.Santha Baktha Shanmugam at 2/8/2006 8:58:29 PM Hai,
The File control in HTML is allowing me to Open a file using Open
button. Likewise i want to save a file using Save button.
If it is not possible tell me a alternate solution to save a file
using save option in controls.
*** Sent via Developersdex http://www.developersdex...more >>
email verification Posted by raj chahal at 2/7/2006 5:55:38 PM hi there
I'm building a membership area.with some automation when the user goes to
the register page and registers an email is sent to the person registering
(CDONTS) and only until the email is returned the account is activated. How
can I do this ?
I can send an email but don't know what to ...more >>
Parsing XML Posted by gebelo NO[at]SPAM gmail.com at 2/7/2006 3:14:04 PM I'm messing around with a mapping application using the Yahoo online
geocoder.
In my application, the user enters an address search in a form and the
results page loops through the recordset of matching results.
What I want to do is take the address for each matching result and send
it on t...more >>
Read a recordset into a variable so I can disconnect from DB and use results? Posted by Noozer at 2/6/2006 12:00:00 AM This seem to be a simple question, but I'm having no luck with Google
keywords...
I have an some ASP in which I open a recordset via a connection to a MSSQL
database. I don't want to keep the database connection open while I'm
processing the data from the resulting recordset.
Is there a ...more >>
how to get the records from a stored procedure in Mysql Posted by Kevin at 2/3/2006 4:59:12 PM Hi,
I use ASP together with Mysql.
I made a stored procedure ('proctest') in Mysql.
In ASP, i did:
<%
set OBJDC = Server.CreateObject("ADODB.Connection")
objdc.Open "Driver={MySQL ODBC 3.51 Driver}; Server=localhost; Port=3306;
Option=0; Socket=; Stmt=; Database=db; Uid=root; Pwd=xxx;"
se...more >>
Calling stored procedure - JScript Posted by Roland Hall at 2/3/2006 12:00:00 AM I've never done this before using JScript. Having a little trouble finding
information on it.
Source:
var conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\\databases\\ado.mdb"
var comm = Server.CreateObject("ADODB.Comm...more >>
Help on db input to innerHTML after cbo_onupdate() Posted by Mr. Smith at 2/2/2006 12:00:00 AM Hi.
On an .asp page, after an user has changed the selected value in a combo box
(cboMyDistricts) I want the text in a textarea on the same page to change.
The text is retrieved from a recordset based on the cboMyDistricts value.
I know I can reload the same page with a input variable, but w...more >>
Logon-problems with asp to SQL-Database Posted by Albert at 2/1/2006 2:57:49 PM Hi,
i want to connect my asp-application to a database running on a ms-sql-2000-server. These application is running only in our intranet. I've selected on the SQL-Server and on the IIS the Windows- Authentification. If I connect MS-Access with the DSN to the database, it works without problems. ...more >>
Updating multiple rows in form still a problem Posted by Jack at 2/1/2006 10:25:29 AM Hi,
I got a form with multiple records. I am using the following method to
update all the records. However, the update is not working. When I am trying
to find out the sql statement generated, I am getting no output. The
following is the code:
<%
Dim CN, myDSN, sql_update, arr_ids
myDS...more >>
how to get the record with paramater query in access Posted by Kevin at 2/1/2006 12:00:00 AM Hi,
I defined in access a query for authentification with two parameters like
this:
SELECT id, name FROM table WHERE (name)=[na]) AND (pasw)=[pw]);
This works in access. I named this query "paswkl'
In ASP, i did this:
na=request.form("name")
pw=request.form("pasw")
set objdc = Server...more >>
ms access asp create table syntax problem Posted by marcus green at 2/1/2006 12:00:00 AM Hi,
I have an ms access database and need my asp code to create a table that has
a column type of currency. (similar as defined when you create such a column
directly in ms access). I can get the syntax to work fine for other data
types but not "currency". Can anyone tell me the correct synta...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |