 |

02-21-2006, 03:04 AM
|
 |
SEO Junior and a half
|
|
Join Date: Feb 2006
Posts: 37
|
|
Siple asp code
want a code for connecting a text field from a database and then retrieving the data and displaying it in the text field in a web page
|

02-21-2006, 02:42 PM
|
 |
SEO
|
|
Join Date: May 2005
Location: England, UK
Posts: 621

|
|
Hi dude
Obviously I have no idea what type of database your using, so I'll assume you've created a system DSN and refer to that.
Hopefully you'll be above to figure out the other example assumptions I've made. The code itself is very simple:
Code:
<%
set rs = server.createobject("adodb.recordset")
rs.open "select * from tbl_clients order by surname", "DSN=mydatabase", 2, 3
%>
.
.
.
<input type="text" id="surname" name="surname" value="<%=rs("surname")%>">
.
.
That should do it.
If you need anything more specific, let us know?

|

02-21-2006, 09:13 PM
|
 |
SEO Junior and a half
|
|
Join Date: Feb 2006
Posts: 37
|
|
Thanks for your quick reply. i am using ms access database .mdb format(200).
The name of table is vivek
The name of the field is data.
Please reply.
|

04-03-2006, 01:43 AM
|
 |
SEO
|
|
Join Date: May 2005
Location: England, UK
Posts: 621

|
|
With all respect, if you can't figure it out from the above example, then you've got more problems than I have time to deal with I'm afraid.

|

07-12-2006, 08:13 AM
|
|
SEO
|
|
Join Date: Jul 2006
Location: India
Posts: 450
|
|
|
Are there any benefits of using ASP over PHP. Well I use PHP for my form handling so whats the difference in them.
Akash Kumar
|

07-12-2006, 08:20 AM
|
 |
SEO
|
|
Join Date: May 2005
Location: England, UK
Posts: 621

|
|
I'm actually not sure what the correct answer to that might be - I suspect it may be speculative.
I use ASP because all my corporate clients want me too. At the corporate level, there much more support for it than PHP.
I would actually like to know the definitive critical differences too.

|

07-12-2006, 10:07 AM
|
 |
SEO GUY Moderator
|
|
Join Date: Sep 2004
Location: Antalya, Turkey
Posts: 4,112

|
|
|
Well perhaps I can add my thoughts from an SEO perspective.
PHP (Linux) hosting's a lot cheaper than asp (Windows), especially if you need SQL.
It's my view that Linux sites are inherently more SEO friendly than many asp sites because of the ease and flexibility of the htaccess file for redirects, rewrites, filename parsing etc.
There are a lot more free, quality, php scripts for forums, directories, etc...
I much prefer doing SEO on sites based on a Linux server, but it's true that many clients are using asp, aspx etc. now.
Cheers,
Paz.
__________________
10.3 million entries for Hotels in Turkey but I'm still chipping away.
|

07-12-2006, 07:19 PM
|
|
SEO
|
|
Join Date: Jul 2006
Location: India
Posts: 450
|
|
|
Thanks Paz for you opinion. I am glad to know about this.
Akash Kumar
|
 |
| Thread Tools |
|
|
| Display Modes |
Rate This Thread |
Linear Mode
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
|