Creating new ms sql field to link records across table for easy user recall in vbscript

Posted on 2009-02-23
Last Modified: 2013-12-24
I'm a newbie with vbscript and i need help creating a concatenated field joining transID, Date and userID in a hidden form field that ties records together across tables giving user ability to save and come back. Because transID is an incremented field transID in each table differ. Once this field is created it will then be dumped into a session variable to be used in subsequent record creation. Any suggestions how to go about this.
Question by:GMMC_man
    LVL 57

    Accepted Solution

    Select those combined value as a new value and try
    Try using like this:

    select transID, Date, userID, transID + Date + userID concatvalue
    from urtable

    Use the combined value for your comparisons or manipulations

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    This is an article about my experiences with remote access to my clients (so that I may serve them) and eventually to my home office system via Radmin Remote Control. I have been using remote access for over 10 years and have been improving my metho…
    ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now