all groups > inetserver asp db > may 2007
About update access database data by using ASP
Posted by yuling3086 at 5/23/2007 12:00:00 AM
Hi All,
I have a web that i need to update several table at a page and at the same
time when user click on the update button.May I know that how to speed up the
update process?I am using Access database.
Please advice.
thanks
... more >>
Why Access database inside my web server keep on corrupted
Posted by yuling3086 at 5/23/2007 12:00:00 AM
Hi All,
Can any one tell me that why my access database inside my web keep on
corruptted and some of my code also corrupted is it regarding with the code
that I write or the server problems?
Please advice me on this.
thanks
... more >>
Q: How to send long SQL Statements via ODBC? And: sql-Injection possible in ASP?
Posted by marco at 5/20/2007 5:26:26 AM
Hi,
in an classic ASP with SQL Server 2000 I'm old-stylish generating SQL
Statemnents in vbs code and send them then via conn.execute. The
statements are packend in a transaction.
>From a vertain Stament length on, Statements are not executed on the
Server. If the same Statement is copied i... more >>
need ASP Code - Send mail via POP3
Posted by Gragi at 5/17/2007 9:52:34 AM
Hi,
Can anybody post me the sample code to send email using ASP via POP3
server.
Thank You,
Gragi
... more >>
Scripting.FileSystemObject (Problem with Windows 2003 R2)
Posted by Michael Kintner at 5/14/2007 10:04:47 AM
Strange thing happening with Windows 2000 to Windows 2003 R2
This ASP script below is sitting on a Windows 2000 IIS Server Box and the
fldr was pointing to \\Bradford2\temp which was a Windows 2000 server and
worked great, now I changed the fldr to point to \\Bradford7\temp which is a
Windo... more >>
Data Source Name
Posted by SK at 5/13/2007 6:23:25 PM
Hi All
Can anybody explain how to connect databse and visual basic code. I
want to make setup disk for VB Program . Every time I want to create
DSN on customers PC when installing setup. I would like to include in
VB code .
... more >>
ADO with Access problem.
Posted by Aldred at 5/11/2007 12:00:00 AM
Hi,
I am searching for answers for days but I still couldn't figure out what's
wrong. I am hoping someone could help me out.
I have a connection string like this:
set conn=Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Inetpub\wwwroot\db... more >>
Distinct records and NEWID()
Posted by Adrienne Boswell at 5/10/2007 2:32:37 PM
Using SQL 7 and classic ASP -
Here's my query:
SELECT TOP 7 f.id, v.vendor_ipk, featured_image_path FROM
featuredselection f, view_vendor_default v WITH(NOEXPAND) WHERE
f.vendor_id = v.vendor_ipk AND f.status = 'A' ORDER BY NEWID()
Here are my results:
id vendor image
402 432
s... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Help needed .... Access db - InterDev
Posted by BobTheBowler at 5/9/2007 6:32:08 AM
Hi
I wrote a website about 8 years ago - http://www.ProBowkUK.co.uk
It has an Access database of web links and a number of pages that
show the different categories.
ex: http://www.ProBowlUK.co.uk/pblOrgs.asp
I may need to make a lot of changes to the website.
Although these ... more >>
SQL data
Posted by Raz at 5/7/2007 9:50:04 AM
Hello,
I have setup a session id that pulls up the current record that is selected
from the asp page, but somehow the last record is always being pulled up.
Any ideas why? Code is below. ASP Page1 is the page where user clicks to
retrieve data from SQL and ASP Page2 displays the data. Thank... more >>
access_asp Error Type:ADODB.Recordset (0x800A0CB3)Current Recordset does not support updating. This may be a limitation of the provider, or of the sel
Posted by jksharmadelhi NO[at]SPAM gmail.com at 5/6/2007 1:41:57 PM
CALL OPENDATACON
DIM RS
SET RS=SERVER.CreateObject ("ADODB.RECORDSET")
s="select * from dbpassenger order by ref_no"
CALL OPENRS(RS,S)
DIM RS1
dim aa
SET RS1=SERVER.CreateObject ("ADODB.RECORDSET")
s="select * from dbfare where flight_id='" & session("fid") & "'"
CALL OPENRS(RS1,S)
if rs.R... more >>
Problems writing to database from ASP.NET
Posted by Harrison Schofill at 5/3/2007 1:07:01 PM
I've got a developer who is running into problems getting a web app to write
to a SQL database. I am posting his error message. Any ideas?
Server Error in '/CTRS Web' Application.
--------------------------------------------------------------------------------
Could not find a pr... more >>
Displaying images
Posted by d9839742 at 5/2/2007 4:22:02 AM
Here is my problem I am qute new to asp, I have an access database with a
text field pointing to the URL of the images I want to display.
The asp I'm using to try and display the images is below:
<%
Dim Conn
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Provider = "Microsoft.Jet... more >>
|