Click here to Skip to main content
15,929,653 members
Home / Discussions / Web Development
   

Web Development

 
GeneralRe: Weird JavaScript Problem Pin
Philip Patrick23-Dec-01 7:15
professionalPhilip Patrick23-Dec-01 7:15 
GeneralRe: Weird JavaScript Problem Pin
Derek Lakin25-Dec-01 22:24
Derek Lakin25-Dec-01 22:24 
Generalquestion Pin
Steve L.19-Dec-01 13:19
Steve L.19-Dec-01 13:19 
GeneralMmm.... interesting question Pin
Philip Patrick1-Jan-02 9:50
professionalPhilip Patrick1-Jan-02 9:50 
GeneralRe: question Pin
Paul Watson19-Jan-02 8:30
sitebuilderPaul Watson19-Jan-02 8:30 
Generalsecurity of .ocx Pin
marutis16-Dec-01 19:00
marutis16-Dec-01 19:00 
Generalhelp....Using MS Index Server Pin
12-Dec-01 10:00
suss12-Dec-01 10:00 
Generalneed help w/ IIS 5.0 and Access Database Pin
12-Dec-01 8:41
suss12-Dec-01 8:41 
Hello everyone,

I have a couple of questions that I hope someone can help me with Smile | :)
Computer OS: Win2k Web Server: IIS 5.0

1. I am working on an ASP page that will access my Access Database so visitors will be able to search my site. It is going to search through a field with a Memo data type(thanks John!). I thought it would work if I used the following SQL statement:
"SELECT * FROM Content WHERE Contents LIKE '%search'" . I decided to use the "LIKE" statement for the following reason: I designed my database was to have a table called "Content" with two fields "Contents" and "Page". I entered the webpages content into "Contents" and put the name of the html document in the “Page” field. If the “LIKE” statement found the keyword it would do a Request.Write(search) in an HTML tag that the visitor could then click. My problem is it doesn’t work so I’m submiting what I have and maybe an undeniable great Guru and Programming expert such as John can help me.

<%
var search = Request.Form("Search_Form");
var oConn;
var oRs;
var filePath;
var Index;

var strsearch = "SELECT * FROM Content WHERE Contents LIKE " + " \' %" + search + " \' ";

var filePath = Server.MapPath("Search.mdb");

oConn = Server.CreateObject("ADODB.Connection");
oConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +filePath);

oRs = oConn.Execute(strsearch);
%>


<%
while (!oRs.eof) { %>

<% for(Index=0; Index < (oRs.fields.count); Index++) { %>

<% } %>

<% oRs.MoveNext();
}
%>

<% = oRs(Index)%>



My last question is on JavaScript. I have an html page that has a form. I want to get the data the user entered into the form in anouther part of the page. The problem is that I don’t know how to do that without having to do . I just want it to retrieve the value so I can use it in a calculation in another part of the page without reloading.. What I decided to to was to create a function with the onblur= ”get_form_data()”. I don’t know what the attributte for the data of the form is. Here is a sample:


function get_form_data(){
?????
}





Anyone who can point me in the right direction with either question will have my highest respect and admiration.
GeneralRe: need help w/ IIS 5.0 and Access Database Pin
Jon Sagara12-Dec-01 8:47
Jon Sagara12-Dec-01 8:47 
GeneralRe: need help w/ IIS 5.0 and Access Database Pin
Jon Sagara12-Dec-01 8:55
Jon Sagara12-Dec-01 8:55 
GeneralRe: need help w/ IIS 5.0 and Access Database (one more time) Pin
Jon Sagara12-Dec-01 8:58
Jon Sagara12-Dec-01 8:58 
GeneralRe: need help w/ IIS 5.0 and Access Database Pin
Jason Jystad13-Dec-01 5:36
Jason Jystad13-Dec-01 5:36 
QuestionMS Date and Time Picker. Bug? Pin
11-Dec-01 0:13
suss11-Dec-01 0:13 
QuestionScriplet and C# in asp.net, No integration??? Pin
ng ks9-Dec-01 23:03
ng ks9-Dec-01 23:03 
QuestionHow to use Split in ASP Pin
Gopi Krishna9-Dec-01 14:33
Gopi Krishna9-Dec-01 14:33 
AnswerRe: How to use Split in ASP Pin
Jon Sagara9-Dec-01 14:55
Jon Sagara9-Dec-01 14:55 
GeneralHTML executing DLLs Pin
john john mackey7-Dec-01 11:27
john john mackey7-Dec-01 11:27 
GeneralRe: HTML executing DLLs Pin
8-Dec-01 13:21
suss8-Dec-01 13:21 
GeneralFile Uploading Scripting Pin
A.R.6-Dec-01 7:47
A.R.6-Dec-01 7:47 
GeneralRe: File Uploading Scripting Pin
markkuk6-Dec-01 21:15
markkuk6-Dec-01 21:15 
GeneralRe: File Uploading Scripting Pin
A.R.7-Dec-01 4:48
A.R.7-Dec-01 4:48 
GeneralRe: File Uploading Scripting Pin
Troy Marchand7-Dec-01 4:37
sitebuilderTroy Marchand7-Dec-01 4:37 
GeneralRe: File Uploading Scripting Pin
A.R.7-Dec-01 5:07
A.R.7-Dec-01 5:07 
GeneralDisabling Back and Forward button of Browser Pin
Wolfram Steinke5-Dec-01 13:34
Wolfram Steinke5-Dec-01 13:34 
GeneralRe: Disabling Back and Forward button of Browser Pin
Ed K19-Dec-01 5:47
Ed K19-Dec-01 5:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.