[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

ASP

81K

Solutions

31K

Contributors

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

Share tech news, updates, or what's on your mind.

Sign up to Post

Python 3 Fundamentals
LVL 12
Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

LVL 24

Administrative Comment

by:Andrew Leniart
Hi Accountware1951,

What you've done here is made a "Post".  The Post function is designed to share information with the Experts Exchange community.

For help with problems, you'll get much better results if you use the Ask a Question button.

It's the big blue button at the top of your browser screen. See below...

Ask a Question

Additional information about asking questions can also be obtained by reading these articles:

How do I ask a question
Top 10 Ways to Ask Better Questions
How to Ask a Priority Question
How to Ask Anonymous Questions

For additional help on using Experts Exchange, please feel free to contact us at this Support link.

Hope this was helpful.

Regards,

Andrew Leniart
Experts Exchange TA / PE
Private Message Me
0
LVL 20

Expert Comment

by:Lucas Bishop
0
|Dear all,

I am working with ASP CLASSIC

I did not use querystring. Just table to table.

I have two tables:

TABLE2 - with the field texts(char)

and

Table1 - spanish (text 30 chars)

I want find on table2.texts each register placed on Table1.spanish

Examples (that not works):

rs.open "select * from table1, table2 where table1.spanish like '%" & table2.texts & "%' ", con

rs.open "SELECT table1.*, table2.texts FROM table1 INNER JOIN table2   ON table2.texts LIKE ('%" &  table1.spanish & "%') ", con

Example: table2.texts: "Y eso ha sido exactamente lo sucedido en los últimos 10 años con un sector bancario que en 2007 sobrevaloraba tanto su solidez
 "
table1.spanish: "sector bancario"

But these codes not works.

Could someone please place a code that works?

Thanks in advance
0
LVL 27

Expert Comment

by:Brian B
Hi Bob. You have entered this as a post, but it looks like it is a question. To get the best response from the Experts, you should probably re-submit this as a question using the "ask a question" button at the top of the page, or this link: https://www.experts-exchange.com/askQuestion.jsp

Please see here for further details: http://support.experts-exchange.com/customer/portal/articles/756544-how-to-succeed-at-ee-as-an-asker
1

ASP

81K

Solutions

31K

Contributors

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

Top Experts In
ASP
<
Monthly
>