|
Hi,
You can handle the event onselect for first listbox like this :
....
function MyFunction()
{
List2.length = newLength;
for(i = 0; i <= newLength; i++)
{
List2.options(i).value = newVal_Value;
List2.options(i).text = newVal_Text;
}
}
You can set newLength, newVal_Value and newVal_Text values according with the selected item in the List1 :
List1.options(List1.selectedindex).value
Good luck
|
|
|
|
|
Hi,
I figured out a way to execute applications, namely computer games such as the quake series and unreal tournament, by creating a file class in the registry that you that then create a url to, e.g. instead of file://myfile.txt, you could create a class and just put
myfile://param1 param2
so this works well for triggering games from a page. Alas - I need to figure out how to change the directory before executing the app. Any ideas? [and vb's chdir isn't the answer - it's not a script thing, its a setting in the registry's class that you create - I just cant find it]. ta
sim
|
|
|
|
|
Hi,
How to place site icon in IE Address text box like you can see in Hotmail.com?
Thank in advance.
|
|
|
|
|
assuming you have your site www.mysite.com, then in the root, put a file favico.ico [i think] - this will be downloaded onto clients pc's quickneasy so you get your own custom icon on ppls pcs
|
|
|
|
|
Try favicon.ico - Cristi added one to CodeProject.com and it works a treat.
|
|
|
|
|
Hi Chris,
Can you provide me the URL?? CodeProject has so much article..So little bit difficult to track.
One more ... I don't either it works in Netsacpe or not...? (I have no Netscape!!
|
|
|
|
|
There is no URL - you just need to create an icon for your site, call it favicon.ico, and place this in your website's root directory.
|
|
|
|
|
Chris,
Why don't you write it up as a simple article? Seems like enough people would be interested.
Also, I see the stanard IE logo beside codeproject.com in my address bar? What am I doing wrong?
|
|
|
|
|
Hi Chris,
I had already placed my icon named favicon.ico. But still I can't get my ICON in my IE address.
IE version 5.00.xx
Web Server: Apache (Latest!!)
Thanks for you help.
Regards,
Sarose Joshi
@YSGNet*
Nepal
|
|
|
|
|
To have the icon display in IE5 you need to add the site to your 'favorites' list. For some reason the icon that we had was doing some weird things, but Cristi has kindly reworked it and it seems to work fine for me now.
Easiest way to demonstrate it is to go back to the CodeProject homepage and click on the "Add to Favorites" link (top left hand corner) to add CodeProject to your favorites. The icon should appear next time you visit the homepage.
There are a couple of other ways you can specify favicon's so I guess I'd better write up an article 
|
|
|
|
|
I need to make a script I wrote work in older versions of netscape. How can i set the inner html of a layer tag in javascript?
|
|
|
|
|
I'm not 100% sure but I think that these commands do the same thing in IE and Netscape:
*IE: object = document.all["objectName"];
object.innerHTML = ".......";
*Netscape: object = document.layers["objectName"];
object.document.open();
object.document.write(".......");
object.document.close();
|
|
|
|
|
Hi all,
I am trying to develop a search Engine that can rank
the search result like if I search using "Travel in Nepal",
The search will display the best matching with percentage
like you can see the MIT search engine.
If you have any idea, suggestion, links, hints or whatever please reply.
TIA
Regards,
Sarose Joshi
|
|
|
|
|
Are you talking about an internet search engine, or just a search engine for your site? IIS Index server gives you a rank. I'll be writing an article on it soon.
cheers,
Chris
|
|
|
|
|
Hi Chris,
Actually, I need to rank the result like if someone search using word like "Travel in Nepal"... I need top ten result. Can you provide me simple ANSI SQL or any hints.
Thanks
Sarose
YSGNet*
Nepal
|
|
|
|
|
|
Chris & Uwe.
You guys do realy a great and fantastic job ! The CodeProject has become one of my favorite sites, not only because of the success of my own article
I enjoyed reading your scripts and wistfully waiting for e.g. the comment scripts.
Keep on with your work !!!
|
|
|
|
|
Thanks Tom - it's messages and emails like yours that make it worth it!
...plus it is a load of fun building something like this
cheers
Chris
|
|
|
|
|
|
|
Can anybody help me?
The very simple below code doesnt work. It returns a following error:
"Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
"MYDATABASE" is a access database. And "number" is a integer.
THANK YOU, JARMO
The code:
<%
dim objConn
dim objTimes
dim strQuery
Set objConn = Server.Createobject("ADODB.Connection")
Set objTimes = Server.Createobject("ADODB.Recordset")
objConn.Open "MYDATABASE"
strQuery="INSERT INTO Contacts (Number) VALUES (15)"
set objTimes = objConn.Execute (strQuery)%>
|
|
|
|
|
The Code, which dropped:
dim objConn
dim objTimes
dim strQuery
Set objConn = Server.Createobject("ADODB.Connection")
Set objTimes = Server.Createobject("ADODB.Recordset")
objConn.Open "HIERONTA"
strQuery="INSERT INTO Contacts (Number) VALUES ('15')"
set objTimes = objConn.Execute (strQuery)
|
|
|
|
|
Well, first off, you don't need to create a recordset when all you are doing is INSERTing records into the database.
To execute the SQL string, all you have to do is put objConn.Execute (strQuery).
Secondly, your SQL string should be stated like this:
strQuery = "INSERT INTO Contacts ('" & Number & "') VALUES ('15')"
I am assuming that Number is a variable you are passing into it. If it is just a number and not a variable, then the way you have it is fine. However, judging from the error message you posted, the former reason is the case (passing a variable using the wrong syntax).
Lastly, you can remove the dim objTimes declaration and the Set objTimes = CreateObject("ADODB.Recordset") line.
Again, all of this assuming all you are doing is INSERTing records. If you are retrieving records then you just need to change the SQL string.
Try these and see what happens. If they do or if they don't, feel free to shoot me an email letting me know.
Hope it helps,
Tobey Unruh
==================
The original message was:
The Code, which dropped:
dim objConn
dim objTimes
dim strQuery
Set objConn = Server.Createobject("ADODB.Connection")
Set objTimes = Server.Createobject("ADODB.Recordset")
objConn.Open "HIERONTA"
strQuery="INSERT INTO Contacts (Number) VALUES ('15')"
set objTimes = objConn.Execute (strQuery)
|
|
|
|
|
> strQuery="INSERT INTO Contacts (Number) VALUES ('15')"
The error message says that you are trying to pass a string value into an integer field. Try this:
strQuery="INSERT INTO Contacts (Number) VALUES (15)"
Regards, Tom.
|
|
|
|
|
There is a field size in your DB that is too small to accept the data. Check your field sizes.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
