|
Hello everyone,
I have a couple of questions that I hope someone can help me with 
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();
}
%>
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.
|
|
|
|
|
Geoffory Simmons wrote:
"SELECT * FROM Content WHERE Contents LIKE '%search'"
Try changing the LIKE clause to
LIKE '%search%'
(I've never done this, so I don't know if it will work for you)
Geoffory Simmons wrote:
I don’t know how to do that without having to do
Why wouldn't you do that? That seems like the simplest solution to me.
Jon Sagara
"There are lies, damned lies and statistics."
-- Mark Twain.
|
|
|
|
|
var other_var = Request.Form("othervar");
if ("" == other_var || IsNULL(other_var) || [validate other form variables])
{
}
else
{
... validate data
if (!valid)
{
}
else
{
}
}
I don't use JScript, so my syntax may be a little off, but I think this gives the general idea. Anyway, this allows you to use the <form method="post">-type form for your search field.
Jon Sagara
"There are lies, damned lies and statistics."
-- Mark Twain.
|
|
|
|
|
Geoffory Simmons wrote:
.
I can't believe I didn't catch this the first time...
"action" should be set to your search page. IOW, it should look something like this:
<form name="your_form" method="post" action="searchpage.asp">
Jon Sagara
"There are lies, damned lies and statistics."
-- Mark Twain.
|
|
|
|
|
For the JavaScript issue, I assume that you have some field(s) that the user is going to enter data into and you want to take the value(s) they enter and do some work with the data and display the results in another form field on the page.
You can fetch the data from another form field on the same page by accessing the value attribute of the form field via the DOM. Like so: document.{FormName}.{FieldName}.value where FormName is the name/id of the form and FieldName is the name/id of the field you wish to access.
I would recomend doing the work you wish to do with the data in a JavaScript function and calling it when you want to update the field(s) where you want to display the results.
The function can be called using the onChange event of the form field that the user changes. This works well if you have one field that you are using to update your calculated field. For example, if you had a tip calculator you would base the value in the tip field on the tip percentage and the total cost of the bill. in this case you would use the onChange event in both the tip percentage field and the total cost field to call the function that recalculates the tip amount. Then if the user changes either field the total will be recalculated.
If the data you want to display is calculated based on several fields and you want to update the other portion of the page only when the user fills out the fields and then clicks the submit button, but you do not want to actually submit the form, you can intercept the submit button using your function and update the other part of your page instead. You can still submit the form(s) later using JavaScript as well. I have to run and so I can not give a good example of this right now, but I can detail this later if you need me to.
I can provide actual code examples of whichever method you want to use, just let me know. I have to go fix some problems at a client site right now, but I will check in later so just post in answer to this and let me know which way you want to go. Then I will post actual code examples for you.
Jason Jystad
Cito Technologies
www.citotech.net
Sonork ID 100.9918
>-------------------------------------------------<
Every program has at least one bug and can be shortened by at least one instruction -- from which, by induction, one can deduce that every program can be reduced to one instruction that doesn't work.
>-------------------------------------------------<
|
|
|
|
|
On my web page i use activex date and time picker from microsoft. To display the picker i use the code that looks like this:
<object id="DTPicker" type="application/x-oleobject"
="" classid="clsid:20DD1B9E-87C4-11D1-8BE3-0000F8754DA1" codebase="mscomct2.cab#Version=6,0,88,4" align="center" border="0" width="100" height="25">
In the body of the page i have the following function, that sets the date to desired value like this:
The problem is, that on some pc's the data picker would be displayed, and on the others pc's it wouldn't. All the pc's have the same software: NT 4.0 SP6a, IE6, the same Vesion of Date and Time Picker ocx, and the security settings of IE6 are the same an all pc's.
Any ideas how to fix the problem?
Many Thanks for any responses!
|
|
|
|
|
I have an scriplet object defined in 'createservice.aspx' using the following code
<object data="editor.aspx" type="text/x-scriplet">
Where createservice have registered and inherits from src='createservice.cs' (code Behind), this file includes funtions to insert DB written in C#.
in editor.aspx, <IFRAME> is defined where user types in texts.
and editor.aspx is linked to compose.js using<script src="compose.js?169" language="javascript"></script>
1) My question is simple but took me hours, how to retrieve mytext.value from editor.aspx and to be use in createservice.cs(code behind), say like store in a string defined in createservice.cs,
2) should I declare the object in createservice.cs, but how to declare an OBJECT, i only know how to declare htmlTeatArea, htmlLabel and etc from the UI.webcontrols class from .NET framework
Thank you very much
regards, karsin
|
|
|
|
|
Dear Friends,
I have a doubt in using split function in ASP. My prb is:
I have a string str="Technology Business Finance Music"
Now i want each word in one variable, like
a1="technology" b="Business" c="Finance" like this. I know that I have to use Split function. but i don't know how to use it. Can any1 help how to write the code for this in ASP with the same function or with any different function.
Thanx in advance
Gopi
|
|
|
|
|
Documentation on Split()
Basically, you give it a string, give it a delimiter (in your case " "), and it will return a one-dimensional array that contains each token found in the string.
Jon Sagara
"Ninety percent of baseball is mental, the other half is physical." -- Yogi Bera
|
|
|
|
|
Hi,
I have never done this, but heard this is possible:
Remove comments for actual line.
When I try this, nothing happens and the results are the dreaded X-boxes (boxes with Xs) where the image should have appeared. I also tried just to execute the DLL by running the DLL with the arguments listed -- do I just replace '?' and '%' with blanks?
The .dll and .htm file are in the same directory. What gives????
Help.
Thanks,
Johnny
|
|
|
|
|
Have you registered the DLL yet? Right-Click(while holding Shift) and click Open With... Then, press the browse button and:
if using Win 9x, go under C:\Windows\System\regsvr32.exe
if using Win2k/NT go under C:\Winnt\System32\regsvr32.exe
Then, Un-Check the "Always use this program to open this type of File" and click OK. That should register it. Now try it again. Hope this helps.
-------------------------
I love Yuzu-Chan! =P
Have u eaten ur chicken 2day?
|
|
|
|
|
Hello guys,
I recently read a question in the forum regarding a server-side program to upload a file.
I have a question from the Client side point of view.
I'm developing an application to automate the filling of a particular form. This is a program in which there is no user interface at all (i.e. browser) but just communications (tcp/ip and http).
The problem is that there is a field which is an input element of type file. As you know, the value's attribute of this element is read-only from the scripting point of view (there is no way to fill this field's value through a scripting function).
My question is, does somebody knows how to tell the server application that there is a file ready in a specific location without typing in the field manually?
In other words, there is a way to set the value of this element through a function?.
Thanks much.
A.R.
|
|
|
|
|
With file select controls, the client is supposed to send the contents of the file in the body of the HTTP request resulting from submitting the form, it doesn't just "tell that there is a file ready". See Form Submission section of the HTML 4.01 spec
|
|
|
|
|
Yes Mark, that is exactly what I need to do. Send the contents of the file in the HTTP address request, but in an automated way.
To make myself clear, let's say that I need to send my users one page after the file has been uploaded in the server, trying to "emulate" a user's keyboard typing.
I already read the Form Submission topic, and all about the element specification.
Thank you.
|
|
|
|
|
What you are asking for is specifically blocked by browsers for security reasons. Otherwise it would be easy to try and get files from users machines without them knowing.
(ex. c:\Winnt\...)
One thing you can do is have an ActiveX control loaded into the browser. Then you can use the control programactically to send the file to the server. Such a control can be easily built using Dundas Software's TCP/IP product.
|
|
|
|
|
Troy thank you for taking the time.
I am working without a browser, but just at the communications level (i.e. no user interface at all). On the other hand, I'm not trying to get a file from a user's machine.
This is the scenario: I'm running an e-commerce site server. In this sense, I have my own server-side processes. One of my services is a report file generator, so when one of my users have been logged and requested this report, my server-side program creates this report and presents it in a PDF format. However, there is a special client which needs that my site (back-end process) could upload this report to his server. Unfortunately, he doesn't know anything about FTP. In his site, once you have logged in, there is a form which presents this to type or through the browse button specify the file to be uploaded.
Okay, with this in mind, what I want to do is just automate this process, to eleiminate the need of loggin with username/password and go step by step just to upload the file.
Up to this point, my program loggs in and passes every page perfectly (again, without a browser) but in this specific page it fails. I do not know how to send the content of the file through the HTTP request. If you know some literature about multipart/form-data submissions I will appreciate teh reference.
I develop all my server-side programs in C++, and just the client-side is JavaScript, DHTML & HTML.
Thank you again.
|
|
|
|
|
Is there a way to disable the Back and Forward buttons when a page is first loaded, without having to launch a child window?
Happy programming!!
|
|
|
|
|
There really isn't a way to totally disable Back and Forward. You can expire pages using the following:
<meta http-equiv="Expires" content="Fri, Jun 12 1981 08:20:00 GMT">
<meta http-equiv="Pragma" content="no-cache">
<meta http-equiv="Cache-Control" content="no-cache">
Doing this can sometimes frustrate the user. If you are having trouble with users backing up then resubmitting...which can cause duplicates in the database or something, try setting a 'trigger' in session which is set when the page loads. On submit, if the trigger is present, remove the trigger, process the request and move the user on. If the user backs up, and resubmits, there is no trigger, don't process again (or edit the previous entry however you want to handle it) then move the user on.
Hope this helps.
ed
'Love is an obsessive delusion that is cured by marriage.' Dr. Karl Bowman
|
|
|
|
|
I was wondering about some functionality with asp code. Does asp have the availability for drag-n-drop functionality? When I drag and drop do I need some sort of stored procedure to update the table? Also, can you make things double click with asp? If so I would appreciate the code that would make this work. Thanks!
Matt
|
|
|
|
|
Drag and drop to where?? ASP is a server-side language, it is not a language I'd say. You just pick up your scripting language (VBScript as a default) and go ahead.
But drag and drop... The ASP code is working when the user (client) is NOT seeing the resutlant HTML page... So nothing to drag and nowhere to drop.
But with CLIENT-side script you can do it of course, using any of scripting languages (JavaScript, JScript or VBScript)... but this is not ASP
Philip Patrick
"Two beer or not two beer?" <shakesbeer>
Web-site: www.saintopatrick.com
|
|
|
|
|
Hi,
I wanna put a link at the front page of web site that the user should click to set my website as his IE Start Page. I know how to do it using .reg files, but i do wanna use it.
Can anybody help me?
Thank u very much,
Dirso
|
|
|
|
|
I suggest U use java script to do that. This is the script.
Farhan Faisal Zakaria
Malaysia
|
|
|
|
|
|
I am very very new Babie in Java Script. I want to disable the Maximize Button of the newly open Window through window.open(" "," ", options) In Microsoft Internet Explorer 5.
I already used resize = no. but it dose not work.
Thanks in advance.
|
|
|
|
|
Try resizable=no instead of resize=no. Also no spaces are allowed in the optionstring (I think IE5 can handle spaces though).
This works on IE6:
Window.open("myPage.htm","myExample","menubar=no,resizable=no,width=200,height=200");
/moliate
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
