473,324 Members | 2,548 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

problems with asp


hi guys ive just started this forum and ASP programming and so far its
not too bad I was wondering if any one can help. Am creating a book
search website which sellers can add books to the database with their
details for users to contact them. Am trying to search from two tables
seller and books, where the users will enter a book title in a textbox
if that title exits it will display book title and seller's pnumber with
their e-mail and name. Please help me ive been working on this for weeks
without any result.
your response will be much appreciated.

i have two tables seller and books
book(table)
books
bookID
pnumberID
author
price
keyword
title etc..

seller(table)
bookID
pnumber
password
name
surname
email etc...

*** Sent via Developersdex http://www.developersdex.com ***
Feb 23 '06 #1
2 1263

shaz kahn wrote:
hi guys ive just started this forum and ASP programming and so far its
not too bad I was wondering if any one can help. Am creating a book
search website which sellers can add books to the database with their
details for users to contact them. Am trying to search from two tables
seller and books, where the users will enter a book title in a textbox
if that title exits it will display book title and seller's pnumber with
their e-mail and name. Please help me ive been working on this for weeks
without any result.
your response will be much appreciated.

i have two tables seller and books
book(table)
books
bookID
pnumberID
author
price
keyword
title etc..

seller(table)
bookID
pnumber
password
name
surname
email etc...


Did your post get truncated? I don't see a question. What's the
problem you need help with?

/P.

Feb 23 '06 #2
"shaz kahn" <sh*********@excite.com> wrote in message
news:eR**************@TK2MSFTNGP15.phx.gbl...
seller and books, where the users will enter a book title in a textbox
if that title exits it will display book title and seller's pnumber with
their e-mail and name.


It should have been asked in the "asp.db" group but,...

I would use better tables names and different fields. I would also use
naming conventions. Table names begin with "tbl", field names beging with
"fld".

tblBooks
fldBookID
fldPnumber
fldAuthor
fldPrice
fldTitle

tblAuthors
fldAuthorID
fldName
fldSurname
fldEmail
fldPassword
fldBookID

The SQL Statement might be something similar to this:
(I'm not an SQL or database expert)

SELECT
tblBooks.fldBookID,
tblBooks.fldTitle,
tblBooks.fldAuthorID,
tblAuthor.fldName,
tblAuthor.fldSurname,
tblAuthor.fldEmail
FROM
tblBooks
INNER JOIN
tblAuthor
ON
tblBooks.fldBookID = tblAuthor.fldBookID
WHERE
tblBooks.fldTitle
LIKE
%"some title name here"%

I recommend that you create a Parameterized Query (if using Access) or a
Stored Proceedure (if using SQL Server) and don't put raw SQL statements in
the ASP code.

And you should be asking this type of question in:
"microsoft.public.inetserver.asp.db"

--
Phillip Windell [MCP, MVP, CCNA]
www.wandtv.com
-----------------------------------------------------


Feb 24 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Jerome Lefebvre | last post by:
Hello, Hope this will interest a few. I been working with a friend on the problems given out during the "International Collegiate Programming Contest" (ICPC) http://icpc.baylor.edu/icpc/ ....
14
by: Jim Hubbard | last post by:
Are you up to speed on the difficulties in using the 1.1 .Net framework? Not if you are unaware of the 1,596 issues listed at KBAlertz (http://www.kbalertz.com/technology_3.aspx). If you are...
1
by: 3f | last post by:
Hello; We have made a web application that people can download from our web site and installed on: Windows XP Windows 2000 Professional Windows 2003 Server Windows 2000 Server
5
by: Corky | last post by:
This works: db2 SELECT DISTINCT PROBLEM_OBJECTS.PROBLEM_ID FROM PROBLEM_OBJECTS INNER JOIN PROBLEMS ON PROBLEM_OBJECTS.PROBLEM_ID = PROBLEMS.PROBLEM_ID WHERE INTEGER(DAYS(CURRENT DATE) -...
2
by: Ellen Graves | last post by:
I am having a lot of problems with DB2 8.3.1 on RH Linux AS2.1. Installing and running stored procedures is problematic. Stored procedures I have used for years on V7 on WinNT are now failing...
19
by: Jim | last post by:
I have spent the past few weeks designing a database for my company. The problem is I have started running into what I believe are stack overflow problems. There are two tab controls on the form...
10
by: BBFrost | last post by:
We just recently moved one of our major c# apps from VS Net 2002 to VS Net 2003. At first things were looking ok, now problems are starting to appear. So far ... (1) ...
19
by: Dales | last post by:
I have a custom control that builds what we refer to as "Formlets" around some content in a page. These are basically content "wrapper" sections that are tables that have a colored header and...
2
by: Brian | last post by:
NOTE ALSO POSTED IN microsoft.public.dotnet.framework.aspnet.buildingcontrols I have solved most of my Server Control Collection property issues. I wrote an HTML page that describes all of the...
0
by: Sergistm | last post by:
Hello World, :D I have a problem that it is making me crazy, I hope you can help me. I'm trying to execute a .exe file with the Procces.Start, and there is no problem when the file is on my...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.