I have the following piece of code that needs the last month added manually each month when it is run.
I'm sure there must be a way to do this automatically ?
Insert into Migration
Select h.PersonNo,
'May99' = '',
'Jun99' = '',
'Jul99' = '',
'Aug99' = '',
'Sep99' = ''...
I have the following scenario :
<table>
<tr>
<td> Picture here </td>
<td> writing here </td>
</tr>
</table>
The pictue is leaving a tiny space to the left, I was looking for a way to get it to leave no spaces (Padding 0; Margin 0; in body tags isnt working)
Going through the FAQ's I...
I am using padding 0; in my style sheet for body but I have a picture in the top right corner that is going all the way to the top but is leaving a 2-3 mm gap on the left no matter what I do.
Is there a way to force the left padding to be 0 ?
(I even put a leftmargin=0 tag in the body tag...
Anyone aware of the javascript you would use to make a redirect page?
ie : Redirect the user to a different page and maybe have one of this messages
"You will be redirected to XXX in 5 seconds, or else click on this link"
Obviously this is just an html file , and I guess you would include the...
Is it possible to include aggregates in an update statement?
I want to do the following that is not being allowed :
Update dbo.TmpMaster30_1
set t.FirstProm = min(h.Prom)
from dbo.TmpMaster30_1 t,
dbo.FACT_OF_PROM_ARCHIVE h,
where t.PersonNo = h.PersonNo
Is it possible to include aggregates in an update statement?
I want to do the following that is not being allowed :
Update dbo.TmpMaster30_1
set t.FirstProm = min(h.Prom)
from dbo.TmpMaster30_1 t,
dbo.FACT_OF_PROM_ARCHIVE h,
where t.PersonNo = h.PersonNo
I'm very new to photoshop as you will tell from my questions, I was wondering if someone could let me know the steps to achieving the following 3 things :
1. Placing one picture ontop of another
2. Cutting a picture out (ie : cutting part of a pic away from its background).
3. Changing the...
I get my user to choose a value from a drop down and then when Iprint the form, the value, not the select box appears.
To do this I use :
<span class="noPrint"><select style="width:150px;" name="Company">
//// My select box is here
</select></span><div id="select"></div>
<script>...
I have a sql query that gets generated froman asp page, depending on what a user selects.
There could be any amount of :
- UserID 's
- Vehicles_Trips.VID 's
and the trip_diff and Mil_diff will be "<" or ">" a certain amount.
When I create the list of UserID's or VID's I use "or", and the...
I want to write an if statement to say if a certain value is over 0 then i need to check if two other values exist, and if they do not i need to prompt the user.
It sounds easy but I'm quite new to this :-)
somewhere along the lines of :
function checkForm(form) {
if (form.Min.value > 0)...
I want to calculate the difference between two given times. The times will be given in the format hhmm (eg : 1030).
What would be the best way if I had a start and end time to calculate the difference between the two (answer in minutes)?
I thought of something like this but its not right ...
I am using the following pop up , is it possible to put the text onto more than one line ? (would do what <br> does in HTML). So i want the two sentances to be on seperate lines, not 1 long line.
<script language=VBScript>
Function a()
If MsgBox("One of your Pieces exceeds the Max or...
i want to open a ASP page in a seperate browser window, I use the following :
<script language="javascript">
window.open('../quotes/ViewQuote.asp','X','top=25,left=25,width=880,height=500',true);
history.back();
</script>
How would i change this if i wanted it to be the size of a...
I have heard 2 diff versions of what page-break-before:auto does,
1. nothing : default printer setting apply.
2. If its before a certain table/object it will force a page break if that table/object dosnt fit on the page.
The 2nd one is what many websites say and this is what I want, but its...
when i create a PDF from my ASP pages i use the following.
anyone know how i can enter a footer image (for every page).
(i have tried --footer "C:/image.jpg")
i'm using :
Set myexec = Server.Createobject("Dynu.Exec")
Result = myexec.execute(PathToHTMLDOC &...
How do i create a popup using vbscript from an ASP page that answers a question and if i click yes the webpage will change to one page, if i click no it will change to a different one.
thanx.
From my ASP webpage I'm using the following code to make a PDF (its working fine):
Set myexec = Server.Createobject("Dynu.Exec")
Result = myexec.execute(PathToHTMLDOC & "htmldocd.exe --webpage --size a4 --top 0.2in --left 1.2cm --right 1.2cm --bottom 0.2in -f...
How do i create a popup using javascript from an ASP page that answers a question and if i click yes the webpage will change to one page, if i click no it will change to a different one.
thanx.
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.