|
response.write(Searchvar)
SQL = "SELECT * FROM MYDB WHERE DESCRIPTION LIKE '*"Searchvar"*'"
The response.write(Searchvar) returns the correct text i.e. ARTICLE
BUT my SQL statement returns the FULL DB every time? Where is my SELECT statement going wrong?
Just wnat to limit the result to all records with the string ARTICLE in the DESCRIPTION TABLE. i.e. IF the field is "THIS ARTICLE IS BLUE" it should display that record
this is me
|
|
|
|
|
Are you really sure that this code is runnable at all? You really should get a syntax error trying to run it.
You have forgotten the & operator for concatenating the strings:
SQL = "SELECT * FROM MYDB WHERE DESCRIPTION LIKE '*" & Searchvar & "*'"
---
b { font-weight: normal; }
|
|
|
|
|
Hi,
I want to retrieve and process messages from a BLAB 2.4 chat box/system. I can program the processing part myself. Can someone help me to find (C++ or Java) code to retrieve messages that appear in a BLAB chatbox ? I suppose someone has done this part before, but I can't find it on the Internet.
Thanks and regards,
esjoba
|
|
|
|
|
I am in the process of building my 1st web site.
I have included a 'Contact Us' page for feedback using Mailto:
This works fine when testing on my hard drive. But I need to tune my Internet Explorer settings to stop some of the warning windows popping up.
My questions are as follows:-
1. Is the Mailto: facility safe to use; i.e. when my site is placed on a server will anyone be able to save it to their hard drive and get my e-mail?
2. What is the best way to place on my page a way of contacting us should there be a setting to ban/disable the Mailto: option.
3. I plan to pay for hosting my site, now are the e-mails specifed on the web pages translated or mapped to prevent spamming etc.
Any good guides in this area?
|
|
|
|
|
If you mean by safe that the email address is protected in any way, then no. The email address is completely visible in the html code, and very easy for anyone to harvest, either manually or using a program that automatically scans pages for email addresses.
The mailto option is just an instruction for the browser to use the clients mail program to send the form. This of course requires that the client has a mail program installed, and properly configured as default mail handler. Most people does, as this is available as a standard feature in Windows (Outlook Express). If the computer is in public use, e.g. in a library or similar, there is most likely no mail program installed.
The best way of safely putting a contact form on a page is to use server code (ASP/PHP/JSP/ASP.NET) to put the form data in a mail and send it. Every web hotel has some kind of mail component installed that you can use for sending the mail.
---
b { font-weight: normal; }
|
|
|
|
|
My answers to your numbered questions are (in that order itself):
(1) Definitely not. Spammers can harvest email addresses in mailto: pattern. Atleast have a garbled email address and a simple JavaScript to trigger the link invocation.
(2) A serverside recieving form with a good CAPTCHA to prevent automated submissions.
(3) It depends on how best you configure your Contact page.
Vasudevan Deepak Kumar
Personal Web: http://vdeepakkumar.netfirms.com/
I Blog At: http://deepak.blogdrive.com/
|
|
|
|
|
Hello
When executing my script, I get this error. I dont understand what the error is about....
Could anybody explane to me what it means
"The callee (server [not server application]) is not available and disappeared; all connections are invalide. The call did not execute"
Spaz
|
|
|
|
|
|
|
|
Yes, I found this is the System section of the event log:
Event Type: Error
Event Source: DCOM
Event Category: None
Event ID: 10016
Date: 28/07/2005
Time: 11:22:37
User: MHPC1355\IWAM_MHPC1355
Computer: MHPC1355
Description:
The description for Event ID ( 10016 ) in Source ( DCOM ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: machine-default, Local, Activation, {A9E69610-B80D-11D0-B9B9-00A0C922E750}, MHPC1355, IWAM_MHPC1355, S-1-5-21-109908550-2121663905-1444114214-1004.
|
|
|
|
|
Got a asp page. (DB search page) in one frame.
BASIC db with a single search on one field and passed back to same page. (So page refreshes with new search result) NOW I need to just build an array that STAYS and gets added to even if you do another and another and another search (Just to track what elements in DB was selected in each search page) and then display the array in a second frame on the page after each selection was made? IS THIS EASY ENOUGH??? Any help would be appreciated. New to this line of coding. 
this is me
|
|
|
|
|
You can use javascript to send a string or array to the other frame, and in a function in that frame handle the collection of items.
Example:
Script to send a string of id:s to the other frame:
top.otherFrame.addItems('4,7,18,42');
Script in the other frame that adds the id:s to a string:
var items = '';<br />
<br />
function addItems(id) {<br />
items += (items.length?',':'') + id;<br />
}
This is just a method for sending the data. If you want to display anything in the other frame, you have to add code for that. Perhaps you need to reload that page in order to get more information about the items than just the id.
---
b { font-weight: normal; }
|
|
|
|
|
Thanks for the quick responce again. Will try this tonight.
Can I then just do a page refresh IN that script code (I am just using VB at the moment all though almost all my previous coding experience is in c++ (Java etc))
function addItems(id) {
items += (items.length?',':'') + id;
(PAGE REFRESH THINGY
}
What would be the page refresh code then? I assume there is simply a sinlg line of code to do this? THUS when something gets passed to this page as in the first part, then this will update the array and then refresh the page??? I HOPE?
this is me
|
|
|
|
|
Yes, you can for an example pass the string of id:s in querystring to the new page:
window.location = 'MyPage.asp?items=' + items;
---
b { font-weight: normal; }
|
|
|
|
|
Sheesss but you guys (oor maybe jsut you) really do know how to help a guy out.. THANKS again for the quick responce.
OK I get the first posting you made and makes sence, but do I need to do the querystring pass or can I do it like first post only and then just refresh the PAGE 2 to display the updated array each time data has been passed to this PAGE?
Mmm.. OK. So if I have one page (DB search) I can then send info from there to other page (SAME HTML FRAME SET IN DIFFERENT FRAMES) and update an array in the second frameset (second page)
PAGE 1 is DB ( wILL NOT PASS db fIELDS OR ANYTHING LIKE THIS BUT THE SELECTION ON this page needs to be passed to PAGE 2's array)
PAGE 2 is RESULT
IF PAGE 1 send info to page 2 (FORM let's say)
PAGE 2 GETS INFO AND AMENDS the array (ADDS to what it had before)
So you can change PAGE 1 (DO MULTIPLE SEARCHES one after other) AND EACH RESULT PAGE SEND DATA TO PAGE 2 and PAGE 2 UPDATES the array (Not start a new array again)
PAGE refresh will then on the PAGE 2 show the arrays NEW data after each FORM DATA send from PAGE 1.
this is me
|
|
|
|
|
If you want to reload the second frame, you have to send all the accumulated items in the request. You can do this either using a hidden field in a form and posting the form, or passing it in querystring.
You can use the value from the querystring to get the records from the database:
strSQL = "select id, foo, bar from theTable where id in (" & Request.Querystring("items") & ")"
Put the previously accumulated items in a string in asp and write it out in the javascript. Something like:
<%
strItems = ""
While not rs.EOF
strItems = strItems & "," & rs("id")
rs.MoveNext
Wend
strItems = Mid(strItems, 2) 'remove first comma
%>
var items = '<%=strItems%>';
When you call the function that will reload the page, it will add the new items to the previously accumulated items, and send them all back in the querystring.
---
b { font-weight: normal; }
|
|
|
|
|
Something in the function when adding to the array that just says
this.refresh = refresh ???
Not going to work???
this is me
|
|
|
|
|
What do you mean? What is that code supposed to do?
---
b { font-weight: normal; }
|
|
|
|
|
OK in more detail I have this.
Pricelist.asp ASP page that simply does a shirt on the DB and displays the result in same page
Choices.asp Frame to display the accumilative choices made in the pricelist.asp frame
Price.htm the frameset containing the two ASP pages.
Now user sees the two ASP pages and can then elect a qeury in pricelist.asp (In the TopFrame)which returns the result in the same frame (page) he can then select one or more of the qeury results and click a submit button which will then pass this result to the Choice.asp page (In the MainFrame) where that result gets added to the allready there array and displyed as soon as it has been updated.
A this stage I know what I want passed etc and can get that into place, but passing seems to be done to the wrong page or frame or something ?? What would the pass be to the Mainframe on the Price.htm be? Is it Price.MainFrame or would it be just Mainframe from the Pricelist.asp or would it be Choice.mainframe or just choice I am clueless.. Sorry for this HELLUVA long thing, but sure you now know what I need? PS and any chance of keeping the answer for me in VB?? Not serious, but would help. I assume I can then pass the results from a form in Pricelist.asp to a Procedure in Choice.asp????
THANKS AGAIN FOR ALL THE HELP.. JSUT NEED THIS SORTED AND I CAN GET MY WEBSITE UP THEN.. REST IS WORKING FINE.
this is me
|
|
|
|
|
As I wrote earlier in the thread, you can use this to call a javascript function in a different frame:
top.otherFrame.addItems('4,7,18,42');
Where otherFrame is the name of the frame and addItems is the name of the function. Just substitute the name of the frame you want to reach, and the name of the function you wish to call.
---
b { font-weight: normal; }
|
|
|
|
|
Hi:
Confused. With Visual Studio .NET, don't we have that Dependency Walker (depends.exe). A full search of hard disk does not reveal it. Should we necessarily install MSDEV (VS 6) for this.
Perhaps if there was a Sourceforge.net or some freeware too, that would be great.
Deepak Kumar Vasudevan
Personal Web: http://vdeepakkumar.netfirms.com/
I Blog At: http://deepak.blogdrive.com/
|
|
|
|
|
Hi:
I am trying to package a OCX file into a CAB file using the Setup and Deployment project in Visual Studio .NET.
I wanted to know how to find the dependencies that the OCX might depend on and how to include them or direct the web browser to automatically download them from the parent website or from Microsoft itself.
Perhaps I would like to present an example like if some custom specialized Win32 library of XP being used and for Win2k, if OCX needs it, I need to package it or direct the OCX to download it. Is'nt it?
Particularly, I encountered an issue with GDIPlus.dll being not found in Win98 PCs and hence the ActiveX Control could not load in Win98 IE.
Please advise...
Deepak Kumar Vasudevan
Personal Web: http://vdeepakkumar.netfirms.com/
I Blog At: http://deepak.blogdrive.com/
|
|
|
|
|
Hello All!
I am new to the javascript language and am needing some assistance with the syntax. I need to write a script that will capture the user's NT Login information. I don't need the password, but I do need the user name and domain name if necessary. so that I can run a query through ColdFusion to my Oracle Database's user table.
Can someone tell me what that syntax is or a really good Javascript language book with great examples on how to capture this data?
I have done this same thing using .NET Asp and storing the information in Session variables, but at this time that is not the language that is being used. So I would really appreciate any suggestions and help.
Thanks!!!
:->
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
