473,322 Members | 1,734 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.

Building a link out of a field value

I would like to explore some different ways to build a link out of the
following string from a db,

Fiscal; swvtc/fiscal/fiscaldata.asp: Records; swvtc/records/recordsdata.asp:

Which is just a string that has the link name, then the link target. So I
would need to programmatically build a link from this field. I have found
some other ways around this, but they involve Regular Expressions in
vbscript and I was wondering if there was a more efficient way of doing
this. My database table looks like this,

Username - the username of the user
Userlinks - the links as above, Fiscal; swvtc/fiscal/fiscaldata.asp:
Records; swvtc/records/recordsdata.asp:

I am open to any sort of delimeter instead of the : and ;.

This will be used for an Intranet front page and would allow the users to
have "quick links" on the front page.

Thanks,
Drew Laing
Jul 21 '05 #1
11 1699
huh? Lost me there.
You want http://site/swvtc/fiscal/fiscaldata.asp generated from a db entry?
or you want to pass a value?

basically just a simple Response.Write of an HREF will do what you need,
just put in within the DB lookup/read loop.

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Drew" <dl****@NOswvtc.state.va.SPAMus> wrote in message
news:u1**************@TK2MSFTNGP10.phx.gbl...
I would like to explore some different ways to build a link out of the
following string from a db,

Fiscal; swvtc/fiscal/fiscaldata.asp: Records;
swvtc/records/recordsdata.asp:

Which is just a string that has the link name, then the link target. So I
would need to programmatically build a link from this field. I have found
some other ways around this, but they involve Regular Expressions in
vbscript and I was wondering if there was a more efficient way of doing
this. My database table looks like this,

Username - the username of the user
Userlinks - the links as above, Fiscal; swvtc/fiscal/fiscaldata.asp:
Records; swvtc/records/recordsdata.asp:

I am open to any sort of delimeter instead of the : and ;.

This will be used for an Intranet front page and would allow the users to
have "quick links" on the front page.

Thanks,
Drew Laing

Jul 21 '05 #2
I would recommend not putting several types of information in one field.
Add a Fiscal field and a Records field..then you don't need to parse at all.

If you insist however, look at Instr

Jeff
"Drew" <dl****@NOswvtc.state.va.SPAMus> wrote in message
news:u1**************@TK2MSFTNGP10.phx.gbl...
I would like to explore some different ways to build a link out of the
following string from a db,

Fiscal; swvtc/fiscal/fiscaldata.asp: Records; swvtc/records/recordsdata.asp:
Which is just a string that has the link name, then the link target. So I
would need to programmatically build a link from this field. I have found
some other ways around this, but they involve Regular Expressions in
vbscript and I was wondering if there was a more efficient way of doing
this. My database table looks like this,

Username - the username of the user
Userlinks - the links as above, Fiscal; swvtc/fiscal/fiscaldata.asp:
Records; swvtc/records/recordsdata.asp:

I am open to any sort of delimeter instead of the : and ;.

This will be used for an Intranet front page and would allow the users to
have "quick links" on the front page.

Thanks,
Drew Laing

Jul 21 '05 #3
That is an interesting method of storing data you have there... If this is
how your data is, and assuming you cannot do anything about that, you can
do:

Dim sLinks, aLinks, aLink, sLinkTitle, sHref
Dim i

sLinks = yourRecordset.Fields.Item("Userlinks").Value
aLinks = Split(sLinks, ":")
For i = 0 To UBound(aLinks)
aLink = Split(aLinks(i), ";")
If UBound(aLink) = 1 Then
sLinkTitle = Trim(aLink(0))
sHref = Trim(aLink(1))
Response.Write "<a href=""" & sHref & """>" & sLinkTitle & "</a><br>"
End If
Next
Ray at work

"Drew" <dl****@NOswvtc.state.va.SPAMus> wrote in message
news:u1**************@TK2MSFTNGP10.phx.gbl...
I would like to explore some different ways to build a link out of the
following string from a db,

Fiscal; swvtc/fiscal/fiscaldata.asp: Records;
swvtc/records/recordsdata.asp:

Which is just a string that has the link name, then the link target. So I
would need to programmatically build a link from this field. I have found
some other ways around this, but they involve Regular Expressions in
vbscript and I was wondering if there was a more efficient way of doing
this. My database table looks like this,

Username - the username of the user
Userlinks - the links as above, Fiscal; swvtc/fiscal/fiscaldata.asp:
Records; swvtc/records/recordsdata.asp:

I am open to any sort of delimeter instead of the : and ;.

This will be used for an Intranet front page and would allow the users to
have "quick links" on the front page.

Thanks,
Drew Laing

Jul 21 '05 #4
Well, I want to lump it all in one field, like this,

Fiscal; swvtc/fiscal/fiscaldata.asp: Records; swvtc/records/recordsdata.asp:
Blah; swvtc/blah/blah.asp: Double Blah; swvtc/blahblah/blah.asp

So that I don't have to have seperate fields for all of this... This is an
intranet, so swvtc/records/recordsdata.asp is the actual link. I just need
to make links like so,

<a href="swvtc/records/recordsdata.asp">Records</a>

In otherwords, the name of the link is the first entry followed by a ; and
then the actual link is after that.

Hope I've made myself more clear!

Thanks,
Drew


"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...
huh? Lost me there.
You want http://site/swvtc/fiscal/fiscaldata.asp generated from a db
entry? or you want to pass a value?

basically just a simple Response.Write of an HREF will do what you need,
just put in within the DB lookup/read loop.

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Drew" <dl****@NOswvtc.state.va.SPAMus> wrote in message
news:u1**************@TK2MSFTNGP10.phx.gbl...
I would like to explore some different ways to build a link out of the
following string from a db,

Fiscal; swvtc/fiscal/fiscaldata.asp: Records;
swvtc/records/recordsdata.asp:

Which is just a string that has the link name, then the link target. So
I would need to programmatically build a link from this field. I have
found some other ways around this, but they involve Regular Expressions
in vbscript and I was wondering if there was a more efficient way of
doing this. My database table looks like this,

Username - the username of the user
Userlinks - the links as above, Fiscal; swvtc/fiscal/fiscaldata.asp:
Records; swvtc/records/recordsdata.asp:

I am open to any sort of delimeter instead of the : and ;.

This will be used for an Intranet front page and would allow the users to
have "quick links" on the front page.

Thanks,
Drew Laing


Jul 21 '05 #5
Split() will get it into an array, then jsut loop the array for the items

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Drew" <dl****@NOswvtc.state.va.SPAMus> wrote in message
news:OX**************@TK2MSFTNGP09.phx.gbl...
Well, I want to lump it all in one field, like this,

Fiscal; swvtc/fiscal/fiscaldata.asp: Records;
swvtc/records/recordsdata.asp: Blah; swvtc/blah/blah.asp: Double Blah;
swvtc/blahblah/blah.asp

So that I don't have to have seperate fields for all of this... This is an
intranet, so swvtc/records/recordsdata.asp is the actual link. I just
need to make links like so,

<a href="swvtc/records/recordsdata.asp">Records</a>

In otherwords, the name of the link is the first entry followed by a ; and
then the actual link is after that.

Hope I've made myself more clear!

Thanks,
Drew


"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...
huh? Lost me there.
You want http://site/swvtc/fiscal/fiscaldata.asp generated from a db
entry? or you want to pass a value?

basically just a simple Response.Write of an HREF will do what you need,
just put in within the DB lookup/read loop.

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Drew" <dl****@NOswvtc.state.va.SPAMus> wrote in message
news:u1**************@TK2MSFTNGP10.phx.gbl...
I would like to explore some different ways to build a link out of the
following string from a db,

Fiscal; swvtc/fiscal/fiscaldata.asp: Records;
swvtc/records/recordsdata.asp:

Which is just a string that has the link name, then the link target. So
I would need to programmatically build a link from this field. I have
found some other ways around this, but they involve Regular Expressions
in vbscript and I was wondering if there was a more efficient way of
doing this. My database table looks like this,

Username - the username of the user
Userlinks - the links as above, Fiscal; swvtc/fiscal/fiscaldata.asp:
Records; swvtc/records/recordsdata.asp:

I am open to any sort of delimeter instead of the : and ;.

This will be used for an Intranet front page and would allow the users
to have "quick links" on the front page.

Thanks,
Drew Laing



Jul 21 '05 #6
Well that isn't how the data has to be, I just wanted users to be able to
have as many links as they wanted, and I didn't know of a structure that
could do that.

I guess I could use something like this,

Username
UserLink1
UserLink2
UserLink3
UserLink4
UserLink5
UserLink6
UserLink7
UserLink8
UserLink9
UserLink10

Would that be a better structure?

Thanks,
Drew

"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:Ov**************@TK2MSFTNGP10.phx.gbl...
That is an interesting method of storing data you have there... If this
is how your data is, and assuming you cannot do anything about that, you
can do:

Dim sLinks, aLinks, aLink, sLinkTitle, sHref
Dim i

sLinks = yourRecordset.Fields.Item("Userlinks").Value
aLinks = Split(sLinks, ":")
For i = 0 To UBound(aLinks)
aLink = Split(aLinks(i), ";")
If UBound(aLink) = 1 Then
sLinkTitle = Trim(aLink(0))
sHref = Trim(aLink(1))
Response.Write "<a href=""" & sHref & """>" & sLinkTitle & "</a><br>"
End If
Next
Ray at work

"Drew" <dl****@NOswvtc.state.va.SPAMus> wrote in message
news:u1**************@TK2MSFTNGP10.phx.gbl...
I would like to explore some different ways to build a link out of the
following string from a db,

Fiscal; swvtc/fiscal/fiscaldata.asp: Records;
swvtc/records/recordsdata.asp:

Which is just a string that has the link name, then the link target. So
I would need to programmatically build a link from this field. I have
found some other ways around this, but they involve Regular Expressions
in vbscript and I was wondering if there was a more efficient way of
doing this. My database table looks like this,

Username - the username of the user
Userlinks - the links as above, Fiscal; swvtc/fiscal/fiscaldata.asp:
Records; swvtc/records/recordsdata.asp:

I am open to any sort of delimeter instead of the : and ;.

This will be used for an Intranet front page and would allow the users to
have "quick links" on the front page.

Thanks,
Drew Laing


Jul 21 '05 #7
NO, this would be a terrible design! You waste 10 columns on the user who
doesn't want any links, 9 columns on the user who only wants one, and you
don't have enough for the user who wants 11 (or 111).

CREATE TABLE dbo.Users
(
UserID INT IDENTITY(1,1) PRIMARY KEY,
Username VARCHAR(32) NOT NULL UNIQUE
)

CREATE TABLE dbo.UserLinks
(
UserID INT NOT NULL
FOREIGN KEY REFERENCES dbo.Users(UserID),
Link VARCHAR(32)
)

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Drew" <dl****@NOswvtc.state.va.SPAMus> wrote in message
news:OP**************@TK2MSFTNGP14.phx.gbl...
Well that isn't how the data has to be, I just wanted users to be able to
have as many links as they wanted, and I didn't know of a structure that
could do that.

I guess I could use something like this,

Username
UserLink1
UserLink2
UserLink3
UserLink4
UserLink5
UserLink6
UserLink7
UserLink8
UserLink9
UserLink10

Would that be a better structure?

Thanks,
Drew

"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:Ov**************@TK2MSFTNGP10.phx.gbl...
That is an interesting method of storing data you have there... If this
is how your data is, and assuming you cannot do anything about that, you
can do:

Dim sLinks, aLinks, aLink, sLinkTitle, sHref
Dim i

sLinks = yourRecordset.Fields.Item("Userlinks").Value
aLinks = Split(sLinks, ":")
For i = 0 To UBound(aLinks)
aLink = Split(aLinks(i), ";")
If UBound(aLink) = 1 Then
sLinkTitle = Trim(aLink(0))
sHref = Trim(aLink(1))
Response.Write "<a href=""" & sHref & """>" & sLinkTitle & "</a><br>" End If
Next
Ray at work

"Drew" <dl****@NOswvtc.state.va.SPAMus> wrote in message
news:u1**************@TK2MSFTNGP10.phx.gbl...
I would like to explore some different ways to build a link out of the
following string from a db,

Fiscal; swvtc/fiscal/fiscaldata.asp: Records;
swvtc/records/recordsdata.asp:

Which is just a string that has the link name, then the link target. So I would need to programmatically build a link from this field. I have
found some other ways around this, but they involve Regular Expressions
in vbscript and I was wondering if there was a more efficient way of
doing this. My database table looks like this,

Username - the username of the user
Userlinks - the links as above, Fiscal; swvtc/fiscal/fiscaldata.asp:
Records; swvtc/records/recordsdata.asp:

I am open to any sort of delimeter instead of the : and ;.

This will be used for an Intranet front page and would allow the users to have "quick links" on the front page.

Thanks,
Drew Laing



Jul 21 '05 #8
That's what I thought, but I hadn't thought about your design...

How can I make an insert page that has checkboxes that the users check which
links they want and then it inserts a new record for each item checked? I
don't think that I have ever done this.

Thanks!
Drew

"Aaron [SQL Server MVP]" <te*****@dnartreb.noraa> wrote in message
news:u9**************@TK2MSFTNGP09.phx.gbl...
NO, this would be a terrible design! You waste 10 columns on the user who
doesn't want any links, 9 columns on the user who only wants one, and you
don't have enough for the user who wants 11 (or 111).

CREATE TABLE dbo.Users
(
UserID INT IDENTITY(1,1) PRIMARY KEY,
Username VARCHAR(32) NOT NULL UNIQUE
)

CREATE TABLE dbo.UserLinks
(
UserID INT NOT NULL
FOREIGN KEY REFERENCES dbo.Users(UserID),
Link VARCHAR(32)
)

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Drew" <dl****@NOswvtc.state.va.SPAMus> wrote in message
news:OP**************@TK2MSFTNGP14.phx.gbl...
Well that isn't how the data has to be, I just wanted users to be able to
have as many links as they wanted, and I didn't know of a structure that
could do that.

I guess I could use something like this,

Username
UserLink1
UserLink2
UserLink3
UserLink4
UserLink5
UserLink6
UserLink7
UserLink8
UserLink9
UserLink10

Would that be a better structure?

Thanks,
Drew

"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:Ov**************@TK2MSFTNGP10.phx.gbl...
> That is an interesting method of storing data you have there... If
> this
> is how your data is, and assuming you cannot do anything about that,
> you
> can do:
>
> Dim sLinks, aLinks, aLink, sLinkTitle, sHref
> Dim i
>
> sLinks = yourRecordset.Fields.Item("Userlinks").Value
> aLinks = Split(sLinks, ":")
> For i = 0 To UBound(aLinks)
> aLink = Split(aLinks(i), ";")
> If UBound(aLink) = 1 Then
> sLinkTitle = Trim(aLink(0))
> sHref = Trim(aLink(1))
> Response.Write "<a href=""" & sHref & """>" & sLinkTitle & "</a><br>" > End If
> Next
>
>
> Ray at work
>
>
>
>
>
> "Drew" <dl****@NOswvtc.state.va.SPAMus> wrote in message
> news:u1**************@TK2MSFTNGP10.phx.gbl...
>>I would like to explore some different ways to build a link out of the
>>following string from a db,
>>
>> Fiscal; swvtc/fiscal/fiscaldata.asp: Records;
>> swvtc/records/recordsdata.asp:
>>
>> Which is just a string that has the link name, then the link target. So >> I would need to programmatically build a link from this field. I have
>> found some other ways around this, but they involve Regular
>> Expressions
>> in vbscript and I was wondering if there was a more efficient way of
>> doing this. My database table looks like this,
>>
>> Username - the username of the user
>> Userlinks - the links as above, Fiscal; swvtc/fiscal/fiscaldata.asp:
>> Records; swvtc/records/recordsdata.asp:
>>
>> I am open to any sort of delimeter instead of the : and ;.
>>
>> This will be used for an Intranet front page and would allow the users to >> have "quick links" on the front page.
>>
>> Thanks,
>> Drew Laing
>>
>
>



Jul 21 '05 #9
You create an HTML form <form> and have the form submit data to an ASP page
that processes the data and updates your database. That's the generic
explanation anyway.

I suggest starting a new thread if you would like to discuss this further,
as the topic has now changed.

Ray at work

"Drew" <dr********@NOswvtc.dmhmrsas.virginia.SPMgov> wrote in message
news:u0**************@TK2MSFTNGP14.phx.gbl...

How can I make an insert page that has checkboxes that the users check
which links they want and then it inserts a new record for each item
checked? I don't think that I have ever done this.


Jul 21 '05 #10
Or see some ASP-db tutorials, which will probably answer 90% of the
question(s)...


"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:ue**************@TK2MSFTNGP15.phx.gbl...
You create an HTML form <form> and have the form submit data to an ASP page that processes the data and updates your database. That's the generic
explanation anyway.

I suggest starting a new thread if you would like to discuss this further,
as the topic has now changed.

Ray at work

"Drew" <dr********@NOswvtc.dmhmrsas.virginia.SPMgov> wrote in message
news:u0**************@TK2MSFTNGP14.phx.gbl...

How can I make an insert page that has checkboxes that the users check
which links they want and then it inserts a new record for each item
checked? I don't think that I have ever done this.

Jul 21 '05 #11
I didn't mean to sound like a newbie, I meant that I had never looped
anything, I have done regular inserts for 1 record at a time, but not for
multiple records. I will research, see what I find and if I have any
questions, I will ask!

thanks,
Drew
"Aaron [SQL Server MVP]" <te*****@dnartreb.noraa> wrote in message
news:ui**************@tk2msftngp13.phx.gbl...
Or see some ASP-db tutorials, which will probably answer 90% of the
question(s)...


"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:ue**************@TK2MSFTNGP15.phx.gbl...
You create an HTML form <form> and have the form submit data to an ASP

page
that processes the data and updates your database. That's the generic
explanation anyway.

I suggest starting a new thread if you would like to discuss this
further,
as the topic has now changed.

Ray at work

"Drew" <dr********@NOswvtc.dmhmrsas.virginia.SPMgov> wrote in message
news:u0**************@TK2MSFTNGP14.phx.gbl...

> How can I make an insert page that has checkboxes that the users check
> which links they want and then it inserts a new record for each item
> checked? I don't think that I have ever done this.
>


Jul 21 '05 #12

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

Similar topics

2
by: Acorn Tutors | last post by:
Hi folks, what I would like to do is to store the name of a link, such as link1.php in a field, lets say the field is called Favoritelinks, in a database as a bit of text. Then, on a logged in...
2
by: Bennett Haselton | last post by:
I'm looking for a PHP tutorial that specializes in how to build sites that are based around user logins. i.e. the user logs in on the front page, and are taken to a main login page where fields on...
4
by: Dodo | last post by:
Is it possible to create a link that can post a value to an ASP page without java?
4
by: Melissa | last post by:
I have a frontend file named CustomerApp and backend file named CustomerData. CustomerApp is at C:\Customer Database and CustomerData is at S:\Customer Database. Could someone help me with the code...
13
by: royaltiger | last post by:
I am trying to copy the inventory database in Building Access Applications by John L Viescas but when i try to run the database i get an error in the orders form when i click on the allocate...
5
by: james.calhoun | last post by:
I feel like this should be really easy... I want a hidden field in a form to have its value defined when someone clicks on a link. So if they click on link "A" the value of the hidden field...
2
by: Troll | last post by:
Windows XP Pro VS 2005 & C# (I'm fairly new to C# but have doing VB.Net going on 2yrs and VB6 for 5yrs.) I'm using C# to build a custom RSS generator. I'm having trouble building the guid...
3
by: Sandman | last post by:
So, I've used ajax for quite some time for different stuff. Mostly I just feed a funktion I made with the ID of the DIV that should be updated with the output from page XXX.php Now I want to...
17
by: john | last post by:
All: I'm a long-time developer, new to PHP.... Is there an idiom used in PHP to construct SQL statments from $_POST data? I would guess that in many applications, the data read from $_POST...
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
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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: 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: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
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...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.