it9888

Well, here's the answer to my (stupid) question: I was copying the wrong files. Only to defence my self, here's what happened. I saved my webservice to a directory, C:\My Appl\MywebserviceI also had it in C:\inetpub\wwroot I was opening the webservice from C:\My Appl\Mywebservicebut it was being saved to C:\My Appl\Mywebservice. Naturally, I was copying the webservice from C:\My Appl\Mywebservice and paste to webserver. All files there were still dated as 2006! Fortunately i discovered my mistake a minute before throwing my pc out of the window!!! So for anyone else having the same problem, check where your files are stored!

Hi! I have this webservice which I setup in my webserver. I made some changes in my copy in my computer and I want to update my webservice in the webserver.I overwrited the webservice, deleted it and re-configured it in IIS but nothing worked. When trying to test itI still get the old version Is there any file that I have to delete? What should I do?Thanks!

Thanks for your reply jesh. I don't think that web services work in this way though. Correct me If I'm wrong but I think I cannot control the way dates are captured since I'm not the one developing the consumer. The only thing I could do is having three fileds for year, month, days like you suggested.

I have a webservice with several functions. One function requires a parameter of type date. When testing my webservice I realised that this date should be given in no other format than YYYY-MM-DD. I would like to make a conversion function that will take as parameter the date and convert it to the above mentioned format. My problem is that I don't really know how the user will type the date. Could be: YYYY/MM/DD or MM/DD/YYYY or DD-MM-YYYY etc. Actually, a user while testing, gave the following date: YYYYMMDD. Is there any conversion function that I can use?

You caould also use a template as your layout and adjust all your page to that template.Dreamweaver offers a nice solution to that.

Can I pass variables to a file that I run directly from my computer? Like: C:\test.html?x=5 I don't want to use any kind of server including the IIS.

I solved my problem. For anyone facing the same proble in the future, here's the solution: Use '# #' for the dates in your SQL statement when using Access. Really stupid ha? I forgot to use a couple of # and I spent a whole day trying to figure out what was wrong. Have a nice day ev1!

I have a web service and in one web method i use the following SQL:

SELECT Distinct RGR.Rate_Code, RGR.Scale_Name, RGR.Rgr_Group, RGR.Rgr_RateBuy, RGR.Rgr_Excess, RGR.Rgr_RateSell, Scale.Scale_Days, Gr.Gr_Code, Scale.Scale_ToDays, Supplier.Vat_Code, Supplier.Supplier_Country, Supplier.Supplier_Name, RGR.Rgr_GrSipp, Gr.Gr_VehType, Rate.Rate_FromDate, rate.Rate_Level, rate.Rate_EndingDate, Supplier.Supplier_City, Rate.Curr_Code, Gr.Gr_VehEngSize, Gr.Gr_VehAC, Gr.Gr_VehCLS, rate.Rate_Type, Gr.Gr_VehDoors, Gr.Gr_VehpPWS, Gr.Gr_VehABG, Gr.Gr_VehRC, Supplier.Supplier_Code, Gr.Gr_VehSeat, Gr.TheftExcess FROM (Gr INNER JOIN (((RGR INNER JOIN Scale ON (RGR.Rate_Code = Scale.Rate_Code) AND (RGR.Scale_Name = Scale.Scale_Name)) INNER JOIN rate ON RGR.Rate_Code = rate.Rate_Code) INNER JOIN Supplier ON rate.Supplier_Code = Supplier.Supplier_Code) ON (Gr.Gr_Supplier = Supplier.Supplier_Code) AND (Gr.Gr_SippCode = RGR.Rgr_GrSipp)) INNER JOIN Location ON Supplier.Supplier_Code = Location.Supplier_Code WHERE (((rate.Rate_FromDate)<=2/24/2007) AND ((rate.Rate_EndingDate)>=2/28/2007) AND ( Rate_level=1 Or Rate_level=2 Or Rate_level=3 Or Rate_level=4 Or Rate_level=5) AND ((Scale.Scale_Days)<=4) AND ((Scale.Scale_ToDays)>=4) AND ((Supplier.Supplier_Country)='COUNTRY') AND ((Location.City)='CITY')) ORDER BY RGR.Rgr_Group;

I get no results. Then I tell to my web service to return this SQL as text as the result of it. I copy and test this SQL in Access. Again no result. When I go in my criteria and re-write even one letter, for example, If i delete and rewrite CITY, then I get results. How does this happen? I don't change anything from my SQL. One time i don't get results and the other i do. This is really weird. Please heeeeeelp!!!!

I haven't thought of that. I will ask about it, thanx jesh! Otherwise I will use frames and try to be happy about it! Thank you all!

I need to display a form that is hosted on another site. I tried using asp in a frame, I named that frame as something.asp but when I call my frameset, I get a message "Do you want to open 'something.asp' or save it in your computer", like I'm downloading a file. I haven't used frames before, and I would rather avoid using them but If this is the only method I will go for it. Any suggestions?

I think that you need to check If there's a value in the table before trying to retrieve it.This works for me but I'm using vbscript.

If not recordset.EOF then.........End if

Try finding something similar.

Hi ev1,I have a problem and I would appreciate your help.I'm developing a website for car rentals. This website gets a booking form from another website.I need to load this booking form in my website. How can I do that? If i use framesets and load the url then I think I can't have asp written in my frames. I do not want to use popup windows since I want the booking form to be displayed in the index page when loaded. What other options do i have? Please help!!!!

Thanks jesh,I will try that and let you know.I really appreciate your help.

Hi all,I hope you can help me with this one. I have a public function in a web service and i need to pass some parameters in it. Some of them are optional and some are not. How do i define that some of my parameters are optional? Here's my code:

<WebMethod(Description:="")> _		Public Function ShowReservation(ByVal myusername As String, ByVal mypassword As String, ByVal MyResNo As String, ByVal FromDate As Date, ByVal ToDate As Date) As DataSet		Dim objConn As New OleDbConnection(ConfigurationSettings.AppSettings("DSN"))		Dim objDA As OleDbDataAdapter		Dim objDS As New DataSet		Dim SqlString, clientno As String		clientno = GetClientNo(myusername, mypassword)		If UserExists(myusername, mypassword) Then			SqlString = ""			SqlString = SqlString & " Select Country, ResNo, RegDate, Hirer From Res "			SqlString = SqlString & " Where ClientNo='" & clientno & "'"			If MyResNo <> "" Then				SqlString = SqlString & " And Res_No='" & MyResNo & "'"			End If			objDA = New OleDbDataAdapter(SqlString, objConn)			objDA.Fill(objDS, "Reservation")			objConn.Close()			Return objDS		End If	End Function

Tha paramateres MyResNo, FromDate ,ToDate should be optional.Any ideas? Thanxit9888

How do I define If a Web Service uses SOAP? And what version it's using?Is there any kinf of declaration for that?Thank you!

If you are using ASP I can send you the scripts I'm using for uploading all kinds of files.

It's not a static document and I'm using ASPnet. I tried to find something in tha tutorial but nothing seems to help. What I want to do is to have a web method like this:

<WebMethod> _		Public Function Mywebmethod(ByVal myusername As String, ByVal mypassword As String) As System.Xml.XmlDocument

Then, how do I define a xml doc and return it? I'm lost here.

How do I make a web method returning an XML document?

i did my coding like this.then as long there is still data in the dbase it will display it.hope it work for you.i'm new too in asp.about 1 and half month.<%while not rs.EOF%>Response.Write("<TD>")Response.Write(rs("courses")& "</TD>")

The problem is that you use a variable to display your result. In the while loop you get the value, you assign that to the variable, then get the next, ovewrite the same variable with the new value and so on. So you only display the last value, right?Your solution would be to display the result in the while loop, something like this:Do While Not rsEnc.EOFsGQDEncName = rsEnc.Fields("name")sGHTTemp = sGHTTemp & " <tr>" & vbCrLf & _" <td colspan=2 width=100%_>" & vbCrLf & _" <span class='issue-field-label'>Enclosure Records</span>" & vbCrLf & _" <span class='issue-field-content'>: " & sGQDEncName & "</a>" & vbCrLf & _" </span>" & vbCrLf & _" </td>" & vbCrLf & _" </tr>" & vbCrLf & _"</table>" & vbCrLfrsEnc.movenext loopelseresponse.write "end of file"end iffnCLDestroyObject(rsEnc)Try this and let me know!

i've already have three tables like you said.but my supervisor ask me so in one form a user can apply many courses.my form is like this.course1 name_________________course2 name_________________course3 name_________________user name_________________ID_________________etc the user profileso i want to make each of the course,course1 2 and 3 to be inserted into differrent line in tables but the user profile will be duplicate into each line too.is it possible to do this?

It's possible. You should have two keys in that table, one would be the user and another would be the course. So that no line would have the same keys as the previous. A user can choose multiple courses, but cannot choose the same course twice, can he?

Thanks aspnetguy, I'll have a look at it.

Did you try passing the parameter to the URL? For Example:http://www.test.com/test.asp?parameter="value"

So, the problem is that you cannot pass the parameter value to the second page?

I'm building a website in which I have to do the follwing:A user gives a time and I have to check if this time is between 23:00(late at night) and 06:30(morning).How can I do that? I'm stuck here, please help!!! Has anybody come accross this?