Forum: MS SQL  10 Days Ago |
| Replies: 6 Views: 311 Re: Problem using JOIN with six tables
It's late and I'm a little blurry. But from what I can see in your query I think this: tDocumentsA.user_id = tUsers.contact_id should be: tDocumentsA.user_id = tUsers.id (the same for all document... |
| Forum: Geeks' Lounge 20 Days Ago |
| Replies: 91 Views: 3,437 Re: Ufo
:icon_eek: Is this a trick question? |
| Forum: DaniWeb Community Feedback 20 Days Ago |
| Replies: 15 Views: 585 Re: How do I delete my DaniWeb Account?
What? I don't think so. I may be wrong but I can't be bothered to look it up.
What I do know is:
- The Data Protection Act is grossly misunderstood in the UK.
- You are obliged to provide what you... |
| Forum: Geeks' Lounge 21 Days Ago |
| Replies: 91 Views: 3,437 Re: Ufo
No her body has been overtaken by a particularly nasty parasitic xenomorph from the lower quadrant of Andromeda, It's posting here to avert suspicion, but I know my LGM's :) |
| Forum: Gadget Enthusiasts' Lounge 22 Days Ago |
| Replies: 17 Views: 349 |
| Forum: Geeks' Lounge 28 Days Ago |
| Replies: 73 Views: 1,880 |
| Forum: Geeks' Lounge 32 Days Ago |
| Replies: 73 Views: 1,880 Re: Question of the day
Why are the buses in Canada so weird ?
(I mean if Steven mistook the drawing for a retreating bus .... ) |
| Forum: Geeks' Lounge 32 Days Ago |
| Replies: 73 Views: 1,880 Re: Question of the day
What bus? it looks more like a UFO to me :)
Why do we call it 'cracking' a window when it doesn't break? |
| Forum: C# Apr 11th, 2008 |
| Replies: 10 Views: 276 |
| Forum: C# Mar 28th, 2008 |
| Replies: 23 Views: 2,822 Re: SQL Data into Textbox or Listbox
It's just a preference. I like things to be as loosley coupled as possible. I prefer to bind to collections of objects, rather than strongly typed datasets. Like most things it depends on what your... |
| Forum: C# Mar 27th, 2008 |
| Replies: 23 Views: 2,822 Re: SQL Data into Textbox or Listbox
Oops perhaps you are doinf a Forms project not a web project.
I have started a forms project and I can't get the binding source to use the new query either yet. I am too tired at the moment.
One... |
| Forum: C# Mar 27th, 2008 |
| Replies: 23 Views: 2,822 Re: SQL Data into Textbox or Listbox
The query has the single column you want 'Expr1' bind the textbox to that.
I am not very knowledgeable with BindingSources I am afraid, I don't like them. I prefer to have simple business objects.... |
| Forum: C# Mar 26th, 2008 |
| Replies: 23 Views: 2,822 Re: SQL Data into Textbox or Listbox
SELECT Name + '\n' + Street + '\n' + ZipCode +'\n' + City
FROM Customers
WHERE (CustomerID = @1)
This assumes none of the columns allow NULLS. Otherwise you will need to use ISNULL(name, '') + '\n'... |
| Forum: ASP.NET Mar 14th, 2008 |
| Replies: 15 Views: 585 Re: How do I Evaluate Null value from database?
Aha, you are using a strongly typed DataTable.
You must be handling the DBNull somehow otherwise you would be getting an exception when populating the table.
Have you tried just == null ? |
| Forum: ASP.NET Mar 14th, 2008 |
| Replies: 15 Views: 585 |
| Forum: ASP.NET Mar 14th, 2008 |
| Replies: 8 Views: 721 Re: Radiobutton Problem
Dont have the radio button in the control. Use a repeater to render radio button, user control pairs. |
| Forum: ASP.NET Mar 14th, 2008 |
| Replies: 15 Views: 585 |
| Forum: Geeks' Lounge Mar 14th, 2008 |
| Replies: 15 Views: 1,000 |
| Forum: Geeks' Lounge Mar 13th, 2008 |
| Replies: 15 Views: 1,000 Re: hollystyles
I didn't, this thread originates from my birthday in 2007. But I didn't find it till the 30th of march that year.
A year passed and it got bumped again by Sullys Boo, for which I was super chuffed! |
| Forum: MS SQL Mar 13th, 2008 |
| Replies: 7 Views: 2,142 |
| Forum: MS SQL Mar 13th, 2008 |
| Replies: 7 Views: 2,142 |
| Forum: MS SQL Mar 13th, 2008 |
| Replies: 7 Views: 2,142 |
| Forum: ASP.NET Mar 13th, 2008 |
| Replies: 2 Views: 143 |
| Forum: Geeks' Lounge Mar 13th, 2008 |
| Replies: 15 Views: 1,000 |
| Forum: MS SQL Mar 13th, 2008 |
| Replies: 10 Views: 528 Re: sql - how to
There is a SQL standard but each implementatin has it's own quirks on top of that. The only cure for this is experience. INNER JOIN is the assumed default in TSQL so you can be lazy and just type... |
| Forum: MS SQL Mar 12th, 2008 |
| Replies: 10 Views: 528 Re: sql - how to
MS Access !! yuck !! You didn't say you were using Access, and as this is a MS SQL Forum I used TSQL.
Ok just for you I have recreated everything in Access and tweaked the SQL. Basically removed... |
| Forum: MS SQL Mar 12th, 2008 |
| Replies: 2 Views: 279 |
| Forum: MS SQL Mar 12th, 2008 |
| Replies: 10 Views: 528 |
| Forum: MS SQL Mar 12th, 2008 |
| Replies: 3 Views: 503 |
| Forum: ASP.NET Mar 12th, 2008 |
| Replies: 4 Views: 314 Re: how does IIS deal wth session state?
ViewState is held in a hidden field within the rendered webpage, session state is held in the memory of the webserver. Each session has a unique id called a sessionid. The sessionid is given to the... |
| Forum: Geeks' Lounge Mar 12th, 2008 |
| Replies: 869 Views: 29,916 |
| Forum: Geeks' Lounge Mar 12th, 2008 |
| Replies: 54 Views: 1,600 Re: 1,000 Post
Hooray! Congratulations, welcome to the 1000+ club
:icon_mrgreen: |
| Forum: MS SQL Mar 12th, 2008 |
| Replies: 10 Views: 528 Re: sql - how to
Hmm re-reading your post that may not be quite what you want, you want lowest quote regardless of vendor I think.
select
q.[ID],
q.item,
v.[name],
mq.minprice,
v.phone#,
v.fax#
from |
| Forum: MS SQL Mar 12th, 2008 |
| Replies: 10 Views: 528 Re: sql - how to
Firstly just join the quote_tb to the vendor_tb. That gives the vendor details for ALL quotes.
Then use GROUP BY (to merge up all the repeating colums (ID, item, name, phone#, fax#) and the... |
| Forum: MS SQL Mar 12th, 2008 |
| Replies: 1 Views: 195 Re: sql server services
Whch version? and depends on what was installed (typical/custom)
Just type services.msc into Start -> Run
Scroll down to Services beginning with M and S
Services names are prefixed MSSQLblah..... |
| Forum: Geeks' Lounge Mar 12th, 2008 |
| Replies: 15 Views: 1,000 |
| Forum: ASP.NET Mar 11th, 2008 |
| Replies: 10 Views: 449 Re: need help getting started
This is due to windows integrated authentication (NTLM), although you are logged into Windows those credentials are not necessarily automatically passed on when required it certain circumstances.... |
| Forum: Geeks' Lounge Mar 10th, 2008 |
| Replies: 10 Views: 416 Re: Morning
Afternoon.
It's cleared up a little, a few sunny spells in Ipswich. But, apparently there's more mahem around the corner.
My wife and I took the dogs out first thing for there toilet as is... |
| Forum: Geeks' Lounge Mar 7th, 2008 |
| Replies: 45 Views: 3,644 Re: New FireFox -vs- New I.E.
I love FF for it's extensions, I can browse without a mouse, squash all the adds, interogate HTTP Headers ... etc etc etc If I need IE rendering for a non-standards site right click the FF tab and... |
| Forum: MS SQL Mar 7th, 2008 |
| Replies: 2 Views: 467 |
