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!