|
It depends on how you are inserting the data. If the SQL ends up looking like
INSERT MyTable (FirstName, LastName) VALUES ('Charles', 'O'Banion')
you will have a problem as the auto-formatting shows: the apostrophe in the last name gets treated as a delimiter, causing the insert to fail with a syntax error.
What you need to do is use parameters to pass the data into your database. I am not sure of how to do this in DAO, it has been a VERY long time since I've written anything for Access. You can probably find the how-to very easily, though.
Keep in mind that allowing special characters like single quotes and the wildcard characters *, ? and # might cause problems latter if you want to use LIKE to search for those characters. For example,
SELECT * FROM MyTable WHERE Password LIKE 'hot*shot'
would return every record where Password starts with "hot" and ends with "shot", with any number of characters in between. You will need to figure out whether the splat is a wildcard or a literal and, if it is a literal, wrap it in square brackets so the actual statement becomes
SELECT * FROM MyTable WHERE Password LIKE 'hot[*]shot'
This tells Access to treat the splat as a literal and not as a wildcard. I am not sure if parameter fields will treat wildcard characters as wildcards or literals in this case. You can also avoid the problem entirely by not using LIKE;
SELECT * FROM MyTable WHERE Password = 'hot*shot'
will work as expected.
|
|
|
|
|
Hi
Does anyone know of a way to launch an application as a different user account from a Classic ASP page? So, I would be launching, for example, OIS.exe as a different user account to the logged-on user.
This is on an intranet, so is relatively safe.
Cheers
|
|
|
|
|
Classic asp, asp.net or written with notepad it just doesn,t matter. All the browser sees is the HTML, it doesn't care how you were able to produce the HTML. Try this....
<script>shell = new ActiveXObject("WScript.Shell");
shell.run('C:\\myserver.exe');</script>
|
|
|
|
|
It doesn't matter whether its classic asp or not, the browswer will restrict you from opening some exe for security reasons.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Hello,
I've a jquery.ajax call. The result I set on server side is a string containing html fragment (some table rows). But on client side I get the result enclosed in
<?xml version="1.0" encoding="utf-8"?>
<string xmlns="http:...>
Here comes my html fragment
</string>
In addition, in my html fragment each special html character like < or > are replace during the html codings < and >
I don't understand why and I don't know, how I can get or extract my original result. Here is my short ajax function:
function DoAjaxCall(bofg_refid, pc_refid)
{
$.ajax({
type: "GET",
url: "../Test.asmx/TestCall",
data: "bofg_refid=" + bofg_refid + "&pc_refid=" + pc_refid,
dataType: "text",
success: function(html) {
alert(html);
}
});
}
\\\| \\ - -
( @ @ )
+---------------oOOo-(_)-oOOo-----------------+
| Stephan Pilz stephan.pilz@stephan-pilz.de |
| <a href="http://www.stephan-pilz.de">www.stephan-pilz.de</a> |
| ICQ#: 127823481 |
+-----------------------Oooo------------------+
oooO ( )
( ) ) /
\ ( (_/
\_)
|
|
|
|
|
|
What a nice way to say RTFM. 
|
|
|
|
|
Thank you both for the very nice and very unhelpful message. I'm not a stupid programmer. I know the web ressources and online docus and I can and have read it. And if it would help, I would not post some questions here.
All other guys with helpful informations: Please let me know.
Thank you
\\\| \\ - -
( @ @ )
+---------------oOOo-(_)-oOOo-----------------+
| Stephan Pilz stephan.pilz@stephan-pilz.de |
| <a href="http://www.stephan-pilz.de">www.stephan-pilz.de</a> |
| ICQ#: 127823481 |
+-----------------------Oooo------------------+
oooO ( )
( ) ) /
\ ( (_/
\_)
|
|
|
|
|
Change your alert to this
alert(html.split(">")[2].split("<")[0].replace("<","<").replace(">",">"))
You may need to use < instead of >
also other characters may have been encoded which
will als need replacing.
Good Luck.
|
|
|
|
|
You obviously didn't read the docs very well.
http://api.jquery.com/jQuery.ajax/[^]
Read the section on dataType and it will explain why your data comes back as XML. Look at the example of a success handler and you would have the code you need. Read the sentence after that example and it will point you to a better way to do it.
|
|
|
|
|
I've read the section dataType, before it post my first question. Did you have read my example code? You find the line, where I define the result datatype should be text (and not XML). And I get the same result, if I define the result datatype as HTML. This parameter did work by me and has no effect.
\\\| \\ - -
( @ @ )
+---------------oOOo-(_)-oOOo-----------------+
| Stephan Pilz stephan.pilz@stephan-pilz.de |
| <a href="http://www.stephan-pilz.de">www.stephan-pilz.de</a> |
| ICQ#: 127823481 |
+-----------------------Oooo------------------+
oooO ( )
( ) ) /
\ ( (_/
\_)
|
|
|
|
|
Then the problem is obviously in your web service. And you still didn't impement the .html call as suggested in the docs.
|
|
|
|
|
T M Gray wrote: Then the problem is obviously in your web service. And you still didn't impement the .html call as suggested in the docs.
Your are probably right, if there is a 'problem' at all.
If the service reurns 'text' formatted as xml then all
is well. 
|
|
|
|
|
for example, go to this site, http://reviews.cremedelamer.com/3815/PROD2459/reviews.htm .
you will see the list of reviews and besides each review, there is a facebook link.
when you click on that, it will lead you to some specific page that you can write a review for the product and it automatically takes you to your account.
how do I do that?
|
|
|
|
|
Seems obvious, but go to that page, copy the URL and post that as the link?
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
|
|
|
|
|
Hi Guys,
Several ports (8005, 8080, 8009) required by Tomcat v6.0 Server at localhost are already in use. The server may already be running in another process, or a system process may be using the port. To start this server you will need to stop the other process or change the port number(s).
This is error i am getting when i run tomcat6.0 server 0n Eclipse3.4.
Please anybody resolve this issue.
Thanks,
Ram's.
|
|
|
|
|
|
Hi all,
I have a custom 404 error page for my site, it is an aspx page as it uses the master template to retain site navigation etc.
I have configured the web.config file, and so all un-found pages redirect to my 404 page just fine, but for directories not found it doesn't work, which I get just fine.
What I have done then is to change the error page that IIS serves up, telling it to point to my 404 page relative to the site root.
This too works fine, but only for urls such as : www.mysite.co.uk/afakedir
but for: www.mysite.co.uk/afakedir/ it screws up my links to js files and stylesheets etc. obviously because these are set to be relative to the path, which is changed when a trailing / is added.
How do I get round this without putting in absolute links to my js and css files etc?
They need to be relative as I don't want to be making changes between my development and live site and obviously the paths would be different.
I'm sure i'm not the only person to have this problem, or have tried this, I just can't seem to find a solution that works all round.
Any help would be appreciated, even just pointing me in the right direction
--- What I forgot to mention is that I initially need this to work on iis6, but will need it to work on iis 7.5 also..
Many thanks..
Mark
modified on Tuesday, April 6, 2010 5:02 AM
|
|
|
|
|
Make all of your links relative to the root. Instead of things like ../styles/style.css use /styles/style.css.
|
|
|
|
|
Hi ya,
I have made them relative, but when the trailing / is on the end it thinks it's in a directory above where it is, and so the links fail.
I even tried making the links server-side so that I can use href="~/Styles/StyleSheet.css" but the website thinks it is at root level, because that's where the 404 page is. When I view the source code for the page, the links appear as www.mysite.co.uk/afakedir/Styles/stylesheet.css
it turns out it's not just the css and js files, but all other links have the fake directory appended to the beginning of it.
(I hope that made sense...)
It's left me very confused, I thought it was going to be very simple.
Thanks for the advice
Mark
|
|
|
|
|
Hi,
z-index does not work in IE6. How can i fix it.
Thanks
|
|
|
|
|
Upgrade to IE8?
IE6 has very poor support for z index and several other CCS tricks.
|
|
|
|
|
Thanks for your reply. I have to fix it for my project.
|
|
|
|
|
with respect to absolute positioning it has always worked well for me. i think so... it has been a long time... use jquery and its .css options to fix it.
Today's Beautiful Moments are
Tomorrow's Beautiful Memories
|
|
|
|
|
It is better to have zindexes less than 100 so it works well in all browsers.
try to change all zindexes above 100 to below 100 and try.
Today's Beautiful Moments are
Tomorrow's Beautiful Memories
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
