Guestbook/Database
I have made a guestbook using ASP, and SQL (so he says). This is the first thing I've done using ASP, so as you'll probably realise I don't know much ASP and I don't know any SQL, most of the code is copied and pasted from my friend.
For some reason my guestbook isn't working, I'm not getting any errors, and the test entry my friend put into my database(adobe) isn't working. My friend thinks it's the SQL, I've been trying to fix it, but I don't really know what I'm doing, he can't find whats wrong with it either. what could be wrong, or willing to take a look at the code for me?
View Replies
ADVERTISEMENT
I am having guestbook on my site with asp classic
But I do not think this is the problem
I am working with SQL server 2000 database
I always find a porno posts in the posts like
"Hi see this site [url=www.anysite.com]"
What make me say that the problem is not from the asp code
Is that even when i deactivate the send button or remove the page I still got
View Replies
View Related
i have created a working register/login system.. so now i need
to add the function that every user has its own guestbook.
(im using access)
i thought of having a system wich creates a database sub for
every user.
though i dont know wich code that would create this for me..
please help me with that code.
(u dont need to think on the type of system i suggested, as long that
i will get on the right track)
so
database specs:
need to have 3-4 tables:
ID
from
message
(optional) to
View Replies
View Related
I am trying to make an "Ask an Expert" page where people can enter their question using a form. This form will then be sent to an email account. If the question is answered by someone in my office, both the question and answer will be sent to a webpage automatically.
Automatically is very important. This sounds like a guestbook but instead of displaying all the "questions (comments)", only the ones that are answered will appear. My server doesnt' have CDONT, so I think CDOSYS is my only option.
View Replies
View Related
I have a client that is using a non-functional ASP/Access guestbook. The admin area is actually the only part that doesn't work. I don't have time to put much effort into debugging this problem. Does anyone know of a simple guestbook that utilizes ASP and Access?
View Replies
View Related
I want to create a web page for my friends.(I have a subdomain and my server supports ASP scripts) It will contain a small basic guestbook.It must write the entries to a text file on the server.And i must be able to view the guestbook.
View Replies
View Related
Right i am making an ASP guestbook. I have got the code and everything sorted for INSERTING into the database. But i dont no how to view the guestbook, in a guestbook kind of way I have searched everywhere, but theres no look.
View Replies
View Related
if any body could point me in the direction of some tutorials for creating weblog/guestbook style entries. Where the comments can be added, displayed and viewed by visitors.
View Replies
View Related
I have been looking around for a long time now to find one. All I want is a simple ASP guestbook script that is customilizational (sp) and free.
View Replies
View Related
i need a asp script out there for a guestbook. all the form input will be stored to a normal txt file, not a database. anyone have any links out there for this ? i have found a couple, but got errors when setting them up and it's been the script, not the server.
View Replies
View Related
Can anyone help me with a script to avoid people posting links in my guestbook ?
View Replies
View Related
Ok say a person puts their email into my guestbook example (joe@joe.com). Well i want to take the person's email and convert it to an image when they post it.
here is the code for the email anyone know how to do it?
<a
href="mailto%= CmdShowEntries("EMAIL") %>"><%= CmdShowEntries("EMAIL") %></a>
View Replies
View Related
I use a free database-driven ASP guestbook. I want to add a IP address
blocking filter to it( just to block one particular guest). What is the
easiest way to do so?
View Replies
View Related
i want to implement a guestbook on my website hosted on IIS.
i have created the form already and what i want is a page returned (after submission) saying thanx as well as showing the comments on it.
the fields i have chosen: name, email and comments.
i do not want it to be database connected but rather a file (txt) connected guestbook.
View Replies
View Related
I have made a guestbook in .asp. Everything is working fine in that. But the only thing I want to change is the order in which the messages appear on the guestbook. Let me explain properly -
At the moment whenever anyone enters a message, that last message comes first on the guestbook. I dont want that.
I want that anyone who puts the message in the guestbook, their message should come last in the guestbook and those who has already put their message first in the guestbook, their message should come first. Code:
View Replies
View Related
I'm trying to create a simple guestbook like script to work off a database. All I want is for people to add their Name and Comment in a form, and once a comment has been made, it directs off to another page which shows all the comments. Code:
View Replies
View Related
I have just started using ASP, I am normaly using PHP but I thought ASP might be a good road to go down. I am having a few problems, I am trying to limit the number of records I take out the database but I keep getting errors.
<%
'connection string
datapath=Server.Mappath("guest.mdb")
strconn="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & datapath & ";"
Set CONN = Server.CreateObject("ADODB.Connection")
CONN.Open strconn
'select all records row by row
DBquery="SELECT * FROM Guests LIMIT 10"
set query=Conn.execute(DBquery)
do while not query.eof
'get a variable from the table
guest_id = query("ID")
guest_name = query("Name")
guest_msg = query("Mesg")
guest_date = query("DateTime")
'print the variable to the screen
response.write guest_id & "<br />"
response.write guest_name & "<br />"
response.write guest_msg & "<br />"
response.write guest_date & "<br />"
response.write "<br />"
'move to the next record
set conn = nothing
query.movenext
loop
%>
I am getting this error;
Microsoft JET Database Engine error '80040e14'
Syntax error in FROM clause.
/guestbook/guest.asp, line 11
can anyone help me?
View Replies
View Related
I had made a form name 'dform.html' which asks idno, name and phone from the user and after the user clicks on button "save data" sdata.asp is executed. sdata.asp is written to save the values entered for idno,name and phone in dform.html into table "myfriends" in the mydata.mdb (access database). but when i am clicking on save data button i am getting error saying
"Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/SDATA.ASP, line 9"
can please anyone tell me why i am getting this error.
View Replies
View Related
I work with ASP for several weeks now and i really like it! But until now i have just used it in connection with my localhost. I made connections to a SQL Database and to an ACESS Database with using the ODBC Tool from WIndows!!
Now i want to publish my website but i don't know how to handle the connection string kind of thing. My MySQL-Database is on a different server than the website and i need a connection string where i can type in the server, a password and a username and it should then connect.
View Replies
View Related
I'm current working on a project which need to upload local data to
live server database.
Meanings that, i'm current having a server in my local mechine. I need
upload data from local database to live database which host at oversea
company. But i really have no idea how to do this in asp.
View Replies
View Related
Error Type:
Microsoft JET Database Engine (0x80040E21)
Cannot update. Database or object is read-only.
/q_maker/aero_admin/delete.asp, line 12
what is wrong! i checked the db and its not readonly.
View Replies
View Related
i wrote a shopping cart using cookies found out thatIE 7 won't let me add more cookies after a certian number. decided to use DB along with cookies and now i have very weired problem never encountered before Code:
View Replies
View Related
Products ---> Products|Customer <--Customer
With regardst the above many-to-many relationship:
Is there any advantage in creating seperate access databases for:
- Customer
- Products
....Rather than keeping them as three tables in one database.
The reason I ask is that I have found that if I am using a ftp approach to
overwriting or updating the remote database there are sometimes problems
with synchronizing data .....This seems to be a better solution?
Am I off base?
View Replies
View Related
does any one know a simple free database driven website tutorial that i could learn? i need it for when someone searches a name ionformation on that name comes up along with photographs realating to them.
I have built several websites before but none are database driven so is there any dummy proof versions?
View Replies
View Related
How do I do a Do While loop to display rows of information out of a database. Here's my code, and it seems like its in an infinite loop. Code:
View Replies
View Related
I have a Access DB with two tables (Users and tblpersons). Users are stored in table Users and their records in tblpersons. They are able to login, Enter, Search, Update their data.
I want users to be able to Enter and update only their data not other users data.
Example:User_Id 1 when logged in, is able to enter data for any user(1,2,3......) and able to modify their data.
View Replies
View Related
I can make a simple database file and name it database.mdb, all I need to do is name a single field email and save it. But I dont know how to make it so that my page will become active and the emails submitted will be saved either to the mdb file or a text file, im not sure what goes on there.
View Replies
View Related
i have 2 tables and i only want the records where which arent in the one database eg.
table 1
idnum
1
2
3
4
table two
idnum
1
2
3
4
5
6
out of these two tables i only want from table two idnum 5 and 6 cause they arnt in the 1st table.
View Replies
View Related
They are on Windows 2000 IIS 5.0 and currently have an older version
of their job database using Access hosted on a Brinkster server.
The new server that they are on, when I contacted the host, they advised me
against creating any new applications using Access, as the server is not meant
for multi-users.
So, I am thinking that they need to get their host to upgrade to a SQL database
and have the job database developed using that.
My question to this forum is: What do you think is the best combination for
improvement here, SQL or MySQL or what, considering that their site is using asp
and hosted on Win2000 IIS 5.0?
Also, any recommendations on scripts that might be already available that could
be customised to their site?
View Replies
View Related
What we have is our own (in house) Windows 2000 Server which runs MS SQL for our data storage and we have writen our own VB6.0 Application which runs of the SQL DB to manange our stock, ordering, price's etc etc. Also we have our own Website with a Web Hosting Company which is also a Windows 2000 Server but can only Run access databases.
What we what to do is somehow have the Access database and the SQL database sync together to have some of the same data in both database's. But I don't know where to start.
View Replies
View Related
I have the following code to execute a SQL query.Code:
SQL = "INSERT INTO teams (`teama`, `teamb`, `pot`, `winner`, `finished`, `start`) VALUES ('" & teama & "', '" & teamb & "', 0, '', False, '" & gdate & "')"
teamrs.Open SQL, conn
all works fine.
I just want to know what result it gives.because once i add it, the form submits, and its a blank page. I want it so it does this Code:
if sql = worked
redirect
else
error
end if
so how can i make sure the query was executed successfully.
View Replies
View Related
This is probably a stupid question (I'm good at those)...
I would like to enable a user to be able to browse to a picture on their local machine and upload that picture to a remote directory where it can then be displayed along with it's other pertinent data.
I thought it might be a good idea to use Front Page's "file upload" feature which includes a "browse" button and prompts me for a storing location - but I can't get it to work and am not even sure if that's its intended purpose.
So my question is two-part, what should my insert or update page look like regarding an upload process, and then how would I link to or display that picture?
View Replies
View Related
I have some questions in a database, i showed in the web page, for each questions i gave 3 (Yes, No, Not Applicable) options via select - option. when i get the variable with select name, it is showing with comma.
Example :
If they select for like that
Ist question - Yes
IInd question - No
IIIrd question - Yes
IVth question - Not applicable
The variable is coming like (Yes, No, Yes, Not applicable)
but i want to get with separate variables.
View Replies
View Related
