confused about access / sql database / sql server / php !! .. help please
i am running a website on Windows 2000 server with ASP 3 webpages and
Access 2000 database. (with a hosting company)
traffic is slow at this time but expect to grow. lately i have been
reading about sql database and sql server, specially this article:
http://www.aspfaq.com/show.asp?id=2195
will someone help me understand:
1. with *SQL Server*, do i keep my current Access 2000 database and
ASP pages?
if not, then -
a. what sort of DB i will need? (we r a non profit, so need
inexpensive things)
b. will ASP pages need be redesigned? how big/difficult is that
transition?
2. if i start using *SQL database*, then which SQL database?
3. Where does *mySQL* fit in this scene?
4. What do i do with my current ASP webpages?
5. i guess, i will need an SQL server if i have to use SQL database?
any recommendations for a cheaper hosting company? Tag: Look at these pack Tag: 274378
random word generator
Hello folks...
this is my first post in here. I'm new to ASP having done all my previous
work in Flash and bog standard HTML. Only been learning for a couple of
weeks.
anyway...I have been building a guestbook type page, but as with quite a lot
of guestbooks and stuff some of the comments that get placed are not exactly
suitable, and tracking people down is a little difficult.
maybe you all can think of much better ways but remember I'm a newbie and am
working my way through..
so...
I have a form where people sign up to become a member..they select their
name and password etc and can log in, but this is completely anonymous....
so..I got an email script set up and working (took me a long time to figure
that one out!!!) and connected to a dbase, The user gives me his email addy
and name and a random number is generated, stored as his password and the
password is mailed to him,...thus if he doesn't give me a corect email addy
he doesn't get his password and therefore can't sign in or post nasty
comments..
But a number password isn't really all that and I would prefer to have a
random word generated.
is this possible??
again, being a newbie and not very up on what I can/can't do...I thought of
the following...
1) Store a bunch of words in a text file with a space between each one
2) Read in this file and store it as a variable
3) Trim off a random number of characters from the start of the text
4) Then search for the next space (which would be the beginning of the next
complete word)
5) The next space after that would then mark the end of the word
6) count the characters between the two spaces to give me the word length
7) and then select that number of characters and then I have a randomly
selected word!!!
I can't see why it wouldn't work as it seems logical to me, but maybe
someone (Ray seems to be the god of ASP (I've been reading here for a couple
of weeks and he seems to know everything!!!!)... can tell me otherwise?
many thanks Tag: Look at these pack Tag: 274373
add parameter
Hello.
I am trying to pass three parameters using this code in an asp page to an
xsl page.
I keep getting the following error:
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/account.asp, line 114
Any ideas what I am missing?
Chuck
Dim oXmlsrc, oXml, oNode, oXslsrc, oXsl, newXML, re, oXslTmpl, oXslProc
Set oXmlsrc=CreateObject("MSXML2.DOMDocument.4.0")
Call oXmlsrc.setProperty("ServerHTTPRequest", True)
oXmlsrc.async=False
Set oXslsrc=CreateObject("MSXML2.FreeThreadedDOMDocument.4.0")
Call oXslsrc.setProperty("ServerHTTPRequest", True)
oXslsrc.async=False
Set oXslTmpl = Server.CreateObject("MSXML2.XSLTemplate.4.0")
'On Error Resume Next 'debugging code
'If Request.Form("name") = "" Then
Call oXmlsrc.load(sVerifyUrl)
'Response.Write "<!-- " & oXmlSrc.xml & " -->" 'debugging code
newXML=oXmlsrc.xml
Set re=new regexp
re.pattern=" xmlns.+?>"
newXML=re.replace(newXML,">")
Call oXmlsrc.loadxml(newXML)
Call oXslsrc.load("https://www.abc.com/account.xsl")
'End If
Set oXslTmp1.stylesheet = oXslsrc
Line 114 <<<<<<<<<<
Set oXslProc = oXslTmpl.createProcessor()
oXslProc.input = oXmlsrc
Call oXslProc.addParameter("accountnumber", ud_CSN)
Call oXslProc.addParameter("customername", ud_CustomerName)
Call oXslProc.addParameter("username", ud_UserName)
oXslProc.Transform()
sOutput oXslProc.output
'oXslsrc.selectSinglenode("//@select").text= "'" & ud_CustomerName & "'"
Response.Write oXmlsrc.transformNode(oXslsrc)
Response.Write sOutput
Set oXslProc = Nothing
Set oXslTmpl = Nothing
Set oXslsrc = Nothing
Set oXmlsrc = Nothing Tag: Look at these pack Tag: 274372
replace words with bold words
Hello
I was wondering if you guys could help me solve this using reg exp,
i have a searchpage and a variable keywords that holds a number of words.
e.g
keywords = "test car goose"
.....
<%
do until rs.eof
%>
<%=rs("text")%>
and i was wondering if you guys know how to make the words test, car and
goose bold if exists in rs("text")?
/Lasse Tag: Look at these pack Tag: 274370
cant get #include to work in .asp file.
I'm new to html and web coding, this is a simple one -
appreciate your help!
I'm attempting to get my browser bar links to reside in a
single .asp file to avoid multiple additions to pages
when I add a page to the site. I've done a lot of
reading and surfing, believe I know how to do it, but
can't get it to work.
I've installed IIS on my machine running XP pro, and have
created two .asp files, one called default.asp, the other
navigation.asp
both pages browse OK separately, but the navigation page
text does not appear within the default page at all (like
it's not getting "called" - here's the cut down code.
<html>
<head>
<title></title>
</head>
<body>
<% %>
<p>
This is the default page (filename default.asp)
<p>
<!- #include file="navigation.asp"->
</body>
</html>
-----------------
<html>
<head>
<title></title>
</head>
<body>
<% %>
This is the browser page (filename navigation.asp)
</body>
</html>
------------------
Thanks for your assistance
Regards
Greg Tag: Look at these pack Tag: 274363
MS, YOU ARE A DISEASE
Whether those trojans or virues appear in this group,
hidden on my machine, in your disks, in your downloads,
in your Software, in your Patches, in your shrink wrap,
in your Financial Report, on your ballot, or whereever.
=======
There was reason to put you in the section of
new or other species.
======
Gues that was premature.
--------------
Why don't you just get lost. Tag: Look at these pack Tag: 274346
number to string
Hi,
When I select a filed from a txt or csv file, and display on the ASP, the 16
digit of barcode number (9876543210123456) becomes to 9.87654321012345E+15.
How can I make it display the original. Thanks
Atse Tag: Look at these pack Tag: 274341
Single Unicode Character - How many Bytes?
I've got a single Cyrillic character delivered from a db field to my script,
which displays correctly in my UTF-8 web page. This is the "backwards P"
which has the Unicode value of &H042F
But when I read it for writing to a file, what I see is a 4-byte value of
&HD0 00 AF 00 .
Can someone explain what's going on here? Thanks, all.
AS Tag: Look at these pack Tag: 274337
Adding more font colors to word?
Basically, I would like a bigger variety of colors to have for fonts in
messenger.
Anyone know where/how I can do this?
DEVBuilder.org, http://www.DEVBuilder.org
ASP,ASP.NET,VB.NET,PHP,Java,and SQL Support, all in one place. Tag: Look at these pack Tag: 274335
Runtime Error 429
Trying to boot up msn messenger control, and get "runtime error
429...activex cannot create the object"
and thoughts?
thanks!
DEVBuilder.org, http://www.DEVBuilder.org
ASP,ASP.NET,VB.NET,PHP,Java,and SQL Support, all in one place. Tag: Look at these pack Tag: 274329
Identifying the web site address of the current page
I have several web sites running the same set of pages and
all accessing the same common database tables. A field in
all the records contains the web site address of the web
site to which each record pertains, for example, this
field in some records may contain www.upperbridge.co.uk.
When a web site page accesses a database table, it needs
to select the records that contain its web site address.
How do I identify which web site this page is in? For
example, if a page is part of web site
www.upperbridge.co.uk, how does the page get hold of this
web site address so it can use it to select the correct
records in the common database tables? Tag: Look at these pack Tag: 274326
MAKE 6,000$ FROM 6$ !!!!!NOT A SCAM!! PLEASE READ!!!!!!!!!!!!
By: edmars
Turn 6 dollars into 6k.
HOW I TURNED A 6 DOLLAR INVESTMENT DEAL INTO 6K
TURN 6 (six) DOLLARS INTO $6000 or even $60000 EASY AND HONESTLY!!!
READING THIS MESSAGE WILL CHANGE YOUR LIFE FOREVER
!!!!!!PLEASE READ THIS ALL!!!!!!!!!
!!!!IT HELPED ME & IT CAN HELP YOU!!!!
!!!! NOT A SCAM !!!!
!!!I REPEAT NOT A SCAM!!!
THIS ONLY COST YOU A 6.00 CASH !!!INVESTMENT!!!
IT DOES WORK
!!!PLEASE READ ALL!!!
I found this on a bulletin board and decided to try it. A little
while back, I was browsing through newsgroups, just like you are now,
and came across an article similar to this that said you could make
thousands of dollars within weeks with only an initial investment of
$6.00! So I thought, "Yeah right, this must be a scam", but
like most of us, I was curious, so I kept reading. Anyway, it said
that you send $1.00 to each of the 6 names and address stated in the
article. You then place your own name and address in the bottom of
the list at #6, and post the article in at least 200 newsgroups.
(There are thousands) No catch, that was it. So after thinking it
over, and talking to a few people first, I thought about trying it. I
figured: "what have I got to lose except 6 stamps and $6.00,
right?" Then I invested the measly $6.00. Well GUESS WHAT!?...
within 7 days, I started getting money in the mail! I was shocked! I
figured it would end soon, but the money just kept coming in. In my
first week, I made about $25.00. By the end of the second week I had
made a total of over $1,000.00! In the third week I had over
$10,000.00 and it's still growing. This is now my fourth week and I
have made a total of just over $42,000.00 and it's still coming in
rapidly. It's certainly worth $6.00, and 6 stamps, I have spent more
than that on the lottery!! Let me tell you how this works and most
importantly, WHY it works... Also, make sure you print a copy of this
article NOW, so you can get the information off of it as you need it.
I promise you that if you follow the directions exactly, that you
will start making more money than you thought possible by doing
something so easy!
Suggestion: Read this entire message carefully! (print it out or
download it.) Follow the simple directions and watch the money come
in!
It's easy. It's legal. And, your investment is only $6.00 (Plus
postage)
IMPORTANT: This is not a rip-off; it is not indecent; it is not
illegal; and it is 99% no risk - it really works!
If all of the following instructions are adhered to, you will receive
extraordinary dividends.
PLEASE NOTE:
Please follow these directions EXACTLY, and $50,000 or more can be
yours in 20 to 60 days. This program remains successful because of
the honesty and integrity of the participants. Please continue its
success by carefully adhering to the instructions.
You will now become part of the Mail Order business. In this business
your product is not solid and tangible, it's a service. You are in
the business of developing Mailing Lists. Many large corporations are
happy to pay big bucks for quality lists. However, the money made
from the mailing lists is secondary to the income which is made from
people like you and me asking to be included in that list.
Here are the 4 easy steps to success:
STEP 1: Get 6 separate pieces of paper and write the following on
each piece of paper "PLEASE PUT ME ON YOUR MAILING LIST." Now
get 6 US $1.00 bills and place ONE inside EACH of the 6 pieces of
paper so the bill will not be seen through the envelope (to prevent
thievery). Next, place one paper in each of the 6 envelopes and seal
them. You should now have 6 sealed envelopes, each with a piece of
paper stating the above phrase, your name and address, and a $1.00
bill. What you are doing is creating a service. THIS IS ABSOLUTELY
LEGAL! You are requesting a legitimate service and you are paying for
it! Like most of us I was a little skeptical and a little worried
about the legal aspects of it all. So I checked it out with the U.S.
Post Office (1-800-725-2161) and they confirmed that it is indeed
legal. Mail the 6 envelopes to the following addresses:
#1)Laura Owen
4210 Steep Rock
Pasadena, TX 77504
#2)Sigma Bailey
2100 South Gessner # 1304
Houston, TX 77063
#3)J. R. Sac
5018 Calhoun # 6
Houston, TX 77004
#4)Anthony Koller
13 Holly street
Gloucester, Ma 01930
#5)Erfan Haroon
24335 Fairmount
Dearborn, Mi 48124
#6)Eddie Marsh
McCarty Hall
Box# 43511
University of Washington
Seattle, WA 98195
USA
STEP 2: Now take the #1 name off the list that you see above, move
the other names up 1 place (#2 becomes #1, #3 becomes #2, etc...) and
add YOUR name and address as number 6 on the list.
STEP 3: Change anything you need to, but try to keep this article as
close to original as possible. Now, post your amended article to at
least 200 newsgroups. (I think there are close to 24,000 groups) All
you need is 200, but remember, the more you post, the more money you
make! You won't get very much unless you post like crazy. :)
This is perfectly legal! If you have any doubts, refer to Title 18
Sec. 1302 & 1341 of the Postal lottery laws.
Keep a copy of these steps for yourself and, whenever you need money,
you can use it again, and again.
PLEASE REMEMBER that this program remains successful because of the
honesty and integrity of the participants and by their carefully
adhering to the directions. Look at it this way. If you are of
integrity, the program will continue and the money that so many
others have received will come your way.
NOTE: You may want to retain every name and address sent to you,
either on a computer or hard copy and keep the notes people send you.
This VERIFIES that you are truly providing a service. (Also, it might
be a good idea to wrap the $1 bill in dark paper to reduce the risk
of mail theft.)
so, as each post is downloaded and the directions carefully followed,
six members will be reimbursed for their participation as a List
Developer with one dollar each. Your name will move up the list
geometrically so that when your name reaches the #1 position you will
be receiving thousands of dollars in CASH!!! What an opportunity for
only $6.00 ($1.00 for each of the first six people listed above) Send
it now, add your own name to the list and you're in business!
-----DIRECTIONS ----- FOR HOW TO POST TO NEWSGROUPS--------------
Step 1) You do not need to re-type this entire letter to do your own
posting. Simply put your cursor at the beginning of this letter and
drag your cursor to the bottom of this document, and select 'copy'
from the edit menu. This will copy the entire letter into the
computer's memory.
Step 2) Open a blank 'notepad' file and place your cursor at the top
of the blank page. From the 'edit' menu select 'paste'. This will
paste a copy of the letter into notepad so that you can add your name
to the list.
Step 3) Save your new notepad file as a .txt file. If
you want to do your postings in different settings, you'll always
have this file to go back to.
Step 4) Use Netscape or Internet explorer and try searching for
various newsgroups (on-line forums, message boards, chat sites,
discussions.)
Step 5) Visit these message boards and post this article as a new
message by highlighting the text of this letter and selecting paste
from the edit menu. Fill in the Subject, this will be the header that
everyone sees as they scroll through the list of postings in a
particular group, click the post message button. You're done with
your first one! Congratulations...THAT'S IT! All you have to do is
jump to different newsgroups and post away, after you get the hang of
it, it will take about 30 seconds for each newsgroup! **REMEMBER, THE
MORE NEWSGROUPS YOU POST IN, THE MORE MONEY YOU WILL MAKE! BUT YOU
HAVE TO POST A MINIMUM OF 200** That's it! You will begin receiving
money from around the world within days! You may eventually want to
rent a P.O.Box due to the large amount of mail you will receive. If
you wish to stay anonymous, you can invent a name to use, as long as
the postman