Go to http://www.connectionstrings.com
It is your friend. Bookmark it.

While I don't want to discourage new members, you might want to look at the dates of previous messages. This thread has been dead for 2 and a half years.

you could also use

buyerName.Contains(TextBox3.Text)
buyerName.BeginsWith(TextBox3.Text)
buyerName.EndsWith(TextBox3.Text)

ignore that last one and try this instead


Select pt.ProductID
from Products pt
left join Rating RT
on pt.productid = rt.productid
group by pt.productid
order by IsNull(Min(rt.Rating),0)

I think you want something like this

Select distinct pt.ProductID
from Products pt
left join Rating RT
on pt.productid = rt.productid
order by IsNull(Min(rt.Rating),0)

get rid of the square brackets around the varchar(255) and it will work fine.

For that matter, why are you putting them around the datatypes anyway? I've never seen anyone do that.

select * from persons where (prefix like '%'+@input+'%'
or
firstname like '%'+@input+'%'
or
lastname like '%'+@input+'%')
and address like '%'+@addressinput+'%'

This isn't a problem as I have already solved the problem, just trying to figure out why it happened.

Ok I have a field that is type money. I wrote a stored procedure that updates this field,...

that would add the assumption that the names in b are the first letter of the names in a

ok, i am assuming that you want a name for all id's. if a has an entry use that, otherwise use the name from b. also assuming that B has an entry for every id. if those assumptions are correct,...

I am no longer amazed by newbie posters who tell people that have consistently been on this (or any) forum for a long time helping people how to help people. Sometimes, the best way to help someone...

are you asking as the interviewer or interviewee?

yes please post the code

are you using c# or vn.net?

???? What kind of resources? What are you trying to do?

yes

this is a community help forum. We help you with your problem, we don't do everything for you. Tell us what you have tried and what problems your are having and we will help you solve them. We won't...

of course it is opening in a new window, you are using window.open.

use
document.location = "page2.aspx?username=" + lstruser

I don't have time to test this, but i don't think that this will work. This won't show any id1's that don't have a matching id2 or any id2's that don't have a matching one

select distinct case when id1<id2 then id1 else id2 end, case when id1<id2 then id2 else id1 end from tablename

I am trying to write an interface to another vendor. There spec requires the use of cast-128 encryption. I am trying to use an open-source version but am not getting the same results that they do. ...

um, yes you can. I have Windows XP Pro with SQL Server 2000 installed on it.

you can't decrypt this. This is a one-way hash. It is the best way to handle passwords. You don't want to be able to decrypt them.

huh?

which version of xp?

I agree that storing images in your database is probably not the best way to do it. But it is possible. Look into BLOB's (binary large object)

why? Because it saves you a roundtrip and a server call, and is faster and more efficient.

hopefully, this will get you going in the right direction.

var tb = document.getElementById('TEXTBOXID');
var tbVal = '';
if(tb !=null)
tbVal = tb.value;
...

can you give us some sample data?

it think this should work

select nick, max(energy.dateposted) from users
join energy
on energy.userid = user.id
group by nick

sounds like homework. Show us what you have tried and then we can help

return "";

ok, figured out the problem. needed the following line in the aspx page. Evidently, this makes functions from the master accessible by the content page

<%@ MasterType...

ok,
I am new to master pages. I have created a public function called setMenu in the cs file.

I can call this function fine from about half of my pages, but when i try to call it from the other...

well, are you using c# or vb.net, what kind of database are you using, what fields are in the database, what textboxes, dropdowns etc are you getting information from to populate said fields, are you...

if the column is indexed, it should only scan the rows included in the where clause

fix your database query

there's probably a more efficient way but this should work
select max(empsal) from employees where empno not in (select top 3 empno from employees order by empsal desc)

select the info that you want into a datatable,
set the datatable as the datasource for the dropdown. call the databind function. and make sure you specify in the dropdown control which columns...

i believe square brackets, not parentheses, should be used when referencing a column

l1.Text =Reader("Username");
should be
l1.Text =Reader["Username"];