比较两个项目 [英] Compare two items

问题描述

我创建了此登录信息。在登录过程中，我需要确保

，没有人已经使用该特定电子邮件或那个独特的

cnumber注册。


我试过这一行：

设置objRS = verify.execute（" SELECT id FROM logmein WHERE email =''"& email&

"''"）或（'''，cnumber =''"& cnumber&"'';"）


比这个：br />
设置objRS = verify.execute（" SELECT id FROM logmein WHERE email =''"& email&

"''"，"'' &或&''"，"''cnumber =''"& cnumber&"'';"）

任何人都知道我做错了什么？

解决方案

设置objRS = verify.execute（" SELECT id FROM logmein WHERE email =''"& email&

"''AND cnumber =''"& cnumber&"''"


-


问候


Steven Burn

Ur I.T. Mate Group
www.it-mate.co.uk


保持免费！

愚蠢的证实 <圣*************** @ discussions.microsoft.com>写在

消息新闻：3D ********************************** @ microsof t.com ...

我创建了这个登录名。在登录过程中，我需要赚取
，确保没有人已经使用该特定电子邮件或那个独特的电子邮件注册。

我已尝试过这一行：
设置objRS = verify.execute（" SELECT id FROM logmein WHERE email =''& email
&"''"）或（"''，cnumber =''" & cnumber&"'';"）

比这个：
设置objRS = verify.execute（" SELECT id FROM logmein WHERE email =''"&电子邮件
&"''"，"''&或&''"，"''cnumber =''"& cnumber&"'';" ）

任何人都知道我做错了什么？

Hello Stupid< g>，


有什么东西让你认为你做错了什么，

即错误信息？看起来你有问题

连接。处理手头的任务，看来你的目标是

让你的SQL查询字符串看起来像这样，我在其中输入值
jo*@example.com 和JoesCNumber。


s =" SELECT id FROM logmein WHERE email =''jo *@example.com''或cnumber =

''JoesCNumber''"


因此，要获取变量值，请替换上面的文字字符串

with

" &安培; varName&


s =" SELECT id FROM logmein WHERE email =''" &安培;电子邮件& "''或cnumber =''" &

cnumber& "''"


雷在家


愚蠢的证实 <圣*************** @ discussions.microsoft.com>写在

消息新闻：3D ********************************** @ microsof t.com ...

我创建了这个登录名。在登录过程中，我需要确保
没有人已经使用那个特定的电子邮件或那个独特的gn>注册了。

我试过这一行：
设置objRS = verify.execute（" SELECT id FROM logmein WHERE email =''"& email
&
"''"）或（"' '，cnumber =''"& cnumber&"'';"）

比这个：
设置objRS = verify.execute（" SELECT id FROM logmein WHERE email =''"& email
&
"''"，"''& or&''"，"''cnumber =''" & cnumber&"'';"）

任何人都知道我做错了什么？

我试过了我得到了同样的错误使用或


关键字cnumber附近的语法不正确。


" Steven Burn"写道：

设置objRS = verify.execute（" SELECT id FROM logmein WHERE email =''"& email&
"''AND cnumber = ''"& cnumber&"''"

-

问候

史蒂文伯恩
你的IT Mate Group
www.it-mate.co.uk

保持免费！

Stupid verifcation"< St *************** @ discussion.microsoft.com>写道在消息新闻中：3D ********************************** @ microsof t.com .. 。

我有我创建的这个登录。在登录过程中我需要

确定

没有人已经注册使用那个特定的电子邮件或那个独特的电子邮件。

我试过这一行：
设置objRS = verify.execute（" SELECT id FROM logmein WHERE email =''" & email
&

"''"）或（"''，cnumber =''" &安培; cnumber& "'';"）

比这个：
设置objRS = verify.execute（" SELECT id FROM logmein WHERE email =''"& email

&

"''"，"''& or&''"，"''cnumber =''"& cnumber& "'';"）

任何人都知道我做错了什么？

I have this login that i created. On the sign in process i need to make sure
that no one has already signed up using that certain email or that unique
cnumber.

Ive tried this line:
Set objRS = verify.execute("SELECT id FROM logmein WHERE email=''" & email &
"''") or ("'', cnumber= ''" & cnumber & "'';")

than this:
Set objRS = verify.execute("SELECT id FROM logmein WHERE email=''" & email &
"''", "'' & or & ''", "'' cnumber= ''" & cnumber & "'';")
Anyone know what i did wrong?

解决方案

Set objRS = verify.execute("SELECT id FROM logmein WHERE email=''" & email &
"'' AND cnumber= ''" & cnumber & "''"

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!
"Stupid verifcation" <St***************@discussions.microsoft.com> wrote in
message news:3D**********************************@microsof t.com...

I have this login that i created. On the sign in process i need to make sure that no one has already signed up using that certain email or that unique
cnumber.

Ive tried this line:
Set objRS = verify.execute("SELECT id FROM logmein WHERE email=''" & email & "''") or ("'', cnumber= ''" & cnumber & "'';")

than this:
Set objRS = verify.execute("SELECT id FROM logmein WHERE email=''" & email & "''", "'' & or & ''", "'' cnumber= ''" & cnumber & "'';")
Anyone know what i did wrong?

Hello Stupid <g>,

Is there something that is making you think that you did something wrong,
i.e. an error message? It looks like you''ve having issues with
concatenation. Dealing with the task at hand, it appears that your goal is
to have your SQL querystring look like this, where I entered values of
jo*@example.com and JoesCNumber.

s = "SELECT id FROM logmein WHERE email = ''jo*@example.com'' or cnumber =
''JoesCNumber''"

So, to get the variable values in there, replace the literal strings above
with
" & varName & "

s = "SELECT id FROM logmein WHERE email = ''" & email & "'' or cnumber = ''" &
cnumber & "''"

Ray at home

"Stupid verifcation" <St***************@discussions.microsoft.com> wrote in
message news:3D**********************************@microsof t.com...

I have this login that i created. On the sign in process i need to make
sure
that no one has already signed up using that certain email or that unique
cnumber.

Ive tried this line:
Set objRS = verify.execute("SELECT id FROM logmein WHERE email=''" & email
&
"''") or ("'', cnumber= ''" & cnumber & "'';")

than this:
Set objRS = verify.execute("SELECT id FROM logmein WHERE email=''" & email
&
"''", "'' & or & ''", "'' cnumber= ''" & cnumber & "'';")
Anyone know what i did wrong?

Ive tried that and i get the same errror i get with using or

Incorrect syntax near the keyword cnumber.

"Steven Burn" wrote:

Set objRS = verify.execute("SELECT id FROM logmein WHERE email=''" & email &
"'' AND cnumber= ''" & cnumber & "''"

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!
"Stupid verifcation" <St***************@discussions.microsoft.com> wrote in
message news:3D**********************************@microsof t.com...

I have this login that i created. On the sign in process i need to make

sure

that no one has already signed up using that certain email or that unique
cnumber.

Ive tried this line:
Set objRS = verify.execute("SELECT id FROM logmein WHERE email=''" & email

&

"''") or ("'', cnumber= ''" & cnumber & "'';")

than this:
Set objRS = verify.execute("SELECT id FROM logmein WHERE email=''" & email

&

"''", "'' & or & ''", "'' cnumber= ''" & cnumber & "'';")
Anyone know what i did wrong?

这篇关于比较两个项目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！