c**h
发帖数: 4 | 3 The XML data schema looks like this:
XYZ
MNO
...
I try to use DSO to read one record at one time and display
the data in an HTML table. But since and
are grandchild items, I can't find a way to use to
only get one record. If I add #xmldso in the , I
will get all the data not just one.
Could you let me know how to display these grandchild or
even grand-grand c |
|
S********t
发帖数: 4402 | 5 你又不给他账号。
下面是我们公司的sample.你可以拿过去用：
To Whom It May Concern,
This is to confirm with FedEx that D**** LLC, the shipper, waive our
rights to pursue the claim of a package (tracking number: 9222881100*****)
shipped by FedEx. In addition, we authorize FedEx to resolve the claim with
fName lName as the claimant. fName lName’s address is ******.
If you have any further questions, please don’t hesitate to contact us at
603-***-****.
Thanks a lot for your assistance!
Sincerely, |
|
q****x
发帖数: 7404 | 6 C++:
void foo(const char* fname, const char* mname, const char* lname);
Obj C
- (void)first:(NSString *)fname second:(NSString *)mname third:(NSString )
lname;
So the function name and the 1st parameter name are identical? This really
looks weird. What's the rationale behind this design? It's count-intuitive
that changing the 1st parameter name means changing the function name. |
|
p******e
发帖数: 31 | 7 我想用ASP添加数据库record时，总是报错。
请问是怎么回事？ 谢谢！
我的数据库并没有设为只读啊。
程序如下：
<%
dim db
dim strCon
db="access"
strCon="DRIVER={Microsoft Access Driver (*.mdb)};
DBQ=c:/Inetpub/wwwroot/name/name.mdb"
set db=Server.CreateObject("ADODB.Connection")
db.open strCon
%>
set res=Server.CreateObject("ADODB.Recordset")
res.Open "select * from
user",strCon,adOpenKeyset,adLockOptimistic
res.AddNew
res("pass")=pass
res("fname")=fname
res("lname")=lname
if city<>"" then
res("city")=city
....... |
|
s*****r
发帖数: 59 | 8 $insert = "INSERT INTO profiles
(INQLast_Name,INQEmail) values ('$lname,$lname')";
failed, is that the correct syntax when adding more column values? thanks.
if I add a single value, it works good, but when I tried to add mutiple, it
failed. thanks.
happen?
entry |
|
c******e
发帖数: 1581 | 9 slipper, you need a little more bit study on php and mysql.
The correct syntax should be:
$insert = "INSERT INTO profiles (INQLast_Name, INQEmail) values
('".addslashes($lname)."','".addslashes($lname)"')";
Note single quote is around each varchar field.
the |
|
p*****e
发帖数: 58 | 10 if you want to get all employees who work on ANY project
that john smith works on then the SQL is:
select e.ess, e.fname, e.lname, wk.projectno, wk.hours
from employee e
inner join works wk on e.ess = wk.essn
inner join
(select distinct w.projectno
from works w inner join employee ref on ref.ess=w.essn
where ref.lname='Smith' and ref.fname='John')
p
on p.projectno = wk.projectno |
|
s*****r
发帖数: 59 | 11 $insert = "INSERT INTO profiles
(INQLast_Name,INQEmail) values ('$lname,$lname')";
failed, is that the correct syntax when adding more column values? thanks.
if I add a single value, it works good, but when I tried to add mutiple, it
failed. thanks.
the |
|
c*****d
发帖数: 6045 | 12 第一题在oracle里还可以这么做
SELECT ssn, lname
FROM (SELECT ssn,
lname,
pno,
SUM (DECODE (sex, 'f', 1, 0)) OVER (PARTITION BY pno) cnt_f,
SUM (DECODE (sex, 'm', 1, 0)) OVER (PARTITION BY pno) cnt_m
FROM employee e, works_on w
WHERE e.ssn = w.essn) a
WHERE cnt_f > cnt_m |
|
B*****g
发帖数: 34098 | 13 刚才没看题，不知行不行，现在看了，还真不行，不过你的sql可以简化成
SELECT ssn, lname
FROM (SELECT ssn,
lname,
pno,
SUM (DECODE (sex, 'm', 1, -1)) OVER (PARTITION BY pno) cnt
FROM employee e, works_on w
WHERE e.ssn = w.essn) a
WHERE cnt < 0 |
|
h**j
发帖数: 2033 | 14 cqlsh:testks> show version
[cqlsh 4.1.1 | Cassandra 2.0.6 | CQL spec 3.1.1 | Thrift protocol 19.39.0]
用了helenus和astyanax都一样，row key都是null，都指定了target version 1.2 和
CQL3.
[ ,
]
key作为一个column返回，by design? |
|
h********o
发帖数: 103 | 15 DATA TEST;
INFILE CARDS DLM = ",";
INPUT FNAME $ LNAME $ BIRTH $ 23-30 PHONE $ 31-40;
CARDS;
SMITH ,BOB 01/03/668845333883
JACKSON ,ANDREW 03/09/779917736612
ALICE ,KIM 02/24/542243226673
;
PROC PRINT DATA = TEST NOOBS;
RUN;
===========================================================
FNAME LNAME BIRTH PHONE
SMITH BOB 01/03/66 8845333883
JACKSON ANDREW 03/09/77 9917736612
... 阅读全帖 |
|
|
i**y
发帖数: 2557 | 17 收藏了，hehe
TYPE=people&DB=WP&FNAME=Nicholas&LNAME=Smith&CITY=&STATE=AZ&KEY=1295150625
430371198.71.198.206.65&COUNT=9&PRCOUNT=9999&REC=6 |
|
|
|
|
|
|
|
|
|
|
|
d*********g
发帖数: 2906 | 28 大下坡看着真不错，但6000到5000 feet的海拔是不是高了点。看他们的成绩好像不是
特别好，不知道和这个海拔有没
有关系。
Bib FName LName State Div Age Sex ChipTime Overall
SexPl DivPl
607 DANIEL KENNEY CO MOVERALL 25 M 02:38:20 1 1
1
508 RYAN HERZOG CO MOVERALL 30 M 02:39:05 2 2
2
806 SHAWN MONK CO MOVERALL 24 M 02:40:06 3 3
3
248 ZACH CRANDALL CO MOVERALL 30 M 02:40:59 4 4
4
512 MICHAEL ... 阅读全帖 |
|
|
|
a****a
发帖数: 112 | 31 http://www.classicalhall.org/bio1.asp?lname=fleisher
Leon Fleisher
Born July 23, 1929, San Francisco, California
Now Living in Baltimore, Maryland
Con No.5 in E flat, Op.73 (Emperor): II-Adagio Un Poco Moto
Leon Fleisher is one of the first pianists to be inducted into the
American Classical Music Hall of Fame. Fleisher began to study piano at the
age of four. He gave his first public recital at age six, and three years
later began 10 years of study with Arthur Schnabel, in New York and |
|
|
|
|
|
|
s*****r
发帖数: 59 | 37 mysql_select_db(INQUIRY_DB);
$insert = "INSERT INTO profiles
set INQEmail=\"$lname\"";
$result = mysql_query($insert);
I use mysql in php code. but whenever I tried to add a new entry into the
table, I always failed. can somebody give me some suggestion why that happen?
this is a test. the table include a lot of columns, I tried to add a new entry
with only one column value. thanks very much! |
|
P****y
发帖数: 707 | 38 mysql_select_db("INQUIRY_DB");
$insert = "INSERT INTO profiles (INQEmail) VALUES ('$lname')"; |
|
j**y
发帖数: 147 | 39 在 Roman (想念她的教授) 的大作中提到: 】
I don't think so. See the following:
CREATE TABLE EMPLOYEE
( FNAME VARCHAR(15) NOT NULL,
LNAME VARCHAR(15) NOT NULL,
SSN CHAR(9) NOT NULL,
......
SUPERSSN CHAR(9),
.....
PRIMARY KEY (SSN)
FOREIGN KEY (SUPERSSN) REFERENCES EMPLOYEE(SSN));
The foreign key of this table references the primary key of itself. |
|
h******t
发帖数: 27 | 40 what is the averge of age among all students who participate in more than
2 activity
STUDENT (
StuID NUMBER,
LName VARCHAR2(12),
Fname VARCHAR2(12),
Age NUMBER,
Sex VARCHAR2(1),
Major NUMBER,
Advisor NUMBER,
city_code varchar2(3)
);
ACTIVITY (
actid number ,
activity_name varchar2(25))
PARTICIPATES_IN ;
create table PARTICIPATES_IN (
stuid number,
actid number )
thanks |
|
r******d
发帖数: 1 | 41 Have the tables:
employee(fname, lname, ssn)
works(essn,projectno,hours)
how to write the following query in relational calculus
"retrive the names of employees who work on all the project
that 'john smith' works on"?
Thx! |
|
p*****e
发帖数: 58 | 42
If you want to get all employees who work on ANY (not ALL)
projects
that john smith works on, then the SQL is:
There are also other ways to write the SQL. Here is another
one:
Select e1.*, w1.*
from employee e1 inner join works w1 on e1.ssn=w1.essn
inner join works w2 on w1.projectno=w2.projectno
inner join employee e2 on w2.essn=e2.ssn
where e2.fname='john' and e2.lname='smith' |
|
d****i
发帖数: 16 | 43 Do not why is not work?
maybe date type is wrong.
literal does not match format string
drop table employee;
create table employee( FNAME varchar(15),
MINIT char,
LNAME varchar(15),
SSN char(9),
BDATE date,
ADDRESS varchar(30),
SEX char,
SALARY decimal(10,2),
SUPERSSN char(9),
DNO int
);
insert into employee values('john','B','Smith','123456789',
'1956-11-11',
'731 Fondren, Houston,TX', 'M',
30000,'333445555',5);
|
|
d**a
发帖数: 75 | 44 I had a table and I want to retrieve those rows whose fname
is the same as the user name of the login user. the
following is what i ran in sql+
SQL> select * from e1;
UNAME FNAME LNAME ADDR |
|
b**e
发帖数: 2 | 45 For your first question, and for the second onw it's pretty much same.
Sorry it's not simple. We have to wait for Yukon to write simple recursive
queries
(For microsoft sql server)
Create Table #tmpTABLE (ID int, parent_id int, lastName varchar(50), firstName
varchar(50) )
declare xTmp scroll cursor for SELECT * from tablename
open xTmp
declare @myid int
declare @pid int
declare @lName varchar(50)
declare @fName varchar(50)
declare @found bit
declare @tmpID int
declare @tmpPID int
declare @num i |
|
a**k
发帖数: 29 | 46 I am a new beginner in JDBC and Oracle stored procedures. Would you please
help me
to solve the following practical question?
There is a table:
emp: fname, lname, dept, gender
if I want to select:
select * from emp where gender='m';
1. How could I write oracle stored procedure/function?
2. How could I writeJDBC to call stored procedure/function? I want to use
CallableStatement and ResultSet. |
|
s*****r
发帖数: 59 | 47 mysql_select_db(INQUIRY_DB);
$insert = "INSERT INTO profiles
set INQEmail=\"$lname\"";
$result = mysql_query($insert);
I use mysql in php code. but whenever I tried to add a new entry into the
table, I always failed. can somebody give me some suggestion why that happen?
this is a test. the table include a lot of columns, I tried to add a new entry
with only one column value. thanks very much! |
|
w****n
发帖数: 266 | 48 数据库里的email和SSN加密了，在SSRS里怎么解密，还原数据？
这个是我在shared dataset里的 SQL 语句， 出来的report里SSN还是显示Error
Use xxxx
GO
OPEN SYMMETRIC KEY Generickey DECRYPTION BY CERTIFICATE EncryptCert
GO
SELECT LName,
FName,
Convert(nvarchar(256),Convert(varbinary(256),DECRYPTBYKEY([SSN]))) as SSN
FROM table |
|
c*****d
发帖数: 6045 | 49 刚才开会的时候生怕有人抢我包子
haha，先来个笨方法，功能肯定能实现
SELECT ssn, lname
FROM employee
WHERE ssn IN
(SELECT essn
FROM works_on
WHERE pno IN
(SELECT DISTINCT f.pno
FROM ( SELECT pno, COUNT (1) cnt
FROM employee e, works_on w
WHERE w.essn = e.ssn AND sex = 'M'
GROUP BY pno) m,
( SELECT pno, COUNT (1) cnt
... 阅读全帖 |
|
