Hi all.
Im new to ASP, and have hit a snag.
I am trying to build a page that has 'A-B-C-D...' links along the top
of the page. When you click 'A', it goes to a table with everyones
usernames and grabs the ones that start with the letter A.
The problem is that the username field contains the names of people
who wrote an article, so in some cases there are actually two names in
this field. So for example, if it contained 'Bob, Jack', I would need
'Bob' to show up under B, and 'Jack' under J.
Im totally stuck as to how I might do this. Changing the layout of my
tables is no trouble if a different table setup helps. Any thoughts? 4 1049
If they're always going to be stored in that format, you can do a select
statement with LIKE B% OR LIKE %, B% or something to that effect. Kind of a
hokey way to do it, but it should work.
"Boolean" <th**************@hotmail.com> wrote in message
news:85**************************@posting.google.c om... Hi all.
Im new to ASP, and have hit a snag.
I am trying to build a page that has 'A-B-C-D...' links along the top of the page. When you click 'A', it goes to a table with everyones usernames and grabs the ones that start with the letter A.
The problem is that the username field contains the names of people who wrote an article, so in some cases there are actually two names in this field. So for example, if it contained 'Bob, Jack', I would need 'Bob' to show up under B, and 'Jack' under J.
Im totally stuck as to how I might do this. Changing the layout of my tables is no trouble if a different table setup helps. Any thoughts?
"Boolean" <th**************@hotmail.com> wrote in message
news:85**************************@posting.google.c om... Hi all.
Im new to ASP, and have hit a snag.
I am trying to build a page that has 'A-B-C-D...' links along the top of the page. When you click 'A', it goes to a table with everyones usernames and grabs the ones that start with the letter A.
The problem is that the username field contains the names of people who wrote an article, so in some cases there are actually two names in this field. So for example, if it contained 'Bob, Jack', I would need 'Bob' to show up under B, and 'Jack' under J.
Im totally stuck as to how I might do this. Changing the layout of my tables is no trouble if a different table setup helps. Any thoughts?
Database? Version? DDL? Sample Data? Desired Output? http://aspfaq.com/etiquette.asp?id=5006
Absent this information all I can offer is prose. You may want to consider
creating an articles table with a one to many relationship to an authors
table. Then create a stored procedure/parameterized query based on the
authors table joined to the articles table passing in an last_initial
parameter used to filter the data.
I wrote a function to check for a valid email...
function IsEmailValid(email)
dim sql
sql = "usp_isemailvalid " & email
set rs = conn.execute(sql)
if rs.eof then
IsEmailValid = false
else
IsEmailValid = true
end if
end function
how can I use that function in an if statement ??
if IsEmailValid(email) = true then
response.write("success!")
else
response.write("fraid not!")
end if
if IsEmailValid(email) then
response.write("success!")
else
response.write("fraid not!")
end if
dlbjr
Pleading sagacious indoctrination! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Drew |
last post by:
I would like to explore some different ways to build a link out of the
following string from a db,
Fiscal; swvtc/fiscal/fiscaldata.asp: Records; swvtc/records/recordsdata.asp:
Which is just a...
|
by: Don Seckler |
last post by:
I am building an application to track the distribution and returns of
copies of magazines.
Copies of a magazine that are unsold are returned by the retailer to
the wholesaler. They are...
|
by: Robert |
last post by:
How can I query an existing table and update a field in each record in the
table with the occurrence count of each record e.g. update field to 1 (=
first record occurrence), update field to 2 for...
|
by: KC |
last post by:
I am using Access 2002, with a database template from MS Office. The
Orders Management Database. I have tweaked this for use with our
company. It is a small database with close to a 1000 records...
|
by: tpcolson |
last post by:
I have a fairly large access 2003 table (200,000) records. Field 'X' is
a text field, and contains either no value, 4 digits, 5 digits, or 6
digits. What I need to do is to add two zeros to the...
|
by: GeRmIc |
last post by:
Hi,
I receive an XML string like
<record>
<value>...</value>
</record>
<record>
<value>...</value>
</record>....... etc.,
|
by: fernandezr |
last post by:
I've successfully created a dynamic menu pulling data from a database
however all links thus far have all been virtual urls such as
/ABCD/default.aspx, /ABCD/profile.aspx, etc. Now I want to add...
|
by: Mark |
last post by:
Hello.
I am attempting to use AppendChunk() to write binary data to a memo field
in Access 2000. My initial call to AppendChunk() results in a data type
conversion error. Any suggestions? Here...
|
by: imtmub |
last post by:
I have 3 table for Purchase Order from ERP Database
Tables:
POD=Purchase order Details(this table has Require Qty field)
POR=Purchase Order Receive (This table has RequireQty and ReceiptQty...
|
by: Gordon Padwick |
last post by:
A form contains controls, one or more of which can be other forms. A form that contains another form is known as a main form. A form contained by a main form is known as a subform. A subform itself...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |