|
Well, then James is right and your code should look like this:
Dim SQL, Keywords
<br> <br>
Keywords = ""
<br> <br>
If microsoftNews.checked Then
Keywords = Keywords & "'Microsoft',"
End If
If sunNews.checked Then
Keywords = Keywords & "'Sun',"
End If
If appleNews.checked Then
Keywords = Keywords & "'Apple',"
End If
<br> <br>
If Len(Keywords) > 0 Then
' Remove last comma
Keywords = Left(Keywords, Len(Keywords) - 1)
End If
<br> <br>
SQL = "SELECT * From News WHERE Source IN (" & Keywords & ")"
'Iterate the recordset and display news items
|
|
|
|
|
Sweet i'll try it out and hope for the best.
Cheers! 
"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr
|
|
|
|
|
Hello,
I have been trying with no success to use this NewMail object on the
CDONTS library. It is very simple to script this, but I get a VBScript
Runtime error as follows:
'800a0046' Permission Denied
This occurs in my ASP page.
The script looks like:
dim oMail
set oMail = Server.CreateObject("CDONTS.NewMail")
oMail.Send "NoReply@www.abc.com", "abc@xyz.net"
Does anybody have any idea why I would get this runtime error when I execute the Send method?
Best Regards,
|
|
|
|
|
Hello:
How to open a password protected MS Access database using
ASP?
Is it possible at all?
Thanks in advance.
|
|
|
|
|
Dim strConn
' The following provider works for Access 97 and Access 2000, but
' is supposedly more stable w/ Access 2000.
' (In the db be sure Tools | References | Microsoft ActiveX Data Objects 2.5 Library is checked.)
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/mydbdir/mydb.asp") & ";Jet OLEDB:Database Password=mypassword;"
Best regards,
-Paul
Web Database Developer
To help you put live data on the Web...
http://www.Bullschmidt.com
|
|
|
|
|
I have a web page where I have text files (some with HTML commands included) that are loaded into a page using FSO. I can't get the text to wrap properly when it is loaded into a table - it just keeps extending across the page, pulling the whole layout out of whack. I have no idea why this happens, as the text theoretically should just wrap within the table.
What I am wondering is if anyone knows a way to go through the text file, and once say 80 characters has been exceeded, replace the next available space between words with a line break? and then keep going through all the text until each line is roughly 80 characters or so long. (I just don't want to end up cutting up any HTML commands) e.g. I wouldn't want to end up with <bod<br>Y>. Of course, if you had any lo-tech ideas as to fixing up the display of a text file read into a table, then that'd be just as good...
|
|
|
|
|
If you are using the FSO object then just append a "<br>" at the end of your WriteLine method.
HTH
Nick Parker
|
|
|
|
|
I want to create a web page where the user inputs
some number, I multiply that number by some special
number and it returns a new number. Here is the catch,
the special number is important to me and I don't
want other people to know what that number is. If I
just use java or simple html, anyone can go to Edit/
View Source and see my special number.
Is there any way of doing this? Or is there a way
to make html execute some simple c++ program and then
retrieve the number that it returns. I can easily write
something in c++ to multiple the user inputted number
with my number and return the new number, but I don't
know how to get html to execute a c++ file.
Any ideas? Any thoughts? Any code?
Any response you can give me will be greatly appreciated.
Sincerely,
Danielle (an overworked graduate student)
|
|
|
|
|
Well, you need to use some Server-Side scripting. ASP for example. But it depends on what your provider supports. It can be Perl, PHP or whatever. Ask your hosting provider what type of Server-side scripting languages he support.
Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer
Need Web-based database administrator? You already have it!
|
|
|
|
|
If you have cgi enabled with your web provider you can program it in c++
<centre>
Now taking suggestions for a new sig. please email me all suggestions.
|
|
|
|
|
Is this special number for encryption...?
You can use cgi along with the POST(I think) method.
GET will show your special number in the URL bar which would be undesirable if your passing a credit card number or something else that secret.
However people can still view your data sent VIA POST using packet sniffers, only it's not as easy as URL encoded data.
So if your wanting to pass secret numbers to a cgi app on the server I think you would wanna use SSL.
I'm not sure I totally understood you here...however...
The response you got previously suggested you were after some way of storing your secret number in a CGI app on the server...
I don't think this will work either, cuz people can still view your perl scripts or php...on the server thus reveiling your secret number.
"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr
|
|
|
|
|
I wrote a small utility JScript cookie helper class thats posted here on CP. I'm using it in the development of my own site but I am also using ASP.
This is where the problem comes in...My cookie object stop working properlynow that i'm using ASP...
Do client/server cookies clash...?
Should I always use ASP for cookie managment...?
Thanx!
"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr
|
|
|
|
|
It depends on the context that you are trying to use the cookies to store information. I'm guessing you are having problems viewing cookie information (in ASP) that you created/modified on the client browser?
Software Developer
|
|
|
|
|
Hmm,
Cookies, cookies and more cookies.
In WinWorld ALL cookies created with InternetSetCookie / InternetGetCookie API's.
( except of may be Netscrape).
IIS/ASP sends cookies to the browser. Browser/webbrowserCtrl creates permanent cookies. Temporary cookies never written to HD.
InternetSetCookie takes URL. This is were it could falls appart.
http://127.0.0.1 could be different from http://your.com.pu.ter
To verify that your permanet cookies are working
Just call InternetGetCookie. For example:
bRet =
InternetGetCookie("http://www.yahoo.com",
NULL, sCookieVal, 10240)
Brian
|
|
|
|
|
has anybody figured out how to stop the ie6 image toolbar from popping up? not on my browser but on a users browser when they view my web site ... is there a script or whatever that can change the ie6 settings?
help appreciated
---
situations to avoid #37:
"good morning ... how many sugars do you take in your coffee ... and what was your name again?"
|
|
|
|
|
|
thanks
wasnt being lazy
didnt think to check google doh
---
situations to avoid #37:
"good morning ... how many sugars do you take in your coffee ... and what was your name again?"
|
|
|
|
|
lauren wrote:
wasnt being lazy
We wouldn't ever think a female would be lazy, what kind of guys do you think we are.
Nick Parker
This is a non-Calculus course as long as you know things like line integrals and surface integrals...
|
|
|
|
|
I am developing an application using ASP which updates a SQL server 2000 database on the back-end.
I currently have a bunch of HTML forms acting as the UI. Each form collects specific information that is stored in a different table, but I want all table inserts within the session to be part of one transaction (i.e. all or nothing).
I have tried a lot of things, but I still can't get a rollback to occur when a session times-out.
I've tried specifying -
"<%@ TRANSACTION=Requires_New Language=vbscript%>"
on the asp file with no success. I even tried explicitly calling the "ObjectContext.SetAbort" method.
My hosting company swears they have transactions enabled on thier servers, so I'm thinking it must be an error from my end.
I'll appreciate any help anyone could offer me. My question is how to handle transactions with multiple
Thank you
|
|
|
|
|
this could be a dumb question but here goes ... i saw a website where they had changed the standard scroll bars (vertical ones) to be a completely different look and feel that matched the web page much better ... is there a little bit of javascript or whatever that can do that at the client or is it a server side thing?
thanks
---
situations to avoid #37:
"good morning ... how many sugars do you take in your coffee ... and what was your name again?"
|
|
|
|
|
Lauren,
It can be done in the style tag at the top of the page.
<style>
BODY { scrollbar-3d-light-color:#999999;
scrollbar-arrow-color:#FFFF33;
scrollbar-base-color:black;
scrollbar-dark-shadow-color:#333333;
scrollbar-face-color:#666666;
scrollbar-highlight-color:#999999;
scrollbar-shadow-color:black}
</style>
Nick Parker
This is a non-Calculus course as long as you know things like line integrals and surface integrals...
|
|
|
|
|
thanks nick
way cool 
am not really a webhead yet but am fast becoming one
hehe
---
situations to avoid #37:
"good morning ... how many sugars do you take in your coffee ... and what was your name again?"
|
|
|
|
|
error report at:
set pManager = Server.CreateObject("StudentADM.StudentManager")
Error Type:
Server object, ASP 0178 (0x80070005)
The call to Server.CreateObject failed while checking permissions. Access is denied to this object.
I used ADODB.Connection, it is OK. and i used client program(with VC), this object can be accessed. Why? I don't know where should i set the permissions.
|
|
|
|
|
Check the the dlls that your object uses are in same directory with your object. And no network access.
I had same problem too, but when I put all dlls in same directory (you need to put them on same computer at least), the problem was solved. Also make sure that you compiled it. You can build a simple test application where all you need is to initialize your object, you will see then
Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer
Need Web-based database administrator? You already have it!
|
|
|
|
|
Check that the folder where the objects and any dll's used have read permissions set for the IUSR_[computer name] account, for example my user on my web server is IUSR_BUFFY.
To do this right click on the folder in explorer, click Properties/Security and add the user to the list.
If that doesn't work drop me an email...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
