For VB there is an easy "Replace" command as well:
sLookup = txtSearch.Text
sLookup = Replace(sLookup, "'", "''")
Just in case someone reads this and uses VB.
Have a good one.
Ben
Here is what we did in this situation. We pulled all of the variables from an external text file so that we didn't half to rewrite code when the ftp requirements of vendors change.
Also alot of this code is from outside sources, I will try and find the original developers name so that he can get...
skiflyer -
It's so simple. I thought I was going to get to use my first SOAP application. That's too bad. Thanks for simplifying this app anyway.
Bennynye
Hey it works. Apparently just changing the dll to the msxml4.dll through me off. The working VB code is as follows:
Sub Main()
Dim objHTTP As New MSXML.XMLHTTPRequest
Dim strEnvelope As String
Dim strReturn As String
Dim objReturn As New MSXML.DOMDocument
Dim dblTax As Double...
skiflyer -
I'm curious how that would work. I think I brainwashed myself into thinking that I had to send up the current version to the server. Your way does seem like it would be a little easier.
Thanks for the response.
I am running a simple SOAP example that I see everywhere on the web. The example should pass a parameter to an ASP page which in turn responds. There are only parts to the example. The VB part is as follows:
Sub Main()
Dim objhttp As New MSXML.XMLhttpRequest
Dim strEnvelope As String...
I am looking to do something simillarl internaly here. I posted a simple SOAP qestion earlier today, but the goal of the app is to do the following without a database.
1. Initial App launches secondary Update App.
2. Initial App sends Update App the following (DDE):
Location on...
I am running a simple SOAP example that I see everywhere on the web. The example should pass a parameter to an ASP page which in turn responds. There are only parts to the example. The VB part is as follows:
Sub Main()
Dim objHTTP As New MSXML.XMLHTTPRequest
Dim strEnvelope As String...
Great solution ThomVF,
I used your method of going to the Parent table without a join and it worked great. I changed it slightly to incorporate a function that I am more familiar with, the NOT IN, but that was pretty much the only change.
Thanks again,
bennynye
Hello,
I have a query that I want to return a list of contacts that do not have any rows with a 't' in the Licenced column in a one-many table. I have checked that this case does occur, but my SQL returns 0 contacts. If anyone could point me in the right direction I would appreciate it...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.