Why does a page with many pictures get wider?
export data from asp to .mdb?
Hello Guest		   
  • Login
• Register…
• Start blog		   • Who, Where, When
• What can I do?
• What to Read?		   • Polls
• Avatars
• Interests		   • Cities and Countries
• Random blog
• Users search		   • Search
• Games
• Tests
• QAIX		   • Сообщества
• Talxy Chat
• Horoscope
• Online		  
Зарегистрируйся!
QAIX > ASP web-programming > export data from asp to .mdb? 7 March 2006 18:30:27
  Recent blog posts: 
The song my brother thought me
Don't let your heart be hardened Don't let your love grow cold May it always stay so childlike May it…

My brother thought me this…
God grant me the serenity to accept the things I cannot change; courage to change the things I can;…

baz-baz-baz-baz pam-parabaram…
baz-baz-baz-baz pam-parabaram baz-baz-baz-baz pam-parabaram baz-baz-baz-baz pam-parabaram-baz ba-ra-ba…

Blackfriday&Cybermonday…
:-D­ Today is Thanks giving; Blackfriday&Cybermo­­nday is very close to us now. And…

Harvest your surprise on…
Harvest your surprise on Thanksgiving Day – more discount at Nidesoft…

Blackfriday&Cybermonday…
Blackfriday&Cybermon­­day Software special offer lists: Today is Thanks giving;…

BlackBerry Storm VS iPhone 3G…
Recently I had published a side-by-side comparison of the iPhone 3G and T-Mobile G1 which evoked an…

Review on TuneClone Audio…
There is an in-depth review of TuneClone Audio Converter&hellip­;

How to make a Christmas photo…
Every Christmas people take a off from their busy schedule. This is the time they can enjoy with their…

Car web design, motorbike…
If you are looking for Car website design, Auto web design, bike web design, or anything similar our…

  Forums:   
    topic feeds

• QAIX  all topics, blogs and comments

• PHP web-programming

• Perl web-programming

• ASP web-programming

• Visual Basic Programming

• .Net Development

• C/C++ Programming

• Java Programming

• Javascript web-programming

• Apache HTTP Server

• Web-design

• Web-hosting, dedicated, colocation

• HTML web-programming

• XML development

• General Web-programming

• Content Management Systems

• ColdFusion

• Search Engine Optimization

• Hardware

• Software, Computer Help

• MySQL database development

• PostgreSQL database development

• MS Access database development

• Oracle database development

• MS SQL database development

• Informix database development

• Buy / Sell

• Open discussion

• Anonymous
  Discuss: 
Converting number to percentage…
Hi Im Leo I want to convert a number to percentage, is there any built-in function for this? Thanks

RE: Jason Gilbert, CTO of…
I have been searching for an old friend with the same name and age - Jason Gilbert. I am upset that…

Select Records between…
I've built a Point-of-Sale using "classic" asp (it's what I know) and I'm trying to get daily…

ASP access to Data on Remote…
Good Morning Folks I have a LAN Among the several connections to it are the following four devices: A…

ASP to Word send by ObjSendMail…
Hi I can get the data I need from my DB and show it on screen fine. One user has asked if I can have…
  Recent forum topics: 
Expiration of your subscription…
Thu, 18 Sep 2008 06:00:05 Your subscription to the DOTNET-CLR list has expired and you have failed to…

SQL Server 2005: CLR functions…
I was playing around with the new SQL 2005 CLR functionality and remembered this discussion that I had…

VivaMP for OpenMP
OOO “Program Verification Systems” Company informs you that the first beta-version of static C/C++ code…

Mailing-list
Hi! Thanks for all good information and help I'v got throw all contacts in the mailinglist…
  Recent forum comments:
RE: neopets hacking
All is to do send me your username and password and pin (if you have) to the following email…

RE: DBI w/Multiple mysql installed…
On Wed, 26 Nov 2008 12:36:28 -0700, Anthony DeMatteis <adematteis@commspe­ed.net> wrote…

RE: Files, Directories, Resources…
Can I just remind everyone that (IMO) we shouldn't just be considering filesystems here? I think it…

RE: Re: [perl #60828] [BUG] ^@list…
On Wed, Nov 26, 2008 at 08:54:50AM +0100, Moritz Lenz wrote: : : : Patrick R. Michaud wrote: : >…

RE: Files, Directories, Resources…
Tom Christiansen wrote: AFAIK, modern databases are all strongly typed at least to the point that the…

RE: Re: [perl #60828] [BUG] ^@list…
On Wed, Nov 26, 2008 at 06:21:22PM -0800, Larry Wall wrote: +1 to the idea that ^@list is the same as…

RE: Files, Directories, Resources…
In-Reply-To: Message from Darren Duncan <darren@darrendunca­n.net> of "Wed, 26…

RE: Files, Directories, Resources…
In-Reply-To: Message from Mark Overmeer <mark@overmeer.net>­ of "Thu, 27 Nov…

RE: Files, Directories, Resources…
Just as a variable name in perl6 must conform to a standard and abide by a set of constraints, why…

RE: Files, Directories, Resources…
Hi, First of all, sorry for breaking the thread, but I had some trouble with my mail provider, and…
  Moderators:
 Administrator
 Protorioris

export data from asp to .mdb?

Mr Pen 7 March 2006 18:30:27
 Hi

I am currently trying to get a simple data submission asp form to export
data to an access database, this is the code for the contact_insert page

<html>
<head>
<meta http-equiv="Content­-Language" content="en-us">
<meta http-equiv="Content­-Type" content="text/html;­ charset=windows-125­2">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.­Editor.Document">
<meta name="Company" content="Kalptaru Infotech Ltd. [www.a2zhelp.com]">
<title>This page was generated using ASP Helper [www.a2zhelp.com]</t­itle>
<style>
<!--
td { font-family: Tahoma; font-size: 8pt; background-color:
#E6F2FF;
border-style: solid; border-width: 1 }
th { font-family: Tahoma; font-size: 8pt; font-weight: bold;
background-color:
#E6E6E6; border: 1px outset #FF9900; }
input { font-family: Tahoma; font-size: 8pt; border: 1px inset
#E6E6E6; }
table { }
-->
</style>
</head>
<body>
<table border="0" cellpadding="2" width="100%">
<tr>
<td colspan="3" width="100%">Adding­ data to the database</td>
</tr>
<tr>
<td width="10%"></td>
<td width="80%">
<%const DATABASE_NAME="bigb­rother.mdb"
dim Con
set Con=server.createob­ject("ADODB.Connecti­on")
Con.open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="&
server.mappath(DATA­BASE_NAME) & ";User Id=Admin;Password="­
%>

<%'-------Getting Name
dim Name
Name=Request("Name"­)
Name=Replace(Name,"­'","''")%>
<%if trim(Name)="" then
bHasError=true
sErrMessage=sErrMes­sage & "<LI> Name cannot be empty."
end if%>
<%'-------Getting Email
dim Email
Email=Request("Emai­l")
Email=Replace(Email­,"'","''")%>
<%if trim(Email)="" then
bHasError=true
sErrMessage=sErrMes­sage & "<LI> Email cannot be empty."
end if%>
<%'-------Getting Query
dim Query
Query=Request("Quer­y")
Query=Replace(Query­,"'","''")%>
<%if trim(Query)="" then
bHasError=true
sErrMessage=sErrMes­sage & "<LI> Query cannot be empty."
end if%>
<%if bHasError then%>
<table><tr><td colspan="2" align="center"
width=100%><%Respon­se.Write("Sorry we cannot proceed because of the following
errors") %></td></tr>
<tr><td colspan=2 width=100%><%respon­se.write
sErrMessage%></td><­/tr></table>
<%else%>
<%Dim sSQL
sSQL ="insert into [Contact]([Name],[Email],[Query]) values( " & "'" & Name
& "','"&Email&"','"&Q­uery&"')"
con.Execute sSQL
%>
Congratulations!!! Database was successfully updated.
<%End if
%></td>
<td width="10%"></td>
</tr>
<tr>
<td colspan="3" width="100%" bgcolor="#FF9900">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td bgcolor="#E6E6E6">
<p align="center"><fon­t face="Tahoma" size="1"
color="#0000FF"><br­>
This
page was automatically generated using Kalptaru Infotech Ltd's ASP
Helper, <br>
the automatic ASP Code generation software.<br>
For more information on how to improve the efficiency and speed of
your ASP Programming and to know more about ASP Helper visit <a
href="http://www.a2­zhelp.com">www.a2zhe­lp.com</a>
or send an email to <a
href="mailto:asphel­per@a2zhelp.com">asp­helper@a2zhelp.com<b­r>
</a>
</font></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>

and this is the error message i get:

Technical Information (for support personnel)

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.
/contact_insert.asp­, line 65


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)

Page:
POST 81 bytes to /contact_insert.asp­

POST Data:
Name=paul&Email=pen­@hotmail.com&Query=h­ow+much+is+that+reco­rd+in+the+window%3F.­..

Time:
07 March 2006, 15:11:00

any help would be gratefully appreciated

paul
Add comment
 

Add new comment

As:
Login:  Password:  
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.

QAIX > ASP web-programming > export data from asp to .mdb? 7 March 2006 18:30:27
see also:
[News & Announcements] - service outage…
[Security & JAAS/JBoss] - J2EE…
[JBoss Portal] - cms portlet and…
пройди тесты:
see also:
I think, I mustn't change my blog.....
dvdsanta
Presentation
  Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:
If you would like to report an abuse of our service, such as a spam message, please .