hi!!
This is my problem. Im planing this without success
*i have 3 tables table1 table2 and table3...
*The tables have some fields with the same name for example
both table 2 and table 3 have the field "age"
*The field id is a key
select * from a table1, b table2, c table3 where a.id=session("m emberId")
and b.id= session("member Id") and c.id=session("m emberId")
MY QUESTION ARE
How do i get data from tables that have the same field name like the example
table 2 and table 3???
My guess are something like this:
response.write recordsset(b.ag e) and for the other
response.write recordset(c.age )..
This is wrong syntax i know, but how do i write the syntax in asp?
2  1473 
Mikael Hellström wrote:
Already answered in .asp.db.
Mikael,
The .asp.db newsgroup was the appropriate newsgroup for this question: it
was database-related, and it was asp-related - a great fit for .asp.db. You
did not have to post it here as well. Most of the experts in this group also
subscribe to that group as well, and it can be annoying to have to read the
same question multiple times. In addition, by posting the same question
separately in these newsgroups, you created a "multipost" . This is bad
because users in one group cannot see replies to the question from the other
group. This could cause somebody to waste his time answering a question that
has already been answered in the other group, which will certainly be
annoying, and may cause the person who wasted his time to put you on Ignore.
Who knows, this person may be the only person in the newsgroups who knows
the answer to your next question, and you're never going to receive his
answer.
The best policy is, post your question to one appropriate newsgroup. If
you've posted it in the wrong place, someone will let you know, and
hopefully will be polite enough to suggest a more appropriate newsgroup. If
you can't decide which of several newsgroups is the most appropriate, use
the cross-posting technique: put the names of the newsgroups into the To
field of a single message and post it once. It will be posted to all the
groups in your To field. The benefit is that replies to the message will
appear in all the newsgroups to which you cross-posted it, so subscripers to
all the groups will know that your problem has been resolved. The downside
is that extra bandwidth will be used as a result, so always strive to keep
the number of cross-posted groups to a minimum.
HTH,
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
ok sorry ...I'll think about that.
"Bob Barrows" <re******@NOyah oo.SPAMcom> wrote in message
news:ek******** ******@TK2MSFTN GP10.phx.gbl... Mikael Hellström wrote:
Already answered in .asp.db.
Mikael,
The .asp.db newsgroup was the appropriate newsgroup for this question: it
was database-related, and it was asp-related - a great fit for .asp.db.
You did not have to post it here as well. Most of the experts in this group
also subscribe to that group as well, and it can be annoying to have to read
the same question multiple times. In addition, by posting the same question
separately in these newsgroups, you created a "multipost" . This is bad
because users in one group cannot see replies to the question from the
other group. This could cause somebody to waste his time answering a question
that has already been answered in the other group, which will certainly be
annoying, and may cause the person who wasted his time to put you on
Ignore. Who knows, this person may be the only person in the newsgroups who knows
the answer to your next question, and you're never going to receive his
answer.
The best policy is, post your question to one appropriate newsgroup. If
you've posted it in the wrong place, someone will let you know, and
hopefully will be polite enough to suggest a more appropriate newsgroup.
If you can't decide which of several newsgroups is the most appropriate, use
the cross-posting technique: put the names of the newsgroups into the To
field of a single message and post it once. It will be posted to all the
groups in your To field. The benefit is that replies to the message will
appear in all the newsgroups to which you cross-posted it, so subscripers
to all the groups will know that your problem has been resolved. The downside
is that extra bandwidth will be used as a result, so always strive to keep
the number of cross-posted groups to a minimum.
HTH,
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Penn Markham |
last post by:
Hello all,
I am writing a script where I need to use the system() function to call
htpasswd. I can do this just fine on the command line...works great
(see attached file, test.php). When my webserver runs that part of the
script (see attached file, snippet.php), though, it doesn't go through.
I don't get an error message or anything...it just returns a "1"
(whereas it should return a "0") as far as I can tell. I have read the
PHP...
|
by: bolidev |
last post by:
I'm new to SQL and can't figure out how to update my table
(StoreItemStatus) that contains the current status for items in each
store (STORE_KEY, ITEM_KEY, STATUS,...).
I get updated status info in a table (I'll call it NewInfo) that
has similar fields. NewInfo may contain multiple records for each
Store/Item, but I will just use the latest status. I'm not sure how
to update StoreItemStatus using each record of NewInfo. Any advice is...
|
by: moondaddy |
last post by:
I'm running vb.net 1.1 and I need to register a dll using regsvcs.exe and am
getting the error:
Command "RegSvcs.exe" is not valid.
the path to the dll I want to register is:
D:\nwis\Apps\CSLA
1.0\csla\CSLA.Server.ServicedDataPortal\bin\CSLA.Server.ServicedDataPortal.d
ll
and I've tried lots of different syntax for using regsvcs in both the
|
by: Steven Spear |
last post by:
Hi. I am trying to perform backtracking with this search function.
Something is going wrong when I enter 2 at the command line. Entering
1 at the command line seems to work fine. I notice that backtracking
never takes place. Obviously there is something wrong with my logic. I
have been trying many things for many days to correct the situation,
but nothing seems to help. Does anyone have any suggestions? Thanks,
Steve
#include...
|
by: Exits Funnel |
last post by:
Consider this code which is a very trimmed down version of some I've
inherited and am trying to port from windows to g++:
//Begin test1.cpp
class foo { int i; int j; };
class bar
{
bar (int foo::* dataMember)
:offsetof (foo, *dataMember) //Call this Line (A)
| | |
by: Gregory L. Hansen |
last post by:
I can't seem to make a queue of objects, using the STL queue. I'm trying
to make a little event manager, and I just want someplace to store events.
The method definitions for EventManager have been commented away to
nothing during debugging, but the headers look like
class Event
{
private:
Object* recipient;
int eventID;
|
by: bob |
last post by:
Could someone help me get the following SQL statement working?
SELECT
standardgame.gamename,
standardgame.rowteamname,
standardgame.colteamname,
standardgame.dollarvalue,
standardgame.gameid,
standardgame.cutoffdatetime,
standardgame.gametype,
|
by: Ted |
last post by:
Here is one such function:
CREATE FUNCTION my_max_market_date () RETURNS datetime
BEGIN
DECLARE @mmmd AS datetime;
SELECT max(h_market_date) INTO @mmmd FROM holdings_tmp;
RETURN @mmmd;
END
One change I had to make, relative to what I had working in MySQL, was
|
by: Bern McCarty |
last post by:
I have a simple ref class in its own namespace that needs to coexist with
a legacy typedef alias for "unsigned int" in the global namespace that has
the identifier as itself. Everything compiles fine with the old MEC++ syntax,
but I cannot figure out how to write the code so that it will compile in
C++/CLI. Can someone tell me how? Here is the code in both syntaxes:
// This MEC++ code compiles just fine with VC8 using cl -c...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
