Overclock.net - Overclocking.net
     
 
Home Gallery Reviews Blogs Register Today's Posts Mark Forums Read Members List


Go Back   Overclock.net - Overclocking.net > Software, Programming and Coding > Coding and Programming
Reload this Page SQL help requested

Reply
 
LinkBack Thread Tools
Old 03-26-07   #1 (permalink)
WaterCooler
 
DanNEBTD's Avatar
 
amd nvidia

Join Date: Mar 2006
Location: Boca Raton, FL
Posts: 2,336

Rep: 120 DanNEBTD is acknowledged by manyDanNEBTD is acknowledged by many
Unique Rep: 103
Folding Team Rank: 346
Hardware Reviews: 8
Trader Rating: 8
Default SQL help requested
I have a project due tonight and im still having some issues. . . can someone explain what is wrong with what i have here. . . there is a primary key in both tables and the key im referencing is in the table im referencing:




Thanks for looking. . .
__________________
Quote:
Originally Posted by GuardianOdin View Post
Overkill doesn't exist on OCN. It's what we do.
XPS M1330: T7500, 4GB, 13.3" LED WXGA, 128 8400 GS, 120GB 5400RPM, 802.11 AGN, 9 cell, Fingerprint, Ultimate x64, 4 Year Accidental Damage/lojack/warranty.
__________________

System: The 1K CFM Machine
CPU
Opty 170 ccb1e 0609fpaw		 Motherboard
A8N32-SLI		 Memory
2 gigs Gskill PC4000 		Graphics Card
EVGA 7950X2
Hard Drive
4x 36gig Raptors raid 0, 1x 200gig storage		 Sound Card
XtremeMusic w/Z5500		 Power Supply
PC&P Silencer 750 Quad		 Case
Mozart Tx
CPU cooling
Stinger V6, quadrad		 OS
Vista Home Premium x86		 Monitor
32" Syntax Olevia
Last edited by DanNEBTD : 03-26-07 at 11:51 AM.
DanNEBTD is offline I fold for Overclock.net DanNEBTD's Gallery   Reply With Quote
Old 03-26-07   #2 (permalink)
Turing Test is Overrated
 
DuckieHo's Avatar
 
intel nvidia

Join Date: Nov 2006
Location: In a Chair.
Posts: 24,173

Rep: 2802 DuckieHo is a legendDuckieHo is a legendDuckieHo is a legendDuckieHo is a legendDuckieHo is a legendDuckieHo is a legendDuckieHo is a legendDuckieHo is a legendDuckieHo is a legendDuckieHo is a legendDuckieHo is a legend
Unique Rep: 1293
Folding Team Rank: 966
Trader Rating: 34
Default
What's that "REFERENCE items(item_number)," doing on the second "line 8"?
__________________
WANTED: Socket M Core/Core 2 CPU, SUGO-02 Black, quality 802.11b/g PCI Card
To answer most of your questions: (1) a fridge cannot cool a PC (2) 64-bit OS for over 3.4GB (3) If a PCIe card fits, it will work (4) Resolution, not screen size (5) If you have a question, it is not news (6) Report, not respond to Spam (7) Single/Non-Modular Rail PSUs are NOT better than Multi-Rail/Modular

Quote:
catmmm: no wifi? gay
e_dogg: I use both wired and wireless in my house. Does that make me bi?

System: My "DF-DIE" Replacement
CPU
Q6600 (3.7GHz)		 Motherboard
Asus P5E X38 (MF1208 BIOS)		 Memory
2x2GB OCZ Reaper 1096MHz 		Graphics Card
8800GT (729/1836/2088)
Hard Drive
PERC 5/i: 3xRAID0 Raptor 74GB + 7200.10 250GB		 Sound Card
X-Fi XtremeMusic		 Power Supply
Corsair 620HX		 Case
Li Lian PC-V2100 [10x120mm fans]
CPU cooling
FuZion V2 + Quad-Heatercore		 GPU cooling
MCW60 + Iandh HS + DDC-3.2		 OS
Vista Ultimate 64		 Monitor
Samsung 226BW "C" + Sceptre 19"
DuckieHo is offline I fold for Overclock.net Overclocked Account DuckieHo's Gallery   Reply With Quote
Old 03-26-07   #3 (permalink)
WaterCooler
 
DanNEBTD's Avatar
 
amd nvidia

Join Date: Mar 2006
Location: Boca Raton, FL
Posts: 2,336

Rep: 120 DanNEBTD is acknowledged by manyDanNEBTD is acknowledged by many
Unique Rep: 103
Folding Team Rank: 346
Hardware Reviews: 8
Trader Rating: 8
Default
it automatically put it there . . did that with all of the errors i had prev. . . seems that the program re-outputs it for my reference? . . a/w once i fix the problem it'll be gone.
__________________
Quote:
Originally Posted by GuardianOdin View Post
Overkill doesn't exist on OCN. It's what we do.
XPS M1330: T7500, 4GB, 13.3" LED WXGA, 128 8400 GS, 120GB 5400RPM, 802.11 AGN, 9 cell, Fingerprint, Ultimate x64, 4 Year Accidental Damage/lojack/warranty.
__________________

System: The 1K CFM Machine
CPU
Opty 170 ccb1e 0609fpaw		 Motherboard
A8N32-SLI		 Memory
2 gigs Gskill PC4000 		Graphics Card
EVGA 7950X2
Hard Drive
4x 36gig Raptors raid 0, 1x 200gig storage		 Sound Card
XtremeMusic w/Z5500		 Power Supply
PC&P Silencer 750 Quad		 Case
Mozart Tx
CPU cooling
Stinger V6, quadrad		 OS
Vista Home Premium x86		 Monitor
32" Syntax Olevia
DanNEBTD is offline I fold for Overclock.net DanNEBTD's Gallery   Reply With Quote
Old 03-26-07   #4 (permalink)
Turing Test is Overrated
 
DuckieHo's Avatar
 
intel nvidia

Join Date: Nov 2006
Location: In a Chair.
Posts: 24,173

Rep: 2802 DuckieHo is a legendDuckieHo is a legendDuckieHo is a legendDuckieHo is a legendDuckieHo is a legendDuckieHo is a legendDuckieHo is a legendDuckieHo is a legendDuckieHo is a legendDuckieHo is a legendDuckieHo is a legend
Unique Rep: 1293
Folding Team Rank: 966
Trader Rating: 34
Default
Ok, it's an output of the debugger.


Try using a different name than "items". It maybe a reserved word.
__________________
WANTED: Socket M Core/Core 2 CPU, SUGO-02 Black, quality 802.11b/g PCI Card
To answer most of your questions: (1) a fridge cannot cool a PC (2) 64-bit OS for over 3.4GB (3) If a PCIe card fits, it will work (4) Resolution, not screen size (5) If you have a question, it is not news (6) Report, not respond to Spam (7) Single/Non-Modular Rail PSUs are NOT better than Multi-Rail/Modular

Quote:
catmmm: no wifi? gay
e_dogg: I use both wired and wireless in my house. Does that make me bi?

System: My "DF-DIE" Replacement
CPU
Q6600 (3.7GHz)		 Motherboard
Asus P5E X38 (MF1208 BIOS)		 Memory
2x2GB OCZ Reaper 1096MHz 		Graphics Card
8800GT (729/1836/2088)
Hard Drive
PERC 5/i: 3xRAID0 Raptor 74GB + 7200.10 250GB		 Sound Card
X-Fi XtremeMusic		 Power Supply
Corsair 620HX		 Case
Li Lian PC-V2100 [10x120mm fans]
CPU cooling
FuZion V2 + Quad-Heatercore		 GPU cooling
MCW60 + Iandh HS + DDC-3.2		 OS
Vista Ultimate 64		 Monitor
Samsung 226BW "C" + Sceptre 19"
DuckieHo is offline I fold for Overclock.net Overclocked Account DuckieHo's Gallery   Reply With Quote
Old 03-26-07   #5 (permalink)
WaterCooler
 
DanNEBTD's Avatar
 
amd nvidia

Join Date: Mar 2006
Location: Boca Raton, FL
Posts: 2,336

Rep: 120 DanNEBTD is acknowledged by manyDanNEBTD is acknowledged by many
Unique Rep: 103
Folding Team Rank: 346
Hardware Reviews: 8
Trader Rating: 8
Default
Quote:
Originally Posted by DuckieHo View Post
Ok, it's an output of the debugger.


Try using a different name than "items". It maybe a reserved word.
i dont think it is because it created the items table. . . ill give it a shot though

EDIT >> nope tried "products" and got the same thing
__________________
Quote:
Originally Posted by GuardianOdin View Post
Overkill doesn't exist on OCN. It's what we do.
XPS M1330: T7500, 4GB, 13.3" LED WXGA, 128 8400 GS, 120GB 5400RPM, 802.11 AGN, 9 cell, Fingerprint, Ultimate x64, 4 Year Accidental Damage/lojack/warranty.
__________________

System: The 1K CFM Machine
CPU
Opty 170 ccb1e 0609fpaw		 Motherboard
A8N32-SLI		 Memory
2 gigs Gskill PC4000 		Graphics Card
EVGA 7950X2
Hard Drive
4x 36gig Raptors raid 0, 1x 200gig storage		 Sound Card
XtremeMusic w/Z5500		 Power Supply
PC&P Silencer 750 Quad		 Case
Mozart Tx
CPU cooling
Stinger V6, quadrad		 OS
Vista Home Premium x86		 Monitor
32" Syntax Olevia
DanNEBTD is offline I fold for Overclock.net DanNEBTD's Gallery   Reply With Quote
Reply

« Previous Thread | Next Thread »


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools



All times are GMT -4. The time now is 01:24 PM.

Contact Us - Overclock.net - Archive - Top

Overclock.net is a Carbon Neutral Site Creative Commons License Internet Security By ControlScan

Terms of Service / Forum Rules | Privacy Policy | Advertising | Become an Official Vendor
Copyright © 2008 Shogun Interactive Development. Most rights reserved.
Page generated in 0.25242 seconds with 8 queries