DeveloperBarn
finding values
This is a discussion on finding values within the ASP Development forums, part of the Programming & Scripting category; Hi, I have a table the design is like this Id Description I want to find out if the tables ...
| |||||||
|
#1
June 21st, 2008, 10:10 AM
| |||
| |||
 finding values Hi, I have a table the design is like this Id Description I want to find out if the tables description field has any values that start with Sem-Conf And if so then display all the values that start with Sem-Conf So say for example it will hold values like this Sem-Conf Discussion making for kids Sem-Conf Teach kids about maths So when i display the values i only want to display Discussion making for kids Teach kids about maths I tried the % in sql but it didnt work any idea todd  |
|
#2
June 21st, 2008, 01:36 PM
| ||||
| ||||
| It should be something like:- Code: strsql = "SELECT Id,Description WHERE Description LIKE 'Sem-Conf%'"
.
.
.
.
.
if not rs.eof then
do until rs.eof
response.write(replace(rs("Description"),"Sem-Conf ",""))
rs.movenext
loop
end if
Hope that helps. |
|
#3
June 23rd, 2008, 02:03 AM
| ||||
| ||||
| As I responded in the other forum about your database, you have an underlying flaw in the design of your table. It violates First Normal Form, in that you are coding more than one piece of data in the same field. In a properly designed table, every data field should be "atomic"--a single indivisible value. Then you wouldn't be having this problem. |
 |
|
| Bookmarks |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Store Calculated Values (Updating Fields) | sbenj69 | Access Database Samples | 9 | January 12th, 2009 11:49 AM |
| retrieve values | todd2006 | SQL Development | 5 | June 19th, 2008 01:46 PM |
| Finding Datalist Row on auto postback | richyrich | .Net Development | 1 | May 12th, 2008 04:52 AM |
All times are GMT -4. The time now is 06:19 PM.
