The result of the query is supposed to be the list of the products never ordered.
So, I'm selecting the product names from the product table minus the selection of the productnames with the join of product number from the product table and the ordered product table.
Hello. I have limited knowledge using Microft Access. I am trying to use the minus operation in my query and its producing an error. Below is the code along with the error code. Is there anything I'm missing in theory or is it just syntax. Any help is greatly appreciated. Thank you very...
Hello. I have this JavaScript code below. I need the code to process but then hault execution right before the end of the program for about 15 minutes, then re execute the code as a repetitive process say about a 100 times for example. Please let me know if this is possible. Thanks so much...
I'm sorry, I"m just a bit confused. So when the program runs the second time, what tells it that the first email was already sent, and it should not send again? Thanks so much.
Hello. I have a script that monitors a website and sends an email if the site is down. My issue is, I want to just receive one email in the span of the 10 minutes the program is ran. So, essentially, the program is run every 10 minutes. Should the specified error occur, an email is sent. My...
Hello. I am using Adobe Photoshop 6.0 I have a JPEG image that is a Title. There is a icon in front of the text title. I need to be able to just edit the title text without deleteing the actual icon. How would I go about making this edit change? Please let me know if you have any ideas...
Hello. I have these few Delete Statements below. I then get the server message below the code. Below the Server Message, I have listed the actual Foreign Key Constraint. Is there any way to actually Process the Delete Statements with the Foreign Key Constraint enabled? And, how would I do so...
Hello I have this code below. I am confused on what Fill Factor and Pad Index does in this code. Can anyone explain what they actually do in simple terms? I'm confused about their functionality. Thank you very much!
create table #emp
{
sessionid varchar(10),
USERID varchar(10),
SOLDTO...
Actually, I think the ASP program has other parameters in it that are not allowing it to display the neccessary data. Im going to try to see if I can get around it. Thanks so much.
Hello. I would like to do a SELECT ALL or SELECT * from the table in this code below. How would I actually code that?
SQLString = "SELECT" &_
" COUNT(*) AS Views," &_
" ESOLDTO" &_
" FROM" &_
" STATS" &_
" WHERE" &_
" EVENTNAME = 'LOGIN' AND" &_
" ETIMESTAMP...
I tried using this code. I can't actually get the ASP page to work? There are no errors shown. I am kind of confused on how to make this function. Would you have any ideas? Thanks so much.
Hello. Thank you for this valuable post. I'm just confused about why you would use two files, an html and an asp. I lack extensive web programming knowledge, so I apologize. Please let me know when you have the opportunity. Thank you so much. Take care.
Hello. Below I have some SQL code that is simple to select some data that I need. I have specified a specific value. I need to create some ASP code that would allow a user to enter any 'Sold-to' number and would then receieve the display count. I'm confused on how to set up the ASP to be...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.