473,322 Members | 1,496 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

How to insert URL in ASP.Net e-mail message

Hello,

I created an e-mail form pretty much as described in this article:
http://www.4guysfromrolla.com/webtech/080801-1.shtml. It works great, but I
cannot figure out one thing:

I need to insert a URL at the bottom of the message body. How would I do
this? If I insert just HTML - it displays HTML. I tried Response.Write
method, StringBuilder and HTMLTextWriter classes - no luck so far.

I would appreciate your advice on this.

Thank you,

--
Peter Afonin
Nov 18 '05 #1
9 1646
Not sure if this is what you're looking for, but this is how I build and send an e-mail message to
myself. Maybe it will give you some ideas.

Private Sub sendMail(ByVal msgTxt As String)
Dim msg As MailMessage = New MailMessage()
SmtpMail.SmtpServer = "xxxx.xxxx.com"
msg.Body = msgTxt
msg.From = "xx**@xxxxx.com"
msg.To = "xx**@xxxx.net"
msg.Subject = "Some Subject!"

Try
SmtpMail.Send(msg)
Catch
End Try
End Sub

Private Sub SomeOtherSub()
Dim userAgent As String
Dim referringPage As String

If Not Request.UserAgent Is Nothing Then
userAgent = Request.UserAgent
Else
userAgent = "No user agent available!"
End If

'This is how I get a URL to string
If Not Request.UrlReferrer Is Nothing Then
referringPage = Request.UrlReferrer.ToString()
Else
referringPage = "Direct access by bookmark, local-based e-mail link, etc."
End If

Dim msgTxt As String = vbCrLf & _
"Browser Name: " & Request.Browser.Browser & vbCrLf & _
"Browser Type: " & Request.Browser.Type & vbCrLf & _
"Browser Version: " & Request.Browser.Version & vbCrLf & _
"Browser Platform: " & Request.Browser.Platform & vbCrLf & _
"Accepts Cookies: " & Request.Browser.Cookies & vbCrLf & _
"User Agent: " & userAgent & vbCrLf & _
"User Host Address: " & Request.UserHostAddress.ToString & vbCrLf & _
"User Host Name: " & Request.UserHostName & vbCrLf & _
"Referring URL: " & referringPage

If Not Request.Cookies("userInfo") Is Nothing Then
msgTxt = msgTxt & vbCrLf & vbCrLf & _
"This Visit: " & Request.Cookies("userInfo")("thisVisit") & vbCrLf & _
"Last Visit: " & Request.Cookies("userInfo")("lastVisit") & vbCrLf & _
"Total Visits: " & Request.Cookies("userInfo")("numVisits") & vbCrLf
End If

sendMail(msgTxt)
End Sub

I use the Try\Catch\End Try just in case the mail server is down. If it is, I just pass on getting
that particular message because I can live without it. So I don't really need to trap that error, I
just don't want my app to crash. User agent and URL Referrer will crash my app, too, so that is why
I'm checking them first. Maybe some of the others will, too, but not sure.

Hope that helped a little. I'm just learning this stuff, so there is probably a better way to do it.
I've gotten a lot of answers in this NG, so thought I'd try to give back a little. ;-)

George

"Peter Afonin" <pv*@speakeasy.net> wrote in message news:eV**************@TK2MSFTNGP10.phx.gbl...
Hello,

I created an e-mail form pretty much as described in this article:
http://www.4guysfromrolla.com/webtech/080801-1.shtml. It works great, but I
cannot figure out one thing:

I need to insert a URL at the bottom of the message body. How would I do
this? If I insert just HTML - it displays HTML. I tried Response.Write
method, StringBuilder and HTMLTextWriter classes - no luck so far.

I would appreciate your advice on this.

Thank you,

--
Peter Afonin


Nov 18 '05 #2
Thank you, George.

I need a little different, I guess. I just want to display my company name
at the bottom of the e-mail body as a hyperlink, just like here:
www.mycompanyname.com , so the person could click on it and get to my site.
It should be a simple task, I've just never done this before.

Peter
"George" <------@----.---> wrote in message
news:zB*******************@bgtnsc05-news.ops.worldnet.att.net...
Not sure if this is what you're looking for, but this is how I build and send an e-mail message to myself. Maybe it will give you some ideas.

Private Sub sendMail(ByVal msgTxt As String)
Dim msg As MailMessage = New MailMessage()
SmtpMail.SmtpServer = "xxxx.xxxx.com"
msg.Body = msgTxt
msg.From = "xx**@xxxxx.com"
msg.To = "xx**@xxxx.net"
msg.Subject = "Some Subject!"

Try
SmtpMail.Send(msg)
Catch
End Try
End Sub

Private Sub SomeOtherSub()
Dim userAgent As String
Dim referringPage As String

If Not Request.UserAgent Is Nothing Then
userAgent = Request.UserAgent
Else
userAgent = "No user agent available!"
End If

'This is how I get a URL to string
If Not Request.UrlReferrer Is Nothing Then
referringPage = Request.UrlReferrer.ToString()
Else
referringPage = "Direct access by bookmark, local-based e-mail link, etc." End If

Dim msgTxt As String = vbCrLf & _
"Browser Name: " & Request.Browser.Browser & vbCrLf & _
"Browser Type: " & Request.Browser.Type & vbCrLf & _
"Browser Version: " & Request.Browser.Version & vbCrLf & _
"Browser Platform: " & Request.Browser.Platform & vbCrLf & _
"Accepts Cookies: " & Request.Browser.Cookies & vbCrLf & _
"User Agent: " & userAgent & vbCrLf & _
"User Host Address: " & Request.UserHostAddress.ToString & vbCrLf & _ "User Host Name: " & Request.UserHostName & vbCrLf & _
"Referring URL: " & referringPage

If Not Request.Cookies("userInfo") Is Nothing Then
msgTxt = msgTxt & vbCrLf & vbCrLf & _
"This Visit: " & Request.Cookies("userInfo")("thisVisit") & vbCrLf & _ "Last Visit: " & Request.Cookies("userInfo")("lastVisit") & vbCrLf & _ "Total Visits: " & Request.Cookies("userInfo")("numVisits") & vbCrLf End If

sendMail(msgTxt)
End Sub

I use the Try\Catch\End Try just in case the mail server is down. If it is, I just pass on getting that particular message because I can live without it. So I don't really need to trap that error, I just don't want my app to crash. User agent and URL Referrer will crash my app, too, so that is why I'm checking them first. Maybe some of the others will, too, but not sure.

Hope that helped a little. I'm just learning this stuff, so there is probably a better way to do it. I've gotten a lot of answers in this NG, so thought I'd try to give back a little. ;-)
George

"Peter Afonin" <pv*@speakeasy.net> wrote in message

news:eV**************@TK2MSFTNGP10.phx.gbl...
Hello,

I created an e-mail form pretty much as described in this article:
http://www.4guysfromrolla.com/webtech/080801-1.shtml. It works great, but I cannot figure out one thing:

I need to insert a URL at the bottom of the message body. How would I do
this? If I insert just HTML - it displays HTML. I tried Response.Write
method, StringBuilder and HTMLTextWriter classes - no luck so far.

I would appreciate your advice on this.

Thank you,

--
Peter Afonin


Nov 18 '05 #3
I think if you put it in a string, like I did the referring URL, it will come out as a hyperlink.
When I get the referring URL in my mail message, it is a click-able hyperlink.

Dim companyURL as string = "http://www.mycompanyname.com"

msg.Body = msgTxt & vbCrLf & companyURL

Should work (I think). ;-)

George

"Peter Afonin" <pv*@speakeasy.net> wrote in message news:Ow**************@TK2MSFTNGP10.phx.gbl...
Thank you, George.

I need a little different, I guess. I just want to display my company name
at the bottom of the e-mail body as a hyperlink, just like here:
www.mycompanyname.com , so the person could click on it and get to my site.
It should be a simple task, I've just never done this before.

Peter
"George" <------@----.---> wrote in message
news:zB*******************@bgtnsc05-news.ops.worldnet.att.net...
Not sure if this is what you're looking for, but this is how I build and

send an e-mail message to
myself. Maybe it will give you some ideas.

Private Sub sendMail(ByVal msgTxt As String)
Dim msg As MailMessage = New MailMessage()
SmtpMail.SmtpServer = "xxxx.xxxx.com"
msg.Body = msgTxt
msg.From = "xx**@xxxxx.com"
msg.To = "xx**@xxxx.net"
msg.Subject = "Some Subject!"

Try
SmtpMail.Send(msg)
Catch
End Try
End Sub

Private Sub SomeOtherSub()
Dim userAgent As String
Dim referringPage As String

If Not Request.UserAgent Is Nothing Then
userAgent = Request.UserAgent
Else
userAgent = "No user agent available!"
End If

'This is how I get a URL to string
If Not Request.UrlReferrer Is Nothing Then
referringPage = Request.UrlReferrer.ToString()
Else
referringPage = "Direct access by bookmark, local-based e-mail

link, etc."
End If

Dim msgTxt As String = vbCrLf & _
"Browser Name: " & Request.Browser.Browser & vbCrLf & _
"Browser Type: " & Request.Browser.Type & vbCrLf & _
"Browser Version: " & Request.Browser.Version & vbCrLf & _
"Browser Platform: " & Request.Browser.Platform & vbCrLf & _
"Accepts Cookies: " & Request.Browser.Cookies & vbCrLf & _
"User Agent: " & userAgent & vbCrLf & _
"User Host Address: " & Request.UserHostAddress.ToString & vbCrLf &

_
"User Host Name: " & Request.UserHostName & vbCrLf & _
"Referring URL: " & referringPage

If Not Request.Cookies("userInfo") Is Nothing Then
msgTxt = msgTxt & vbCrLf & vbCrLf & _
"This Visit: " & Request.Cookies("userInfo")("thisVisit")

& vbCrLf & _
"Last Visit: " &

Request.Cookies("userInfo")("lastVisit") & vbCrLf & _
"Total Visits: " &

Request.Cookies("userInfo")("numVisits") & vbCrLf
End If

sendMail(msgTxt)
End Sub

I use the Try\Catch\End Try just in case the mail server is down. If it

is, I just pass on getting
that particular message because I can live without it. So I don't really

need to trap that error, I
just don't want my app to crash. User agent and URL Referrer will crash my

app, too, so that is why
I'm checking them first. Maybe some of the others will, too, but not sure.

Hope that helped a little. I'm just learning this stuff, so there is

probably a better way to do it.
I've gotten a lot of answers in this NG, so thought I'd try to give back a

little. ;-)

George

"Peter Afonin" <pv*@speakeasy.net> wrote in message

news:eV**************@TK2MSFTNGP10.phx.gbl...
Hello,

I created an e-mail form pretty much as described in this article:
http://www.4guysfromrolla.com/webtech/080801-1.shtml. It works great, but I cannot figure out one thing:

I need to insert a URL at the bottom of the message body. How would I do
this? If I insert just HTML - it displays HTML. I tried Response.Write
method, StringBuilder and HTMLTextWriter classes - no luck so far.

I would appreciate your advice on this.

Thank you,

--
Peter Afonin




Nov 18 '05 #4
Thank you, George, I think you're correct, I'll test it. But what if I want
to display it like "My Company" and have a URL behind it? It must be a way
of doing it.

Peter

"George" <------@----.---> wrote in message
news:2n*******************@bgtnsc05-news.ops.worldnet.att.net...
I think if you put it in a string, like I did the referring URL, it will come out as a hyperlink. When I get the referring URL in my mail message, it is a click-able hyperlink.
Dim companyURL as string = "http://www.mycompanyname.com"

msg.Body = msgTxt & vbCrLf & companyURL

Should work (I think). ;-)

George

"Peter Afonin" <pv*@speakeasy.net> wrote in message

news:Ow**************@TK2MSFTNGP10.phx.gbl...
Thank you, George.

I need a little different, I guess. I just want to display my company name at the bottom of the e-mail body as a hyperlink, just like here:
www.mycompanyname.com , so the person could click on it and get to my site. It should be a simple task, I've just never done this before.

Peter
"George" <------@----.---> wrote in message
news:zB*******************@bgtnsc05-news.ops.worldnet.att.net...
Not sure if this is what you're looking for, but this is how I build and
send an e-mail message to
myself. Maybe it will give you some ideas.

Private Sub sendMail(ByVal msgTxt As String)
Dim msg As MailMessage = New MailMessage()
SmtpMail.SmtpServer = "xxxx.xxxx.com"
msg.Body = msgTxt
msg.From = "xx**@xxxxx.com"
msg.To = "xx**@xxxx.net"
msg.Subject = "Some Subject!"

Try
SmtpMail.Send(msg)
Catch
End Try
End Sub

Private Sub SomeOtherSub()
Dim userAgent As String
Dim referringPage As String

If Not Request.UserAgent Is Nothing Then
userAgent = Request.UserAgent
Else
userAgent = "No user agent available!"
End If

'This is how I get a URL to string
If Not Request.UrlReferrer Is Nothing Then
referringPage = Request.UrlReferrer.ToString()
Else
referringPage = "Direct access by bookmark, local-based
e-mail link, etc."
End If

Dim msgTxt As String = vbCrLf & _
"Browser Name: " & Request.Browser.Browser & vbCrLf & _
"Browser Type: " & Request.Browser.Type & vbCrLf & _
"Browser Version: " & Request.Browser.Version & vbCrLf & _
"Browser Platform: " & Request.Browser.Platform & vbCrLf & _
"Accepts Cookies: " & Request.Browser.Cookies & vbCrLf & _
"User Agent: " & userAgent & vbCrLf & _
"User Host Address: " & Request.UserHostAddress.ToString &
vbCrLf & _
"User Host Name: " & Request.UserHostName & vbCrLf & _
"Referring URL: " & referringPage

If Not Request.Cookies("userInfo") Is Nothing Then
msgTxt = msgTxt & vbCrLf & vbCrLf & _
"This Visit: " &
Request.Cookies("userInfo")("thisVisit") & vbCrLf & _
"Last Visit: " &

Request.Cookies("userInfo")("lastVisit") & vbCrLf & _
"Total Visits: " &

Request.Cookies("userInfo")("numVisits") & vbCrLf
End If

sendMail(msgTxt)
End Sub

I use the Try\Catch\End Try just in case the mail server is down. If
it is, I just pass on getting
that particular message because I can live without it. So I don't
really need to trap that error, I
just don't want my app to crash. User agent and URL Referrer will
crash my app, too, so that is why
I'm checking them first. Maybe some of the others will, too, but not
sure.
Hope that helped a little. I'm just learning this stuff, so there is

probably a better way to do it.
I've gotten a lot of answers in this NG, so thought I'd try to give back a little. ;-)

George

"Peter Afonin" <pv*@speakeasy.net> wrote in message

news:eV**************@TK2MSFTNGP10.phx.gbl...
> Hello,
>
> I created an e-mail form pretty much as described in this article:
> http://www.4guysfromrolla.com/webtech/080801-1.shtml. It works
great, but I
> cannot figure out one thing:
>
> I need to insert a URL at the bottom of the message body. How would

I do > this? If I insert just HTML - it displays HTML. I tried Response.Write > method, StringBuilder and HTMLTextWriter classes - no luck so far.
>
> I would appreciate your advice on this.
>
> Thank you,
>
> --
> Peter Afonin
>
>



Nov 18 '05 #5
Sorry, can't help you with that one. I get the same results that you do -- it just drops the HTML
code into the message as though it were text.

George

"Peter Afonin" <pa**@specialtypulltabs.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
Thank you, George, I think you're correct, I'll test it. But what if I want
to display it like "My Company" and have a URL behind it? It must be a way
of doing it.

Peter

"George" <------@----.---> wrote in message
news:2n*******************@bgtnsc05-news.ops.worldnet.att.net...
I think if you put it in a string, like I did the referring URL, it will

come out as a hyperlink.
When I get the referring URL in my mail message, it is a click-able

hyperlink.

Dim companyURL as string = "http://www.mycompanyname.com"

msg.Body = msgTxt & vbCrLf & companyURL

Should work (I think). ;-)

George

"Peter Afonin" <pv*@speakeasy.net> wrote in message

news:Ow**************@TK2MSFTNGP10.phx.gbl...
Thank you, George.

I need a little different, I guess. I just want to display my company name at the bottom of the e-mail body as a hyperlink, just like here:
www.mycompanyname.com , so the person could click on it and get to my site. It should be a simple task, I've just never done this before.

Peter
"George" <------@----.---> wrote in message
news:zB*******************@bgtnsc05-news.ops.worldnet.att.net...
> Not sure if this is what you're looking for, but this is how I build and send an e-mail message to
> myself. Maybe it will give you some ideas.
>
> Private Sub sendMail(ByVal msgTxt As String)
> Dim msg As MailMessage = New MailMessage()
> SmtpMail.SmtpServer = "xxxx.xxxx.com"
> msg.Body = msgTxt
> msg.From = "xx**@xxxxx.com"
> msg.To = "xx**@xxxx.net"
> msg.Subject = "Some Subject!"
>
> Try
> SmtpMail.Send(msg)
> Catch
> End Try
> End Sub
>
> Private Sub SomeOtherSub()
> Dim userAgent As String
> Dim referringPage As String
>
> If Not Request.UserAgent Is Nothing Then
> userAgent = Request.UserAgent
> Else
> userAgent = "No user agent available!"
> End If
>
> 'This is how I get a URL to string
> If Not Request.UrlReferrer Is Nothing Then
> referringPage = Request.UrlReferrer.ToString()
> Else
> referringPage = "Direct access by bookmark, local-based e-mail link, etc."
> End If
>
> Dim msgTxt As String = vbCrLf & _
> "Browser Name: " & Request.Browser.Browser & vbCrLf & _
> "Browser Type: " & Request.Browser.Type & vbCrLf & _
> "Browser Version: " & Request.Browser.Version & vbCrLf & _
> "Browser Platform: " & Request.Browser.Platform & vbCrLf & _
> "Accepts Cookies: " & Request.Browser.Cookies & vbCrLf & _
> "User Agent: " & userAgent & vbCrLf & _
> "User Host Address: " & Request.UserHostAddress.ToString & vbCrLf & _
> "User Host Name: " & Request.UserHostName & vbCrLf & _
> "Referring URL: " & referringPage
>
> If Not Request.Cookies("userInfo") Is Nothing Then
> msgTxt = msgTxt & vbCrLf & vbCrLf & _
> "This Visit: " & Request.Cookies("userInfo")("thisVisit") & vbCrLf & _
> "Last Visit: " &
Request.Cookies("userInfo")("lastVisit") & vbCrLf & _
> "Total Visits: " &
Request.Cookies("userInfo")("numVisits") & vbCrLf
> End If
>
> sendMail(msgTxt)
> End Sub
>
> I use the Try\Catch\End Try just in case the mail server is down. If it is, I just pass on getting
> that particular message because I can live without it. So I don't really need to trap that error, I
> just don't want my app to crash. User agent and URL Referrer will crash my app, too, so that is why
> I'm checking them first. Maybe some of the others will, too, but not sure. >
> Hope that helped a little. I'm just learning this stuff, so there is
probably a better way to do it.
> I've gotten a lot of answers in this NG, so thought I'd try to give back a little. ;-)
>
> George
>
>
>
> "Peter Afonin" <pv*@speakeasy.net> wrote in message
news:eV**************@TK2MSFTNGP10.phx.gbl...
> > Hello,
> >
> > I created an e-mail form pretty much as described in this article:
> > http://www.4guysfromrolla.com/webtech/080801-1.shtml. It works great, but I
> > cannot figure out one thing:
> >
> > I need to insert a URL at the bottom of the message body. How would I do > > this? If I insert just HTML - it displays HTML. I tried Response.Write > > method, StringBuilder and HTMLTextWriter classes - no luck so far.
> >
> > I would appreciate your advice on this.
> >
> > Thank you,
> >
> > --
> > Peter Afonin
> >
> >
>
>
>



Nov 18 '05 #6
"George" <------@----.---> wrote in
news:Mm*******************@bgtnsc05-news.ops.worldnet.att.net:
Sorry, can't help you with that one. I get the same results that you do
-- it just drops the HTML code into the message as though it were text.


To do it properly so it will be displayed in all clients, as well as not be
filtered by spam filters you have to make an alternative type message. .Net
mail class does NOT support this.

You can use Indy, it supports this and its free.

http://www.indyproject.org/
--
Chad Z. Hower (a.k.a. Kudzu) - http://www.hower.org/Kudzu/
"Programming is an art form that fights back"
ELKNews - Get your free copy at http://www.atozedsoftware.com

Nov 18 '05 #7
Thanks for the information that there are Indy components we can use in .Net
now. I used Indy with Delphi 6 and found it quite useful.

I went to the Indy site downloaded the DLL, added it to a test VB.Net
project and created me a Whois lookup application. All very easy, and it
works fine.

I then added it to my .Net tests at my main web site. Unfortunately as soon
as I tried to access the aspx page I get the following error:
System.Security.SecurityException: Security error. Apparently the hosting
company doesn't trust your DLL. I will discuss it with them, but I am
pretty sure it will be a no go.

Their security is such that they will not let ASP.Net create sockets, so I
had hoped to use Indy to get around this. At the same site I have an ISAPI
DLL created with Delphi 6 and Indy that does a Whois lookup with no problem.

"Chad Z. Hower aka Kudzu" <cp**@hower.org> wrote in message
news:Xn******************@127.0.0.1...
"George" <------@----.---> wrote in
news:Mm*******************@bgtnsc05-news.ops.worldnet.att.net:
Sorry, can't help you with that one. I get the same results that you do
-- it just drops the HTML code into the message as though it were text.
To do it properly so it will be displayed in all clients, as well as not

be filtered by spam filters you have to make an alternative type message. ..Net mail class does NOT support this.

You can use Indy, it supports this and its free.

http://www.indyproject.org/
--
Chad Z. Hower (a.k.a. Kudzu) - http://www.hower.org/Kudzu/
"Programming is an art form that fights back"
ELKNews - Get your free copy at http://www.atozedsoftware.com

Nov 18 '05 #8
"William LaMartin" <la******@tampabay.rr.com> wrote in
news:eH*************@TK2MSFTNGP11.phx.gbl:
I went to the Indy site downloaded the DLL, added it to a test VB.Net
project and created me a Whois lookup application. All very easy, and it
works fine.
Great!
I then added it to my .Net tests at my main web site. Unfortunately as
soon as I tried to access the aspx page I get the following error:
System.Security.SecurityException: Security error. Apparently the
hosting company doesn't trust your DLL. I will discuss it with them,
but I am pretty sure it will be a no go.
So they trust anything you put up in your assembly, but not anything in
external assemblies?
Their security is such that they will not let ASP.Net create sockets, so
I had hoped to use Indy to get around this. At the same site I have an


Ouch - if they wont let ASP.net create sockets, then its doubtful Indy will
work either. It uses the .net sockets internally as well.
--
Chad Z. Hower (a.k.a. Kudzu) - http://www.hower.org/Kudzu/
"Programming is an art form that fights back"
ELKNews - Get your free copy at http://www.atozedsoftware.com

Nov 18 '05 #9
I have another site where I can test .Net things. There I have a lot more
permissions than I do at my own domain hosted in a shared hosting
environment. If you go to http://216.182.10.243/container/WhoisIndy.aspx ,
you will see the Whois using Indy example working properly.

Well, I guess there is not much use in asking the hosting company if they
will allow the Indy DLL if it uses the .Net sockets, since even if they did,
I still wouldn't be able to use anything from Indy that involved
sockets--which doesn't leave much, I suppose.

"Chad Z. Hower aka Kudzu" <cp**@hower.org> wrote in message
news:Xn******************@127.0.0.1...
"William LaMartin" <la******@tampabay.rr.com> wrote in
news:eH*************@TK2MSFTNGP11.phx.gbl:
I went to the Indy site downloaded the DLL, added it to a test VB.Net
project and created me a Whois lookup application. All very easy, and it
works fine.
Great!
I then added it to my .Net tests at my main web site. Unfortunately as
soon as I tried to access the aspx page I get the following error:
System.Security.SecurityException: Security error. Apparently the
hosting company doesn't trust your DLL. I will discuss it with them,
but I am pretty sure it will be a no go.


So they trust anything you put up in your assembly, but not anything in
external assemblies?
Their security is such that they will not let ASP.Net create sockets, so
I had hoped to use Indy to get around this. At the same site I have an


Ouch - if they wont let ASP.net create sockets, then its doubtful Indy

will work either. It uses the .net sockets internally as well.
--
Chad Z. Hower (a.k.a. Kudzu) - http://www.hower.org/Kudzu/
"Programming is an art form that fights back"
ELKNews - Get your free copy at http://www.atozedsoftware.com

Nov 18 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Howard Hinnant | last post by:
I recently asked for a survey of multimap insert with hint behavior, in support of a paper I'm writing concerning lwg issue 233. My sincere thanks to Beman Dawes, Raoul Gough, Russell Hind, Bronek...
6
by: Mark P | last post by:
Some time ago I posted here about inserting into a set with a hint: ...
14
by: serge | last post by:
I have a scenario where two tables are in a One-to-Many relationship and I need to move the data from the Many table to the One table so that it becomes a One-to-One relationship. I need to...
2
by: Ford Desperado | last post by:
I've been reading the docs and playing around, but I'm still not getting the difference. For instance, create table a(i int check(i>0)) create table a_src(i int) go create unique index ai on...
0
by: jtocci | last post by:
I'm having a big problem with CREATE RULE...ON INSERT...INSERT INTO...SELECT...FROM...WHERE when I want to INSERT several (20~50) records based on a single INSERT to a view. Either I get a 'too...
4
by: Chris Kratz | last post by:
Hello all, We have run into what appears to be a problem with rules and subselects in postgres 7.4.1. We have boiled it down to the following test case. If anyone has any thoughts as to why...
2
by: Geoffrey KRETZ | last post by:
Hello, I'm wondering if the following behaviour is the correct one for PostGreSQL (7.4 on UNIX). I've a table temp_tab with 5 fields (f1,f2,f3,...),and I'm a launching the following request :...
1
by: filip1150 | last post by:
I'm trying to find if there is any performance diference between explicitly using a sequence in the insert statement to generate values for a column and doing this in an insert trigger. I...
6
by: lenygold via DBMonster.com | last post by:
Hi everybody: What is the best way to I have 10 tables with similar INSERT requiremnts. INSERT INTO ACSB.VAATAFAE WITH AA(AA_TIN, AA_FILE_SOURCE_CD, .AA_TIN_TYP) AS ( SELECT AA_TIN,...
1
by: EJO | last post by:
with sql 2000 enterprise Trying to build a stored procedure that will take the rows of a parent table, insert them into another table as well as the rows from a child table to insert into...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.