Rename columns within a query?

-

is there way can rename column within coldfusion query? i've attached example.

i've joined table same table here , have named them , b. want able rename columns in b that, when display output, not have same names in a. (eg. b_pkgname , b_pkgrev).

brandi l wrote:
> there way can rename column within coldfusion query?

yup , in other technology making use of sql supports
alias 'as' statement.

i.e.

select
a.site,
a.pkgname,
a.pkgrev,
b.pkgname b_pkgname,
b.pkgrev b_bkgrev
...


i hear things ben forta's "teach sql in 10 minutes"
as many sql references , tutorials available on internets.



More discussions in Database Access


adobe

Comments

Post a Comment

Popular posts from this blog

How do I add a forum to my site? - Joomla! Forum - community, help and support

-
my main reason starting site have "place" host forum, going main reason visiting site.  far have installed joomla , getting hang of running it.  want add forum. is there particular forum software works joomla?   i thinking of phpbb... had kind of decided on , found web hosting company support (dreamhost).  i'm ready, wanted opinions of if that's right way go. is it? well use smf http://www.simplemachines.org/ , use on here , can going within joomla using http://www.simplemachines.org/download/?bridges Board index Joomla! Older Version Support Joomla! 1.0 General Questions - 1.0.x
Read more

VIDIOC_S_FMT error 16, Device or resource busy - Raspberry Pi Forums

-
dear all, working on image processing using raspberry pi, have installed intex usb web camera on raspberry pi. have used basic python script of image processing https://www.cl.cam.ac.uk/projects/raspb ... first.html required libraries installed on raspberry pi. script code: import imgproc imgproc import * # open webcam take pictures camera = camera(160, 120) # open viewer window display images viewer = viewer(160, 120, "the first step") # take picture camera img = camera.grabimage() # display image in viewer viewer.displayimage(img) # iterate on each pixel in image x in range(0, img.width): for y in range(0, img.height): # value @ xth column , yth row, place intensities variables red, green, blue = img[x, y] # test find colour dominant if red > green , red > blue: # red dominant, set pixel red img[x, y] = 255, 0, 0 elif green > red , green > blue: img[x, y] = 0, 255, 0 else: # if red or gr...
Read more

[Solved] Error: 'Hx711' does not name a type

-
i trying measure thrust forces using beam type sensor, hx711 module, , freaduino uno board.  it project here:   http://www.dfrobot.com/wiki/index.php/weight_sensor_module_v1 i unable find particular weight sensor module , using one:   http://www.nyplatform.com/index.php?route=product/product&path=114_143&product_id=746 i downloaded , installed library link there, installed in folder /libraries/hx711 contains files hx711.cpp, hx711.h, , samples folder folders named liquidcrystalscale , serial scale containing files liquidcrystalscale.ino , serialscale.ino files.   i copied sample code page , pasted new sketch in ide.  when try upload sketch error 'hx711' not name type , statement "hx711 scale(a2, a3);" highlighted in yellow.   can explain problem me?   the code below. jack code: [select] /* * description: * sample code digital weight scale of hx711. weight printed in serial. * library host on https://github.com/...
Read more