Ask a Question related to Coldfusion Database Access, Design and Development.
-
yoman #1
How to delete items NOT in a list
I have a table with current movie titles identified by ID number and another
table with reviews of those items, also containing the ID number. The table of
current films is updated daily from an external file. The reviews go untouched.
How do I remove reviews that are NOT in the list of current films?
Table 1: FilmCode, FilmTitle
Table 2: FilmCode, Review
- Baffled
yoman Guest
-
JavaScript: html list items within list items?
Hi, I've seen how to implement a JavaScript to change the CSS class of every other list item in an unordered list, but, being new to JavaScript,... -
Accessing DataRow Items by Name in Edit/Update/Delete Event
Hi there. I have a small problem with DataGrid in ASP.NET & C#. In the ItemDataBound Event I can use the following code DataRowView drvSE =... -
Delete Multiple items with checkboxes
Hello all, I'm sorry for posting this because you probably answered this question a million times, but i didn't got my script to run yet. I'm... -
can not delete items from desktop (2k server & AD)
Hello, I deleted some items from desktop. When I log on, items came back. We have 2k server with AD. Profie are on server. Thanks for your... -
List items in a folder
I would like to be able to list a directory (or something like it)of the contance of a certian folder. How can this be done on a web page? TIA Jim -
philh #2 Re: How to delete items NOT in a list
delete from table2
WHERE filmcode NOT IN (
SELECT filmcode FROM table1)
philh Guest
-
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
