|
does anybody know how to stop outlook totally screwing up html email when it is forwarded? the mail is fine forwarded from outlook express ... it seems outlook inserts its own stylesheet
anybody have any experience with this?
thnx
"there is no spoon" biz stuff about me
|
|
|
|
|
This is my first update record and I'm trying to get ideals on a great way to do it. I am basically using a checkbox to select a record to update. I was able to borrow some code "The Code Project (ASP Help Board, similiar to ASPFREE)". A nice guy name Torsten Mauz left the link. So I incorporated it into my code, but I can't get it to work. Can someone give it a look...and spread the wealth... the Code is below.
<% Language ="VBscript" %>
<%
Dim CnDB
Dim rsData
Dim strConnect
Dim strSQL
Dim srchLastName
%>
<title> Resource Pool Database Record Update
Resource Employee Pool - Update Search for:
<%
'''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''
' ASP CODE / Opens the recorDset and AND selects all the data '
' and writes the database to the screen. '
'''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''
srchLastName = Request.Form("strLastName")
If srchLastName <> "" Then
Set CnDB = OpenDB() 'Opens the Database
Set rsData = Server.CreateObject ("ADODB.RecordSet") 'Opens the Recorset
strSQL = "Select * From ****** Where LastName = '" & srchLastName & "'" 'Selects all the data in the database
Set rsData = CnDB.Execute(strSQL) 'Executes the command to retrieve the database
'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''''''''''''''''''''''''''''''
' This setsup the table for writing the files to the database '
' '
'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''''''''''''''''''''''''''''''
If Not (rsData.EOF) Then
%>
<%
Dim rsEmpId
Dim rsFirstName
Dim rsLastName
Dim rsWorkDay
Dim rsCUnion
Dim rsBranch
Dim rsDept
Dim rsTimeIn
Dim rsTimeOut
Dim rsLunchOut
Dim rsLunchIn
Dim rsTotalHours
Dim rsAuthSig
Do Until rsData.EOF
'rsEmpId = rsData("EmpId")
rsLastName = rsData("LastName")
rsFirstName = rsData("Firstname")
rsWorkDay = rsData("Workday")
rsCUnion = rsData("CreditUnion")
rsBranch = rsData("Branch")
rsDept = rsData("Dept")
rsTimeIn = rsData("TimeIn")
rsTimeOut = rsData("TimeOut")
rsLunchOut = rsData("LunchOut")
rsLunchIn = rsData("LunchIn")
rsTotalHours = rsData("THours")
rsMetricHours = rsData("MHours")
'rsAuthSig = rsData("AuthSig")
Response.Write ""
'Response.Write "Update | Last Name | First Name | Work Day | Credit Union | Branch | Department | Time In | Time Out | Lunch Out | Lunch In | Total Hours | Metric Hours | Authorized By |
---|
"
'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''''''''''''''''''''
' Borrowed Code '
'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''''''''''''''''''''
dim iNum 'the number of checkboxes to generate
dim strAll 'a comma delinated list of all the values
dim i 'a loop counter
dim arrAll 'an array which will hold all of the values
dim arrVals 'an array to hold all checked values
dim arrInactive() 'an array to hold all unchecked values
dim bThere 'a boolean match variable
dim IDX 'an index variable
'dim strSql 'the resulting SQL string
dim z 'a loop counter
iNum = Request.QueryString ("numBoxes")
if iNum = "" then
iNum = 10
end if
if Request.Form = "" then
strAll = ""
%>
<%
'**********************
'this would be your recordset loop
'basically replace i with the ID of the record.
for i = 1 to iNum
Do
%>
<%
''''''''''''''''''''''''''
'' My Code '
''''''''''''''''''''''''''
Response.Write "" & VbCrlf
Response.Write "" & VbCrlf
Response.Write "" & VbCrlf
Response.Write "" & VbCrlf
Response.Write "" & VbCrlf
Response.Write "" & VbCrlf
Response.Write "" & VbCrLf
Response.Write "" & VbCrLf
Response.Write "" & VbCrLf
Response.Write "" & VbCrLf
Response.Write "" & VbCrLf
Response.Write "" & VbCrLf
'Response.Write "" & VbCrLf
Response.Write ""
rsData.MoveNext
Loop
rsData.Close
CloseDB CnDB
End If
'''''''''''''''''''''''''''''''''
' Borrowed Code Continues '
'''''''''''''''''''''''''''''''''
%>
<%
'append the id to strAll
strAll = strAll & i & ","
next
%>
<%=i%> | | " & rsLastName & " | " & rsFirstName & " | " & rsWorkDay & " | " & rsCUnion & " | " & rsBranch & " | " & rsDept & " | " & rsTimeIn & " | " & rsTimeOut & " | " & rsLunchOut & " | " & rsLunchIn & " | " & rsTotalHours & " | " & rsMetricHours & " | " & rsAuthSig & " | |
<%
'trim off the trailing ","
strAll = left(strAll, (len(strAll) -1))
%>
<%
else
'get the array with all of the checkbox id's
arrAll = split(Request.Form ("allBoxes"), ",")
'get the array with the id's that were ticked
arrVals = split(Request.Form ("chkBox"), ",")
strSql = ""
strSql = strSql & "UPDATE aTable SET active = 1 WHERE "
'loop through the checkboxes which were ticked
for i = 0 to ubound(arrVals)
if i = 0 then
strSql = strSql & "id = "& arrVals(i)
else
'only add the " AND " if this is not the first value
strSql = strSql & " AND id = "& arrVals(i)
end if
next
Response.Write strSql & " "
'dimension the array to the size we need
redim arrInActive(ubound(arrAll) - ubound(arrVals))
'set our indexer variable
IDX = 0
'loop through all the checkbox values
for i = 0 to ubound(arrAll)
'a boolean value to check if we match or not
bThere = false
'loop through the values which were submitted
for z = 0 to ubound(arrVals)
'if it is found then set the boolean to true
'this is so we don't add it to the new array
if trim(arrVals(z)) = trim(arrAll(i)) then
bThere = true
end if
next
'if it wasn't in the submitted array (i.e. it wasn't checked)
if bThere = false then
'add the value to the new array
arrInactive(IDX) = arrAll(i)
'increment our indexer
IDX = IDX + 1
end if
next
strSql = ""
strSql = strSql & "UPDATE aTable SET active = 0 WHERE "
'loop through the array which holds the values that were NOT ticked
for i = 0 to ubound(arrInactive)
if arrInactive(i) <> "" then
if i = 0 then
strSql = strSql & "id = "& arrInactive(i)
else
'only add the " ADD " if this is not the first variable
strSql = strSql & " AND id = "& arrInactive(i)
end if
end if
next
Response.Write strSql
end if
%>
{ alert("A LastName Is Required to Do a Search");
}
Click Here to Search again
<%
End If
Loop
End If
%>
Thanks:
Vision: The ability to see the invisible.... |
|
|
|
|
|
i am trying to set up a new website on my computer. When I go to manage on My Computer ->Service And Application -> Websites ->
There is no default websites folder under websites. Is that because Microsoft Visual Studio.Net and IIS were installed in the wrong order? Please Help!!
thanks in advance
|
|
|
|
|
The path as u should have traced is,
(Right Click) My computer-> Manage<br />
<br />
Services & Application -> Internet Information Services -> Web Sites -> Default web Site
If u still dont see this... then probably you should check ur IIS installation. Let me know if u still have probs
I was born intelligent Education ruined me!.
|
|
|
|
|
Hi.
I'm curently on a larger project where we need at tool that can take convert a webpage into a pdf document.
We want to be able to give a html page that is "printer friendly" and have it convert it into a pdf page.
It has to be .NET based and _must_ support CSS.
The price is not important.
Is there anyone outthere that knows of any good tools?
|
|
|
|
|
check this out.. maybe it will help alittle
http://www.sp.uconn.edu/~fdb94001/using-gs/make-pdf.html
in order to use this tho you will need to allow the user to print from the browser..
Will
|
|
|
|
|
I a developing a website that is going to need to use some kind of credit card payment. Can you please suggest a good place that offers this secure transaction, something like Pay Pal? Or is this something that I need to organise with the bank? And then lastly, how do I manage this credit card transaction with regards to:
How do I know who has paid? How do I know when someone’s membership has expired? How do I know how the member has subscribed for? Must I create my own tables for this? Surely there must be some kind of link between the member user ID to a transaction information table?
Can you please provide some thorough information on this topic. Remember it must be able to accommodate international users.
Thanks
|
|
|
|
|
Some one earlier said... "CP is a place for clearing your doubts and getting idea - and not a place to get your homework done"
I was born intelligent Education ruined me!.
|
|
|
|
|
WHAT CORNY ANSWERS ARE YOU GIVING?
CAN'T YOU SEE MY QUESTION?
|
|
|
|
|
|
and dude
if u think this looks like a homework question id have to say maybe schools are finally teaching things for the real world ... which i highly doubt
"there is no spoon" biz stuff about me
|
|
|
|
|
l a u r e n wrote:
schools are finally teaching things for the real world
What else do they teach then??
I was born intelligent Education ruined me!.
|
|
|
|
|
nice neat theoretical stuff that always seems to have nice exact answers in ideal conditions in a warm fuzzy world where everything works like it is supposed to
meanwhile... back in the real world...
"there is no spoon" biz stuff about me
|
|
|
|
|
S P S wrote:
What else do they teach then??
Well, my introduction to Object Orientation was along the lines of
class Animal
{
abstract string BreathsThrough;
abstract int NumberOfLegs;
}
class Mammal : Animal
{
string BreathsThrough{return "Mouth";}
}
class Dog : Mammal
{
int NumberOfLegs{return 4;}
}
class Human : Mammal
{
int NumberOfLegs{return 2;}
}
class Fish : Animal
{
string BreathsThrough{return "Gills";}
int NumberOfLegs{return 0;}
}
class Cod : Fish
{
}
class Salmon : Fish
{
}
etc. I've never had to use this in the real world.
"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
|
|
|
|
|
Colin Angus Mackay wrote:
I've never had to use this in the real world
What makes you realise the difference between Human and Dog... I mean... the
int NumberOfLegs
isnt it so??
I was born intelligent Education ruined me!.
|
|
|
|
|
http://www.moneybookers.com[^] Then click into Merchant Services. The specialise in International payements.
It has two ways - an email method (similar to PayPal) and a more integrated approach. They have a FAQ that may help answer some of your questions. As for correlating your information with that returned from the credit card transactor it is up to you. Normally, you'll pass some id or unique value through with the transaction details, which then come back to you with a details of whether the transaction was successful or not.
"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
|
|
|
|
|
id recommend paypal where u can use it or maybe ibill (www.ibill.com) would suit ur needs better ... they have products that manage membership and all that altho they are a bit invasive for my taste
"there is no spoon" biz stuff about me
|
|
|
|
|
Hi aLL !
I am trying hard but with no success, maybe one of you guys/gals here can help..
I am kind of desperate..
What I want is this:
When people make a shortcut to my web page, the icon that will appear with the shortcut (let's say, on the desktop) will not be the blue 'e' icon, rather my own 'handmade' icon.
What's the way to do this ?
Thank you very much !
jeevan
|
|
|
|
|
|
It seems to me that the creation of a DOM at the server is a very expensive proposition that is needed only to serve the server controls. If we were to provide a two pass process, we could use <%= %> within server controls and more cheaply provide the same benefits as that of having the ViewState-control integration. A simple Value function could provide data from the "postback" or from the database.
Curious
Thank you
|
|
|
|
|
Hi! I just want to inquire regarding CSS. Below is the sample CSS declaration
body
{
scrollbar-face-color: #E5EFE5;
scrollbar-highlight-color: #E5EFE5;
}
I just want to ask if there is any possible solution to read the values to be define in the CSS from a database, table record. Ex. the value #E5EFE5 (is stored in a table)? What are the alternative solution or how it should be coded from asp?
Thank You Very Much
Maricel
|
|
|
|
|
you can embed the style in the html page using
and read the values from the DB.
also you can use inline style:
also you can make your style sheet file an ASP not CSS file so the style file is generated by code.
|
|
|
|
|
external CSS is used because there are more than 100 pages. The design is somehow a part of content management for a scroll bar design and background color. Could you please further explain about the previous answer you have given by showing some examples. As well how could I make my style sheet an ASP file?
Thank You So Much
|
|
|
|
|
Hi
to add a style sheet to an html page you do this :
<link rel=stylesheet href=Css/Style.css>
the change you'll do is :
<link rel=stylesheet href=Css/Style.ASP?PID=123>
in the Style.ASP page you'll check for request.Querystring("PID") and use this value to lookup data in a database like :
rs.Open "Select Scroll_Color from ColorTable where PageID=" & request.Querystring("PID")
then you write this data to the style sheet page
something like this :
response.write rs(0).Value
|
|
|
|
|
Hi!
Thanks for the reply, with the sample you have given, but how does the following:
scrollbar-face-color: #E5EFE5;
scrollbar-highlight-color: #E5EFE5;
as well as the other declaration in CSS such the font and links will be done and appear when the user loads the page how will it take effect?
thanks
additional question:
i've check out the sample you have given
in the asp page i called in the style sheet the asp page and the id it should pass
this is the sample asp page that contains the information for style sheet and color of the scroll
<%
pageid_ = Request.QueryString("pageid")
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open Application("sampleDSN_ConnectionString")
colorSQL = "SELECT * FROM tblColor where pageid= '"& pageid_ &"'"
Set rs = Conn.Execute(colorSQL)
if rs.eof then
else
bgcolor_ = rs("bgcolor")
end if
%>
body
{
scrollbar-face-color: <%=bgcolor_%>;
scrollbar-highlight-color: <%=bgcolor_%>;
scrollbar-3dlight-color: <%=bgcolor_%>;
scrollbar-darkshadow-color: <%=bgcolor_%>;
scrollbar-shadow-color: <%=bgcolor_%>;
scrollbar-arrow-color: #CC3333;
scrollbar-track-color: <%=bgcolor_%>;
overflow-x:hidden
}
.content {
font-family: Arial, Helvetica, sans-serif;
font-size: x-small;
color: black;
}
.contmenu {
font-family: Arial, Helvetica, sans-serif;
font-size: xx-small;
color: #666633;
}
.contimage {
font-family: Arial, Helvetica, sans-serif;
font-size: xx-small;
color: black;
}
a:link { color: #666633; text-decoration: none}
a:visited { color: #666633; text-decoration: none}
a:hover { color: #CC3333; text-decoration: none}
a:active { color: #666633; text-decoration: none}
when i check out the page, there is no effect on the scroll bar, it displays the normal scroll bar and the style sheet effect.
please assist on what seems to be the problem in here or any thing needed to be change?
thanks so much!
|
|
|
|