|
I have a database(access) and Im tryin to connect my webpage so I can compare values.I have already uploaded values into a combo box so when i select a value I want the page to go to database and filter values by the selected item and then display them into a datagrid or something.
Any great ideas on how i can do this.Please help.Ive tried everything.
A code wud be nice
Here is my code
Ok.
Now you get to view all the telephone numbers
by department
Select
An Alphabet
None
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
<%
Dim Connection
Set Connection=Server.CreateObject("ADODB.Connection")
Dim ConnectionString
ConnectionString="PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source= U:\Websites\Working Site\Home Page\Home Page\TelephoneList.mdb"
Connection.Open ConnectionString
%>
<%
Dim Recordset
Set Recordset=Server.CreateObject("ADODB.Recordset")
Dim Telephonelist
Telephonelist="SELECT * FROM TelephoneList where FilterByType = '" &
Recordset.Open Telephonelist, Connection
%>
<%
If Recordset.EOF Then
Response.Write("No records returned.")
Else
if (Telephone.Department.value == "None")
{
alert("Please select a value other than the one you selected");
Telephone.Department.focus();
return (false);
}
if (Telephone.Department.value == "A")
{
Telephonelist="SELECT * FROM TelephoneList where (FilterByKey=='A')
Do While NOT Recordset.Eof
Response.write Recordset("Name")
Response.write Recordset("Surname")
Response.write Recordset("Department")
Response.write Recordset("Xtension")
Response.write "
"
Recordset.MoveNext
Loop
End If
%>
kagiso
|
|
|
|
|
One great idea is to use web services where you use xmlhttp object
Thanks & Regards
Navneet Hegde
Nashik
India
Develop2Program & Program2Develop
|
|
|
|
|
The Contents in HTML Table Cell fits the cell if nowrap is set.I am trying to display the contents of cell in tool tip ,that only part of the text gets displayed in each cell(Ex: for "Go to Texas" must be displayed as "Go to....) when given minimum width so that user has to move mouse over the cell to view the full text content in cell.I would appreciate any help from you.
Thanks in Advance
|
|
|
|
|
hi
i m facing a problem
we are using desktop client and webservices
in that client request the a webservice async
that remains on server until a specific condition is satisfied
and rest of the web services are called syncronsly
these services run on localhost without any problem
but if client and server machines are diffrent it hangs the application
dont knw wht is the reasn
let me tell u one more thing
both the services are using different sessions
thanx in advance for ur help
khalid zaheer
|
|
|
|
|
i have made sample application to test the scnerio
closer to my application
here is client and server side code
client is
//////////////////////
Public Class Form1
Private WithEvents wsAsync As New localhost1.AsyncService
Private WithEvents wssync As New localhost.SyncService
Private urltoReplace As String = "http://khalid/" 'this url will b replaced by localhost
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
wsAsync.Url = wsAsync.Url.Replace("http://localhost/", urltoReplace)
wssync.Url = wssync.Url.Replace("http://localhost/", urltoReplace)
wsAsync.CookieContainer = New Net.CookieContainer
wssync.HelloWorld()
End Sub
Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
wsAsync.HelloWorldAsync()
End Sub
Private Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click
wssync.HelloWorldAsync()
MessageBox.Show(wssync.HelloWorld)
End Sub
Private Sub wsAsync_HelloWorldCompleted(ByVal sender As Object, ByVal e As localhost1.HelloWorldCompletedEventArgs) Handles wsAsync.HelloWorldCompleted
MessageBox.Show(e.Result)
End Sub
Private Sub wssync_HelloWorldCompleted(ByVal sender As Object, ByVal e As localhost.HelloWorldCompletedEventArgs) Handles wssync.HelloWorldCompleted
MessageBox.Show(e.Result)
End Sub
End Class
//////////////////
server side is
////////////////////
sync service is
Public Class SyncService
Inherits System.Web.Services.WebService
<webmethod(enablesession:=true)> _
Public Function HelloWorld() As String
Return "Hello World"
End Function
/////////////
async service is
Public Class AsyncService
Inherits System.Web.Services.WebService
<webmethod()> _
Public Function HelloWorld() As String
While True
Threading.Thread.Sleep(1000)
End While
Return "Hello World"
End Function
End Class
now client and server should b different
khalid zaheer
|
|
|
|
|
hi
i m using webservices to access the data
that works fine
when data is sent from server against any request
it returns the data i needed even any column in any table contain white space like " "
but when i send the the data from client to server for updation
" " is replaced to "" for column value
when data is serialized it works fine for current or proposed values in dataset but if any modfied row containing white spaces in its orignalvalue
it dont preserve it accordingly
this is causing alot of problems
does anyone know the solution please help
and thanx in advance
khalid zaheer
|
|
|
|
|
Hi there
I have placed an AJAX accordion control on my aspx page as a menu using nested accordions. I have also implemented java script which causes the images on the accordion to change their image onMouseOver, and change back onMouseOut. What I am now striving to do is the when a image is clicked, the image remains on the "mouseOver" image. The problem here is that while on the click event my script runs and the image changes, the MouseOut script also runs, even if I DO NOT move the mouse off the image after the click. I appears that mouseOut runs by default after a onClick event.
Does anyone have a possible solution to the problem, as I have already wasted well over 6hours on this what is seemingly a mundane task.
Thanks
Devin
|
|
|
|
|
Determine the order the events are being fired. A temporary alert with the name of the event is a quick way to determine this.
Set a state variable in the first event that can be read by the second event and determine what the appropriate action is based on the variable.
|
|
|
|
|
Hi there Jimmy
Thanks for the reply. Below you can see my code. Basically the first function runs on a click event. However the problem is that on the click event the mouseOut also runs, which is attatched to the second function. I atempted to put a if statement in the second function which would pick up that the image was clicked and not mouseOvered due to the differing image src paths, however it merely seems to pass straight over this. I tested with alerts prior to your reply, and it returned the clicked event followed by the mouseOut event even though i didnt mouseOut. The strange this is, i told the alert to return to me the current image path, and even though the first function changed the image path, the second functions if statement merely ignored this fact and still ran the first if statement, thus switching the image back. Any suggestions?
Thanks Dev
function setImageClicked ()
{
var arg = document[setImageClicked.arguments[0]]
if (arg = 'TrackingSystemLink')
{
document['TrackingSystemLink'].src = '../Images/onClick/SideMenuReportingSystemOn.png';
alert(document['TrackingSystemLink'].src);
}
}
function checkIfImageClicked ()
{
if (document['TrackingSystemLink'].src = '../Images/SideMenuTrackingSystemOn.png')
{
alert(document['TrackingSystemLink'].src);
swap('TrackingSystemLink','TrackingSystem');
alert(document['TrackingSystemLink'].src);
}
else if (document['TrackingSystemLink'].src
= '/Images/onClick/SideMenuTrackingSystemOn.png')
{
alert('test');
}
}
|
|
|
|
|
Do you have Firefox/Firebug installed ? Firebug gives you tracing through your javascript, I'd be lost without it.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
devil85 wrote: document[setImageClicked.arguments[0]]
document['TrackingSystemLink'].src
What scripting language is this?  I have never seen something like this in javascript.
Although you said you were using javascript in your original post I suspect you are using vbscript because I think the comparison operator in vbscript is a single = sign.
You also mention AJAX control so I suspect you are coding asp.net which I do not have any experience with.
Sorry I can't be of help because I only know javascript.
|
|
|
|
|
Please correct me if I was wrong. I was under the impression I could use this method for calling the first of any parameters sent into the function "setImageClicked.arguments[0]" and the second is Just using the name of the image which is "TrckingSystemLink" and calling its ".src" method. So as I see it this is jscript? If you would write this method in diff way, please feel free to do so, as it seems that my script is muddled based on what you have said. Thanks again.
Cheers Dev
|
|
|
|
|
devil85 wrote: Please correct me if I was wrong. I was under the impression I could use this method for calling the first of any parameters sent into the function "setImageClicked.arguments[0]" and the second is Just using the name of the image which is "TrckingSystemLink" and calling its ".src" method.
I didn't know document had a .src method.
I was referring to the HTML DOM document model. Maybe I am wrong but I have always used document.document-method.methods-methods, etc., not document[something].method, but maybe I just haven't seen document used like this.
I usually stick to a few well tried methods with the DOM document ( document.getElementsByTagName, document.getElementById, document.getElementByName, document.write, document.anchors[], document.forms[], document.images[], document.links[], etc).
See HTML DOM Document Object[^] for collections, properties and methods of the DOM document.
I am not saying you are wrong, I am just saying I have never seen the HTML DOM Document Object used that way.
Maybe what you are using is a non-standard extension of the HTML DOM Document Object specific to asp.net which I am not familiar with at all.
I use straight HTML (DHTML, XHTML), CSS, javascrit and standard AJAX (XMLHttpRequest [AcxiveX for IE < 7]) for client side coding so that my web pages stand a chance of rendering on a wide variety of browsers, but it does take tweaking.
The thing that stood out the most in your code was that you were using a single = sign in your if statements. I think a single = sign is a comparator in vbscript but in javascript it is an assignment operator.
Double equal signs (==) are the comparison operator in javascript. Standard javascript that is.
I cannot say in asp.net how you code if statements but in standard javascript it would be something like if(this == that). If you use the single = sign in standard javascript you will assign that to this (previous example) in the if statement which would always be true, and would always execute the code.
As I mentioned I don't know how you do it in asp.net so I don't know if this holds true in that environment.
Maybe some of the asp.net gurus can help you get a well formed script going in that environment.
|
|
|
|
|
Hi, I'm Tring to pass a String Parameter From .Net Application to .Net ASP Web Service.
I'm Sending A Valid String but the web service Gets Null String insted of the string that i've sent to it.
I must say that this same Web function Has another parameter, of inteter
type, and that this parameter is passing OK with the right value.
Thaks Ram.
|
|
|
|
|
Sounds like you need to post some code.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi All,
I am getting the following error when i am trying to execute my asp code:
aspSmartUpload error '800a0009'
Subscript out of range
/seba/marketing/updatejobs.asp, line 29
The code at Line 29 is:
mySmartUpload.Upload
Can anyone tell me what and where is the problem.
Thanks.
Anurag Gandhi.
|
|
|
|
|
Presently i have build a realestate webportal using ASP.NET with C#.
And Client requiremetn is : This webportal has to be appered in topten list while any user search for realestate sites in google.
Plz Help me how to do these.
thanks in Advance
|
|
|
|
|
There is no hard and fast rule how to do this - everyone wants to appear in the top 10 list, so you are going to have to fight really hard to achieve it and it's unlikely that in a hotly contested area such as real estate you will even get onto the first 10 pages. If you do a Google for 'SEO' (search engine optimisation) then you'll find many many tips.
|
|
|
|
|
I hope they don't hold you to that...
|
|
|
|
|
|
|
Hello,
i have a webbrowser control in my c# app. if i click on a link which includes php parameter like
"http://www.mySite.com/myscript.php&var=test" the navigating events fires up.
but when i check e.Url.AbsolutePath only "http://www.mySite.com/myscript.php" is being returned.
how do I get the complete url with all parameters in the navigating event of the webBrowser control?
thanks in advance, Opaknack
|
|
|
|
|
and if you understand that i guess you might be able to help ... here's hoping
so i'm firing off an ajax request to a server side script that updates a database and returns the rating widget that was clicked on but showing the rating the user voted ... all this is good ... my problem is that the rating widget itself is drawn via javascript and when i put some javascript in a div using the innerHTML method the javascript doesn't execute ... i know i'm supposed to do something with the xml dom but i can't get it working
any help appreciated
|
|
|
|
|
l a u r e n wrote: when i put some javascript in a div using the innerHTML method the javascript doesn't execute
When you receive the XMLHttpRequest reply in the designated ready state change function you are in a javascript. Execute the intended javascript code on the reply and replace the innerHTML of the div with the results of the that manipulation.
Something like "document.getElementById('DivId').innerHTML = RenderRating(reply);" in the ready state change function when to receive a successful status (XMLHttpRequest status of 200) from the XMLHttpRequest.
Where RenderRating(PARM) is you javascript function that takes the reply from the XMLHttpRequest as a parameter and returns the rendered rating.
|
|
|
|
|
jimmy
thanks a lot for the pointer ... i had to use a variation on the theme you suggested but you opened my mind to solving the problem
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
