I am adding an IF THEN Statement to a display string.
IF Count ({PS_EMPLOYEES.EMPLID}, {PS_EMPLOYEES.JOBCODE}) > 100 THEN "Needs Attention"
ELSE CurrentFieldValue
I can't get the current field value to display if less than 100. It is coming up blank...
Please HELP!!!
Thanks
herschelrj
I need to have a link to close the browser popup when clicked and one that will go to a url in a new window and close the current window. Any ideas??? I know it can be done. I just am not too sure how.
I am trying to take some form data and put it into an Access database on the webserver. Any help??? I was using Frontpage but now Dreamweaver. Here is the code for the form...
<form method="POST" action="sh_reg.asp" name="FrontPage_Form1" language="JavaScript" onSubmit="return...
I saw a website that uses tabs as navigation. Does anyone know if this is an applet or can this be done with dreamweaver delivered???
http://sandi.net/staff/staffbull/2006/1103/index.html is the site.
I have two date fields, a hire date and a term date. I would like to subtract the hire date from the term date and come up with the nuber of years or partial years. Any help appreciated.
I tried this formula and when I check it, I get an error that says a date id required here where I replared the fild for the date. Can you help???
WhileReadingRecords;
DateVar Birth:= {NC_05.DOB}; // Replace this with your field for Date Of Birth
DateVar Ann := CurrentDate; // Replace this...
All,
I have just completed a website with dynamic pages. Everything looks and works great on my local machine. Now I am ready to place it on the production webserver. When I place the folder on the server, everything breaks. I end up the code being displayed instead of my data. I know it is...
Where do I find the setting or how do I get a page to not resize in the browser when you change the size of the browser? Should I set the pages to 100%? Any ideas appreciated...
herschelrj
Anyone know how to populate a drop down list in a form using data from a query and still have it insert when the form is submitted?
Thanks for any ideas...
HELP!!! I have a registration page that shows when a class is available or closed. It worked like a charm. I used the wizard to get it working. IT restarted the server and now my results page no longer works. The for works. The database connection works. But the Database Results returns the...
I am trying to learn how to submit a form and have it check to see if a particular course is full by checking a query that will give it the information and return an error "Class is full, please choose another date" without having to re input all previous form information.
Any ideas???
herschelrj
I have a registration page that needs to check to see if the course is available before submitting for confirmation and bringing back an error if the course is not open. Anyway to have the form run that check before submitting to the database? Any help is appreciated...
herschelrj
Here is the SQL.
SELECT LT9_FEB2005.crs_dt, Count(LT9_FEB2005.ID) AS CountOfID
FROM LT9_FEB2005
GROUP BY LT9_FEB2005.crs_dt;
I am looking for something like:
If CountOfID > 95 THEN "Course is Full"
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.