I have two tables. Table1 contains the names of training classes being offered and Table2 has the names of the people who are going to attend. The code below lists the classes being offered and a links to add, remove, and view other employees that are attending that class.
I only want the remove button to appear if you have already signed up for the class. I also only want the remove button to appear if the username cookie equals the username of the person that is signed up for the class which means the employee that wants to be removed from the class has to do it. My insert code (not shown) puts the username in the cookie into the Table2.
I tried using this code to accomplish what I wanted above but it does not display the remove button if the person is signed up and trying to remove themself. Code:
I have this page with a drop down box which loads the itemnumbers dynamically. However, I want it to NOT load the numbers that already exist in the weborderlist. What can I do to my SQL statement to make this work?
Code:
SELECT (SELECT img_inv.item_num from img_inv, weborderlist WHERE img_inv.item_num <> weborderlist.item_num and weborderlist.orderid= '1') as test
I have a two tables in my database with a username column in both of them, i am trying to build an SQL query to return only the usernames that are not listed in both of the tables. Any ideas?
I develop a .asp app that reads its data from an Access DB "A", and I have a desktop app with a FoxPro DB "B".
How can I insert data from a table in DB "A" to a table in DB "B". Im new to asp and I really know only the basic's, so who can guide me to a tutorial or where can I dowload an example...
im currently working on a login system, and its the first time i have had to use an inner join. basically i have 2 tables, an attendance table and a member table. the attendance table contains the following: Code:
if i wanna list data from 2 tables at the same time, is that possible. i have 2 tables: itemsorderd and orders, which both have OrderID.
now i want to list the 2 fields from itemsorder which are Quantity and ProductID, as well as all the fields from orders, which contains the shipping details. how can i do that in a single SQL statement ? also if i wanna delete all these datas associated with the OrderID, how can i do that ?
There will be only one user maintaining the Table 1 then another user maintaining address only in table 2. So the second user need to retrieve the data from table 1 on the IC No. how should i do it? is it using session?
I have 3 tables, product, industry and plist. product has productID and product, industry has industryID and industry, plist has productID foreign key with productID on product table and industryID foreign key with industryID on industry table.
In the plist table I am storing the productID and the industryID's that relate to that productID..
industryID productID 1 4 1 7 1 9 1 10 etc.
What I want in my ASP page is to return the actual products that each industry serves. So for the above example my script should return the products in the product table that relate to the productID's 4, 7, 9, 10, when I search it by industryID 1. I hope this is making sense. Code:
I want to create another Database using ASP, this I can do. However, what is the easiest way to copy tables from one DB to this new DB?
I dont really want to have to write the SQL to create each table and then to use a 'select into' code for table, especially as I have around 15 tables to do!
I have 3 tables (MS Access) and I would like to display the content of all three tables alphabetically on a .asp page I have no problem displaying a list from each of the individual tables, but I am stumped when I try to display a combined listing..
Im comparing values in a field while doing a loop if sAct<>myData(5,i) then At the end of the loop I make the value of sAct equal the current myData
This will work when comparing other fields withing my recordset (so I know the statement works) but it will not work for the field I want to compare. The only difference with this field is that it has null values. Could this be the problem? if so, how do I deal with nulls?
I have two tables Property & Landlord. I have a form and when it is filled in and submitted the information should be sent to the two tables, but i cant seem to get my head around this problem.
Imagine an asp-script that retrieves data from a database and returns an HTML with table of the retrieved data, allowing user to edit some values and delete rows. The issue occurred after deleting a row. Lets say the initial table was: Code:
I know how to create dynamic tables in dreamweaver to display fields and records in a table of a database, but in my case I need to create a dynamic table that lists all the tables in the database, then to click on the one i want 2 edit the data in there.
I have an array, let's say: a(test1, test2, test3). test1 = 1, test2 = 3, test3 = 4. I have a for loop: for z= 0 to 2 if a(z) > 0 then (what I am trying to do is if test1 > 0 then do ...) somecode end if; next Could anyone let me what is wrong with my if statement? The code inside the if statement does not executed.
i am having a problem with comparing two strings. I am taking in the parameter rs("Company") and if this is empty i want to put some text in there. I am testing it with an empty Company field and comparing it like so:
temp1=rs("Company") temp2=StrComp(temp1,NULL)
I have also tried it with temp2=StrComp(temp1,"")
but each time i get nothing returned. Is there some rule about comparing a string with an empty string?
I have an expiry date stored as a text field in the following way "2003-08-23" (this gets round the US/UK date prob)
The problem is I want to be able to show a Renew option on the page FROM 30 days prior to that date. And then of course if they don't renew, it unsubscribes them.
Question, how can I compare this date to see if todays date is 30 days or closer to the expiry date?
Need to do a search engine to search through a bunch of static pages (html)). so uing asp. but the page is in chinese, so how do i scan each and every html file and search for the chinese word?
<% rs=Server.CreateObject("ADODB.recordset"); rs1=Server.CreateObject("ADODB.recordset"); sql="select coi_index_number,status,mkt_id_swno_0,mkt_id_swno_ 1,mkt_id_swno_2,mkt_id_swno_3,mkt_id_swno_4,mkt_id _swno_5,mkt_id_swno_6,mkt_id_swno_7,circle,name_of _msc from coi where coi_index_number='"+p2+"'"; sql1="select coi_index_number,status,mkt_id_swno_0,mkt_id_swno_ 1,mkt_id_swno_2,mkt_id_swno_3,mkt_id_swno_4,mkt_id _swno_5,mkt_id_swno_6,mkt_id_swno_7,circle,name_of _msc from coi1 where coi_index_number='"+p2+"'"; %>
Now i need to compare these two above mentioned recordsets....and want to pop up an alert box on the client side.....sayin whether they are same or no.
I have a simple html/asp form that submits data to an access DB. The idea is when calling a record back from the db, the page will have an option to change certain fields (drop down) then a new submit option. My question at this point would be what logic or commands would I use to compare the original data in the fields to what's being submitted.
I ultimately want to preserve the original records and somehow append data that changes only. I'll need to eventually call a record and see all the changes/updates made. Someone mentioned I would prob need a couple of tables with a link (relationship) but is it possible to dynamically create fields as changes are made?
basically the first array holds all the text_ids for the table text and the second array holds all the text_ids on a table join. What i mean is i have joined two tables text and text_section and it lists all the textids in the section.
i need to return a list of the textids that are not listed in the section so i need a way of comparing the two arrays and pulling out the ids that appear in array1 and not array 2 .
I have ASP code to compare an input date and the current date. If the input date is less than today, it should give an error message. It does do this, except it doesn't consider the year, only the month and day. If I input 7/12/2004, it will not catch the discrepancy, but if I input 2/3/2005, it will. Here is the code...
Comparing dates ?!? I having fun with dates, NOT….. I have a place where I need to compare 2 dates. Even though they are the same they will not be compared as the same in an IF statement.
Donw is a # of the day of the month, IE: 26 that is pulled from a data base. The goal is to compare dats like this :
IF ( donw ) = day(now) then ----Red stament Do this Bla Bla---- Elseif (donw ) = day(now) – 1 then ----Yellow stament Do this Bla Bla---- Elseif (donw) < day(now) then ----Green stament Do this Bla Bla---- end if
I need to compare the actual time on my server to the value I'm receiving on a database. For example, let's say the actual time is 1:45 PM and the value in the database is 11:52 AM. I need to compare that if the actual time is after the one on the database, it returns a true value, if not returns a false value.
I tried this ASP code, bit it didn't worked, any ideas? Code:
varDate = Date() SQL="SELECT id,name,eventtype,location,fromdate,todate FROM events WHERE publish='1' and fromDate > "& varDate &" ORDER BY fromdate asc"
fromDate is a Date/Time field in access. What i want to do is pick out any data which has a fromDate which is greater than today but the sql command isnt picking out any data. does anyone know how i could change my script to work.