Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Please wait...using javascript in jsp page
Hi all.I have been using a certain javascript code to display a "Please wait..." message on screen but it seems to work in some instances and not in others.Please assist me with javascript code that works in all instances. Below is the code I currently use. In the head tags I have: <script... -
jmaki dojo table columns from java bean
Hi all.My problem is pretty simple.I have been able to load data onto the table from a bean in my jsp page as follows: //top of page i have these <%@ taglib prefix="a" uri="http://jmaki/v1.0/jsp" %> <%@page contentType="text/html" pageEncoding="UTF-8"%> <%@ page language="java"... -
SELECT UNION ALL WHERE statement
towerbase! This is ingenious and I thank you so so much because it worked like a charm. Thanks again. -
SELECT UNION ALL WHERE statement
Hi all. Kindly assist me by showing me the right way to achieve the following. 1. I have the following SQL statement which works fine SELECT x,y,z FROM t1 WHERE x LIKE CONCAT('%',y,'%') UNION ALL SELECT a,b,c FROM t2 WHERE a =c) Now what I want is to achieve a WHERE statement for the united... -
need to select where table.col like table2.col2
Thanks for the insight. -
need to select where table.col like table2.col2
Here is the full-proof solution: SELECT distinct(s.mobile),s.msg,r.imei,s.dest, s.reply,s.status from dbS.tCline s INNER JOIN dbLaw.FORMER_GREY r ON s.msg LIKE concat('%',concat(r.C,'%')) where s.msg like '%SOLD%' Many thanks!! -
need to select where table.col like table2.col2
Sorry it seems I must pasted the code twice..Here it is :SELECT DISTINCT(dbS.tCline.mobile),dbS.tCline.msg,dbS.tCline.dest,dbS.tCline.reply,dbS.tCline.status FROM dbS.tCline,dbLaw.FORMER_GREY WHERE dbS.tCline.msg LIKE '%'||dbLaw.FORMER_GREY.C||'%' AND dbS.tCline.msg LIKE '%ADMISSION% The syntax... -
need to select where table.col like table2.col2
Thanks for looking at my post.The syntax I have posted is spot-on except for the area where I need help with where dbS.tCline.msg LIKE '%'||dbLaw.FORMER_GREY.C||'%' Please note that this is what someone posted as a solution in a certain Oracle blog but didn't work for me in MySQL. The version... -
need to select where table.col like table2.col2
Hi all, Am having trouble trying to retrieve records using the following SQL statement: SELECT DISTINCT(dbS.tCline.mobile),dbS.tCline.msg,dbS.tCline.dest,dbS.tCline.reply,dbS.tCline.statusFROM dbS.tCline,dbLaw.FORMER_GREYWHERE dbS.tCline.msg LIKE '%'||dbLaw.FORMER_GREY.C||'%'...
