2. ASPRunnerPro General questions
  3. two fields with...
This topic is locked

two fields with...

 		4/28/2008 9:08:21 AM
ASPRunnerPro General questions
E
 enetsat author

Hello for all

I m construction one new DB in ACCESS

More i wanna make that the information of FIELD1 + FIELD2 be in same FIELD
--------------------------------------------------

ADDPAGE
FIELD1 = Eduardo

FIELD2 = Dourado

____

LISTPAGE
FIELD1 = EDUARDO DOURADO
____

IN THE SEARCH OF LIST_PAGE
EDUARDO DOURADO

The DB search the information in 2 FIELDS who be one FIELD
Thanks for the information ..

Thanks for all
J
 		Jane 4/29/2008

Hi,
edit SQL query on the Edit SQL query tab for this purpose.

Here is a sample:

select FIELD1,

FIELD2,

FIELD1+FIELD2 as FIELD12,

...

from TableName


Check off FIELD12 on the list, search and view page only on the Choose fields tab.
E
 		enetsat author 4/29/2008

Hi,

edit SQL query on the Edit SQL query tab for this purpose.

Here is a sample:
Check off FIELD12 on the list, search and view page only on the Choose fields tab.


Thanks for your help .. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=28723&image=1&table=forumreplies' class='bbc_emoticon' alt=':lol:' />
E
 		enetsat author 4/30/2008

Its possible with numbers more text ?

Thanks
J
 		Jane 4/30/2008

Hi,
here is a sample:

select FIELD1,

FIELD2,

FIELD1+' some text '+FIELD2 as FIELD12,

...

from TableName
E
 		enetsat author 4/30/2008

Hi,

here is a sample:


Thanks for your atention ..
More i have problems <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=28762&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=28762&image=2&table=forumreplies' class='bbc_emoticon' alt=':(' />
I make this mode
select Prefix+' some text '+Sufix as PrefixID from Tabela1
Prefix=TEXT

SUFIX=NUMBER
he show-me in the field 0,00 .
If i exchange the field to Text field he show-me Blank
Sorry my ignorance <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=28762&image=3&table=forumreplies' class='bbc_emoticon' alt=':unsure:' />
J
 		Jane 5/5/2008

Hi,
it's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and send to support@xlinesoft.com a URL to your pages along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site.
D
 		dunga 5/22/2008

Hi,

edit SQL query on the Edit SQL query tab for this purpose.

Here is a sample:
Check off FIELD12 on the list, search and view page only on the Choose fields tab.


hi, Jane if my fields are numeric, can this be done?
select

field1

field2

field3

field1+field2+field3 as field4

from table

whatevername
I forgot to mention that the results is not summing bu adding,like

if the content of the fields are:

field 1=1

field2=0

field3=1
then resulting operation is 101, rather than "2"

please suggest.
what is happening is that:
each of the fields 1,2 and 3 are being summed using ASP runner,

and i would like to TOTAL of these.
E
 		enetsat author 5/22/2008

Thanks for your help .. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=29610&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />

More the Jane send to me this code is function
select PREFIX,SUFIX,PREFIX+' some text '+CStr([SUFIX]) AS ID FROM Tabela1
Move thanks for your help and your time ..
D
 		dunga 5/22/2008

ok, solved it
Cint(field1)+CInt(field2)+Cint(field3) AS field4,