Solved

ColdFusion and VBScript

Posted on 2000-03-02
8
335 Views
Last Modified: 2013-12-24
Can you pass variables from VBScript into CFQueries for ColdFusion? Example please.
0
Comment
Question by:houstim
8 Comments
 
LVL 1

Expert Comment

by:deepchanda
ID: 2577922
i dont know much about VBscript myself, but i would think it more of a client-side scripting language. Since CFquery tag is something that is processed at the server side, the VBscript code wont get run until it reaches the client browser

DC
0
 

Expert Comment

by:samphi
ID: 2577968
I dont know much about VBscript, but CF can UPDATE a data ...
And VBS can only INSERT, DELETE...

I'm not sure...
0
 

Expert Comment

by:anusha
ID: 2578133
Cannot pass from VBscript to CF.
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Expert Comment

by:anusha
ID: 2578135
Cannot pass from VBscript to CF.
0
 
LVL 5

Expert Comment

by:nathans
ID: 2581194
Are you referring to in the SAME page?  If so you might be able to use wddx and xml??? maybe??
0
 
LVL 1

Expert Comment

by:GGena
ID: 2582715
VBscript is working on client side. CF - on server. You cannot send data inside the same page without refreshing this page.

If you want to send values to another page it will be (in JavaScript) like

function SendVar(a,b){

location="newpage.cfm?FirstVar=" + a + "SecondVar=" + b
}


Sorry about JavaScript, but at VBscript it will be similar.
0
 
LVL 1

Expert Comment

by:GGena
ID: 2582716
GGena changed the proposed answer to a comment
0
 
LVL 1

Accepted Solution

by:
GGena earned 60 total points
ID: 2582720
VBscript is working on client side. CF - on server. You cannot send data inside the same page without refreshing this page.

If you want to send values to another page it will be (in JavaScript) like

function SendVar(a,b){

location="newpage.cfm?FirstVar=" + a + "SecondVar=" + b
}

newpage.cfm:
======================
<cfquery name=MeQuery>
   SELECT *
   FROM MyTable
   WHERE Field1=#FirsrVar# AND
         Field2=#SecondVar#
</cfquery>


Sorry about JavaScript, but at VBscript it will be similar.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever sent email via ColdFusion and thought of tracking this mail to capture the exact date and time when the message was opened ?  If yes, then this article is for you ! First we need a table user_email with columns user_id , email , sub…
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
The purpose of this video is to demonstrate how to Test the speed of a WordPress Website. Site Speed is an important metric of a site’s health. Slow site speed can result in viewers leaving your site quickly and not seeing your content. This…
The purpose of this video is to demonstrate how to update a WordPress Site’s version. WordPress releases new versions of its software frequently and it is important to update frequently in order to keep your site secure, and to get new WordPress…

774 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