Database & SQL Forum RSS Feed

ERD AND EERD?

Tue, 17 Nov 2009 21:55:15 -0700

Hi guys I just want to ask what is the exact difference between ERD(entity relationship diagram) and EERD(enhanced enitity relatioship diagram?

Help with SQL Triggers!!

Sat, 14 Nov 2009 23:48:24 -0700

This is what I had to do for my assigment!! I am just checking if this is correct!! Any help would be nice!! Thank You in Advance!

Create and test the following triggers for the database created in Programming Assignment 6.

1. A trigger that prevents the number of miles on a truck from being decreased.

This what I did for this one!

CREATE TRIGGER TURCK_MILES ON TRUCK
FOR INSERT,UPDATE
AS
declare @v1 decimal(8,2)
declare @v2 decimal(8,2)
select @v1 = TRUCK_MILES FROM TURCK
BEGIN
ROLLBACK
END

2. A trigger that prevents the Buy Date for truck from being after the current date.

This is what I put!

CREATE TRIGGER TRUCK_BUY_DATE ON TRUCK
FOR INSERT,UPDATE
AS
declare @date DATETIME
select @date=inserted.TRUCK_BUY_DATE FROM INSERTED
IF @date>GETDATE()
BEGIN
ROLLBACK TRANSACTION
END

3. A trigger that ensures that the Base Code in the Truck table is always in the Base table

My Answer!

CREATE TRIGGER BASE_CODE ON TRUCK
FOR INSERT,UPDATE
AS
declare @1_base_code int
declare @2_base_code int
select @1_base_code=inserted.BASE_CODE
FROM INSERTED,BASE,TRUCK
IF @1_base_code<>@2_base_code
BEGIN
ROLLBACK TRANSACTION
END

JD Edwards Data Archiving Solution

Tue, 10 Nov 2009 03:02:57 -0700

Organizations can mitigate the impact of data growth by running batch reports during downtimes, purchasing faster hardware or purge data from the application.

None of these strategies fully address the reality of application growth coupled with the need for long term data retention. To maintain performance of JD Edwards database, while ensuring compliance, organizations must Analyze JD Edwards data for a given module or the sum total of the Application database.

JD Edwards Data Archiving Solution

Tue, 10 Nov 2009 02:59:34 -0700

Data Privacy for a Secure Workplace

Tue, 06 Oct 2009 07:49:14 -0700

Our organization’s online business has increased 40% over the last 6 months. Every financial data has to be protected to sustain customer satisfaction ratings. Our current ratings have always exceeded expectation levels thanks to efficient data protection systems. Data privacy issues should be addressed to help the organization to also meet the different global regulatory requirements. It is always better to address enterprise data as a whole and provide complete security cover for sustaining business.

IT efficiency can be improved with automated cloning

Fri, 25 Sep 2009 01:05:57 -0700

It is well known that creating clones manually is labor intensive process. But with the assistance of Solix's product we've been creating automated clones where clones are created and configured faster and with fewer errors. Solix also provides products and solutions for data archiving, etc.

Really need help.

Tue, 15 Sep 2009 06:30:09 -0700

I am working an assignment which is a Sports Day Enrollment system for secondary school.
I have simply 3 tables:

Student(Sid,class,clsNon,Sname,dob,House)
Event(Eid,Ename,Grade)
Enrollment(Enid,Sid,Eid)

Grade A>=16 B=14-15 C<=13
But my assumption is that each student can only apply for 3 events.
How can I display the corresponding events for the student to choose and limit his choices to 3?
Can anyone help me? I am frustrated of failing to make it out.I am using Access 2003.
Thanks a lot!!!

DB Audits Aid ILM Process

Fri, 04 Sep 2009 03:58:58 -0700

Similar to conducting internal audits for processes, it is important for DB administrators to conduct data audits. Ensuring that you are alerted when unusual activity is occurring and keeping a secure and searchable audit log of database changes is critical to maintaining compliance with regulatory requirements as well as ensuring adherence to corporate information governance policies. Our organization has implemented a data auditor solution package from www.solix.com that works in tune with the information lifecycle management process.

Software FTP-Download Professional!

Mon, 31 Aug 2009 10:36:22 -0700

Software FTP-Download Professional!
Anything you need,can check: ctrl + f
kela2018@rambler.ru
http://www.yourweddingbands.com/showthread.php?t=20730

AUTODESK_3D_STUDIO_MAX_V2008
AUTODESK.3DSMAX.DESIGN.V2009
AutoCAD.2009.ObjectARX.SDK
AUTODESK_ALIASSTUDIO_V2009
AUTODESK.AUTOCAD.LAND.DESKTOP.V2009
AUTODESK.AUTOCAD.MECHANICAL.DESKTOP.V2009
AUTODESK.AUTOCAD.CIVIL3D.LAND.DESKTOP.COMPANION.V2 009
AUTODESK_DIRECTCONNECT_V2009
Autodesk Fire 7.0.14
AUTODESK.INVENTOR.PRO.V2009
Autodesk.ImageModeler.2009.& SP1
AUTODESK_LUSTRE_V2009
Autodesk.MapGuide.Enterprise.v2009
Autodesk.MapGuide.Studio.v2009
Autodesk.Map.3D.2009.ObjectARX.SDK-DOA
AUTODESK.MAYA.UNLIMITED.V2009
Autodesk MotionBuilder v2009
Autodesk.Mudbox.v2009
AUTODESK.NAVISWORKS.MANAGE.V2009
AUTODESK.NAVISWORKS.REVIEW.V2009
AUTODESK.NAVISWORKS.SIMULATE.V2009
Autodesk.Productstream.Professional.v2009
AUTODESK.QUANTITY.TAKEOFF.V2009
AUTODESK.REVIT.STRUCTURE.V2009
AUTODESK.REVIT.ARCHITECTURE.V2009
AUTODESK.AUTOCAD.REVIT.ARCHITECTURE.SUITE.2009.1
AUTODESK.REVIT.ARCHITECTURE.V2008.SP1
Autodesk.Robot.Structural.Analysis.Professional.v2 009
Autodesk.Showcase.v2009 &SP1
AUTODESK.SHOWCASE.PROFESSIONAL.2010.R1
Autodesk.Sketchbook.Pro.2009
Autodesk.Stitcher.Unlimited.2009.Build61.x86
Autodesk SoftImage Face Robot v1.9
Autodesk.Topobase.v2009.Client.ISO
AUTODESK_TOXIK_V2009 & SP2
AUTODESK.AUTOCAD.VIZ.V2008
AUTODESK.P.AND.ID.V2008
Autodesk.AliasStudio.v13.02
AUTODESK.ALIASSTUDIO.V2008 (2CD)
Autodesk Alias ImageStudio_v2008
Autodesk Alias.ImageStudio.v3.0
AUTODESK_COMBUSTION_V2008
Autodesk.Impression.R1
Autodesk.Impression.v2.0.21973
AUTODESK.VAULT.V2008 (2CD)
AUTODESK_LUSTRE_V2008
Autodesk.Revit.MEP.v2008.SP3
Autodesk Revit Series v6.1
AUTODESK.REVIT.BUILDING.V9.1 (3CD)
AUTODESK.MAPGUIDE.V6.5 (2CD)
AUTODESK.MAX.2008
Autodesk.Survey.v2007
Autodesk Actrix Technical 2000
AUTODESK MAYA UNLIMITED 8.5 SP1
AUTODESK_MAYA_UNLIMITED_V2008
Autodsys.AcceliCAD.2009.v6.4.23.3A
Autodsys.AcceliCAD.2010.v6.6.26.25A
Autodsys.AcceliCAD2CAM.2009.v6.4.23.3A
Autodsys.IntelliCAD.2009.Pro.Plus.v6.4.23.2
AutoDesSys.Bonzai3d.V1.00.Build.7306
AUTOFORM.MASTER.V4.1
AutoFORM V2.1.1 + EXCEED 6.2 & 3D 6.2
Autoform.4.1.1
AUTOFORM.V4.2
AutomatedQA.AQTime.v5.45.487
Automotive.Expert.v7.61
Dowell.Systems.Automotive.Expert.v7.81
Dowell.Systems.Automotive.Expert.v7.85
Automation Studio 5.0
AutoNest v9.22
AutoShip v8.2
Autoship v9.1
AutoYacht.8.2
AutoPol.7.7
Autopol for windows 1.9
AutoTURN v5.1
Autoturn 6.01
Auxbuss.HALion.3.Unleashed
AVID_XPRESS_PRO_V5.8
AvisMap.Deskpro.v5.0.2.5507
Avid_NewsCutter_XP_v6.7.5
AVID.MEDIA.COMPOSER.V3.0
AVID_SOFTIMAGE_XSI_ADVANCED_V6.5
SOFTIMAGE.XSI.v7.0.609.0.Win32
SOFTIMAGE_XSI_ADVANCED_V7.01.684
SOFTIMAGE_XSI_ADVANCED_V7.5_LINUX32/LINUX64
AVL Advisor 2004
AVL.Boost Engine Cycle Simulaton v3.0
AVL BOOST v5.1.1 Win
AVL cruise 3.1.1
AVL CRUISE 2008
AVL.Fire.v8.31
AVL Fire 2008
AVL.SWIFT.V3.1.1
AVL Workspace SUITE v4.1
AVL WorkSpace SUITE 5.1
AVPSoft ApFill v3.4.888
AVPSoft Universal Desktop Ruler v2.5.876
AWR Microwave Office 2004 2537r_v651
Microwave Office 2006 v7.03
AWR Design Environment 2006 v7.03.3161.2
AWR_Design_Environment_Microwave.Office.2007_v7_51 _3650_1
AWR.Design.Environment.v8.04.4267.1
AWR.Design.Environment.v8.06
AWR.Design.Environment.Vendor.Local.v8.0
AWR.Nuhertz.Filter.for.AWRDE.v5.10
AWR.Nuhertz.Filter.for.AWRDE.v5.14
NuHertz Filter Solution V11.1.1
AWR.Testwave.for.AWRDE.v2.05
AxisVM7
B2.Spice.AD.Professional.v5.2.3
Baramundi.Management.Suite.v7.6.SP1
BaseNow.Professional.v1.1.0.7
BASIS.BBj.Barista.Enterprise.v9.01
BASIS.BBj.Barista.Enterprise.v9.10
BASIS.Product.Suite.v9.01
BCAD.Furniture.Designer.Pro.v3.92
Beacon.Designer.v7.21
Beacon.Designer.v7.51
Becker.Indianapolis.and.Indianapolis.Pro.v5.0 (4CD)
Bentley ProjectWise Navigator MX 8.09.04.51
Bentley.PlantWise.XM.v8.09.04
Bentley SewerCad XM 05 06 014 00
Bentley_SewerGems_v08.09.02.500
Bentley.SewerGEMS.08.11.00.08(V8i)
Bentley.StormCAD.08.11.00.24(V8i)
Bentley.WaterCAD.08.11.0.3(V8i)
Bentley.WaterGEMS.08.11.00.30(V8i)
Bentley.HAMMER.08.11.00.30(V8i)
Bentley.Architecture.XM.v08.09.04.46
Bentley.Architecture.V8i.XM.v8.11.05.46
Bentley.Architecture.Dataset.US.V8i.v8.11.05.54
Bentley Autoplant 2004
BENTLEY.AUTOPLANT.STRUCTURAL.V08.06.00.11
Bentley.Structural.V8i.XM.v8.11.05.25
Bentley AutoPlant Plant Design XM 08.09.03.30
Bentley AutoPLANT P&ID XM 08.09.03.05
Bentley.PlantSpace.Design.Series.XM.v08.09.04.34
BENTLEY.AUTOPIPE.V2004
Bentley AutoPIPE 09.01.00.27
Bentley.AutoPipe.XM.v09.00.00.08
Rebis AutoPIPE v6.30.11
Bentley.Building.Electrical.Systems.XM.v08.09.04.1 2
Bentley.Building.Mechanical.Systems.XM.v08.09.04.4 5
Bentley.Cadastre.v08.09.04.71.for.Microstation.XM
Bentley.Civil.Extension.For.InRoads.XM.v8.09.03.06
Bentley.Civil.Extension.for.GEOPAK.XM.v08.09.06.30
Bentley.CivilStorm.V8i.08.11.00.08
Bentley.CulvertMaster.V03.02.00.01
Bentley FlowMaster 08.01.071.00
BENTLEY GEOPAK Civil 2004
Bentley GeoPak Rebar v8.00.07.46
Bentley.GEOPAK.Rebar.08.08.03.27
Bentley.GEOPAK.Civil.Engineering.Suite.8.08.03.24
Bentley.Generative.Components.V8i.XM.v8.11.05.36
Bentley InRoads v8i 08.11.05.45
Bentley InRoads Group v8.11.05.47
Bentley.InRoads.Suite.v8i.XM.v8.11.05.47
Bentley.InRoads.Suite.XM.Edition.v8.09.03.06
Bentley.IRASB.XM.v08.09.04.57
Bentley.Map.XM.v08.09.04.128
Bentley.Map.V8i.XM.v8.11.05.26
Bentley.Map.V8i.XM.v8.11.05.49
Bentley.Microstation.Descartes.V8i.v8.11.05.30
Bentley.MicroStation.v8i.XM.v8.11.05.17
Bentley.Microstation.Descartes.V8i.XM.v8.11.05.25
Bentley.Microstation.GEOPAK.Civil.Engineering.Suit e.XM.v08.09.07.28
Bentley.Microstation.GEOPAK.Rebar.2004.Edition.v08 .08.02.81
Bentley.Microstation.GEOPAK.Suite.v8.08.02.81
Bentley.Microstation.GEOPAK.Site.XM.v08.09.07.28
Bentley.Microstation.GEOPAK.Survey.XM.Edition.v08. 09.07.28
Bentley.Microstation.Powerdraft.v8i.XM.v8.11.05.17
Bentley.Microstation.Structural.XM.v8.09.04.39
Bentley.Microstation.Triforma.XM.v08.09.04.63
Bentley.Mx.International.v08.05.00.80
Bentley OpenPlant PowerPID v8i 08.11.05.27
Bentley.PlantFLOW.06.01.00.05
Bentley.PondPack.v10.01.04.00
BENTLEY.PROCESS.AND.INSTRUMENTATION.V08.06.00.14
Bentley.PowerSurvey.for.Powerdraft.XM.v08.09.06.30
Bentley.PowerMap.XM.v08.09.04.88
Bentley ProjectWise.v3.2
Bentley.ProSteel.3D.v18.0.Rev.20.06.08
Bentley.ProSteel.3D.v18.0.Datacode.20102008
Bentley.ProSteel 3D v8i (08.11.00.11)
Bentley.ProSteel.V8i.for.AutoCAD.2004-2009.v19.11.08
Bentley.Rebar.XM.v08.09.04.71
Bentley.Revit.Plugin.V8i.XM.v8.11.05.26
Bentley RAM CADstudio 02.01.07.00
Bentley RAM Connection 05.00.01.43
Bentley RAM STRUCTURAL SYSTEM 12
Bentley Schedule Simulator v4.02.01.10
BENTLEY.STAAD.PRO.V2007.2
Bentley Staad.Pro v8i (20.07.04.12)
Bentley.TriForma.2004.Edition.v8.05.04.18
Bentley Viecon Publisher v03.00.00.12
Berkeley_Madonna_v8.3.14
Best Color Proof 5.0
BETA_CAE_ANSA_V12.0.3
BETA-CAE_METAPOST_V5.1.0
Betnina Artista 4
BioStat.2007.Professional.v3.8.4
BIO-RAD_PDQUEST_V8.0.1
BIO-RAD_QUANTITY_ONE_V22
BioSolveIT.ReCore.v1.8.15.DD
BitDefender_Professional_Plus_v9.0
Bitplane.Imaris.v6.3.1
Bizprac ToolBox Pro v5.08
B&K PULSE v12.5
blast5.0_2005_08_07.0426
Bluespec-2008.11.C
BLUE_RIDGE_NUMERICS_CFDESIGN_V9.0
BMW.WDS.v12.0
BMW.ETK.v5.0.2008
BnK.PULSE.12.5 (2CD)
PE-DESIGN v5.5
Brother.PE-Design.v6.0
BobCAD-CAM.v21.5.2
BobCad-Cam.V21.Training.Professor
Boeing SoftPlotter V4.1 With Airfield
Boris Blue 2.5
Boris.Continuum.Complete.v5.01.for.AVX
Boris.Red.v4.3
Borland.c.sharp.builder.enterprise.V1.0 (2CD)
Borland.Together.Designer.2005
Borland Together Architect 2006
BORLAND.JBUILDER.2007.ENTERPRISE.DVD
Borland C++ Builder 6.0 Enterprise
Borland.SilkTest.2008.R2.SP1
Bosch.Rexroth.Indraworks.v7.04
Bosch.Rexroth.WinStudio.v6.5.WinNT_2K
Boson.Netsim.for.CCNP.v7.06
BOSS.RiverCAD.XP.for.AutoCAD.v7.5
BOSS.RiverCAD.2000.Datecode.20020508
BOSS.RiverCAD.Professional.for.AutoCAD.v8.1
BOSS.StormNET.v4.18
BOSTON DYNAMICS DI-GUY 5.0
Box Shot 3D v2.10
Braid.Art.Labs.GroBoto.v2.1.8.1
BrainVoyager.QX.v2.0.7
BR＆E ProMax 2.0.7047.0
Brain.Voyager.QX.v1.10.4
Bricsys.BricsCad.Pro.v9.2.16.15292
Bricsys.BricsCad.Pro.v9.3.9.15715
BSI.FB-Pier.v3.21
BtoCAD.2009A.v0416.11
Bunkspeed.HyperShot.v1.5.20
Bunkspeed.HyperShot.v1.7.1
Business Objects 5.1.4 + Keys
BUW.EFX.EVX.v6.0
Progressive.Die.Extension.v5.0
SmartAnalysis.v5.0
SmartAssembly.v5.0
SmartCorebox.v5.0
SmartElectrode.v5.0
SmartHolechart.v6.0
SmartHolefinder.v5.0
SmartLibrary.v6.0
SmartOptics.v5.0
SmartXhatch.v5.0
CA AllFusion Data Model Validator 7.2
CA AllFusion ERwin Data Modeler 7.2.5 SP1
CA AllFusion Model Manager 7.2.5 SP1
CA AllFusion Model Navigator 7.2.5 SP1
CA AllFusion Process Modeller 7.2.5 SP1
Cabinet Vision Solid v4.0
CAD2CAD.TwinView.Plus.Server.v14.28.24
CAD2CAD.TwinView.Plus.v14.28.24
CAD.SCHROER.STHENO.ADVANCED.V3.1.1
CAD-DUCT.SOLIDS.V2.28.062
Caddy-Electrical-3.8-3.6
CADRASTER.PRO.V8.0.FOR.AUTOCAD

Anything you need,can check: ctrl + f
kela2018@rambler.ru

Alpha Five database system

Fri, 28 Aug 2009 11:35:35 -0700

Can anyone direct me to programming examples for the database system; Alpha Five v5 – v9. I have been looking for public domain source code examples.

Data input solution for changing datasource dynamically in report tool

Fri, 28 Aug 2009 08:28:33 -0700

Problem
Sometimes, users may change the data source of input report template through RAQ Report API dynamically. However, after releasing the input report template with tag, an error message "Can't find data source!" usually appears when users are inputting data in the web page.

Analysis
Through API of RAQ Report, users can only change the name of the data source of report template dynamically, but not change the data source in updated attribute correspondingly. As a result, the data sources in input template and updated attribute are different. Then, when users are inputting data, the system can't find correct data source, and an error message pops up.

Solution
After changing the data source of report template, users should change the data source of updated attribute correspondingly.
With RAQ Report, users only need to get the corresponding relations between input report attribute and updated attribute, and change the data source of updated attribute.

Example
ReportDefine rd = (ReportDefine)ReportUtils.read(raq);
INormalCell cell = rd.getCell(2, (short)1);
//Get input report attributes.
InputProperty ip = cell.getInputProperty();
ArrayList al = ip.getUpdateList();
UpdateProperty up = (UpdateProperty)al.get(0);
//Get corresponding relations between input report attribute and updated attribute.
Object relations = up.getRelation();
if(relations instanceof com.runqian.report4.usermodel.input.TableRelations ){
TableRelations trs = (TableRelations)relations;
System.out.println(trs.getDataSourceName());
//Set the data source of updated attribute.
trs.setDataSourceName(”northwind”);
up.setRelation(trs);
ArrayList ups = new ArrayList(1);
ups.add(up);
ip.setUpdateList(ups);
cell.setInputProperty(ip);

This post is from freezea's blog. You are welcome to cc it anywhere, and please indicate the source.

If you would like to read more articles about reporting tool, you are also welcome to refer to my blog.

SQL alternative

Wed, 26 Aug 2009 14:59:29 -0700

Recently started consulting with a company that does a large amount of data manipulation as part of their service.

currently they use SQL Server, and are getting more and more requests for lists, reformats, reports etc.

There certainly are a lot of SQL programmers available, but I think using it is overkill and was curious what would be a good alternative that can handle large files, possibly up to 20 million records.

for sell Apple Macbook Air……………………….$600

Tue, 25 Aug 2009 05:24:58 -0700

TYALLEY LIMITED is a leading supplier of high-end products to customers, we deal primarily in
genuine and brand new electronics, all items are sourced directly from the manufacturers and carry the manufacturer's warranty. We ship 100% of our orders the same business day.

Registered No.06115369

We specialize in a wide range of products such as laptops, mobile phones, plasma & lcd tv, mp3 & mp4 players, video games console, digital cameras, dvd players (Etc) at cheap & affordable prices.

TYALLEY LIMITED strive to offer high-quality products at competitive prices. All of our products are brand new, never used, never rebuilt. We maintain multiple-supplier sources for our products as a means of being able to continually offer the best products at the best prices. All of our products are backed by a 90-days, money-back guarantee. Contact us for further informations about extended warranty from manufacturer.

We pride ourselves in the quality of products we offer, our prices, and most importantly, our customer service.

For more informations regarding product and purchasing process send your enquiry to TTYALLEY@YAHOO.COM

Note : First 25 People To Order 2Unit Get Free Item , Shipping/Discount

CHECK OUT FOR OUR EXTRA LESS CHEAPER PRODUCT LIST:

T-Mobile Sidekick:
T-Mobile Sidekick LX 2008–$135
T-Mobile Sidekick LX 2009–$140
T-Mobile Sidekick LX — $105
T-Mobile Shadow — $120
T-Mobile G1 — $130
T-Mobile Sidekick 3 — $100
Juicy Couture Sidekick 2 — $80

Apple iPhone:
Apple iPhone 3GS 32GB- $200
Apple iPhone 3GS 16GB- $180
Apple iPhone 4GB — $100
Apple iPhone 8GB — $120
Apple iPhone 16GB — $130
Apple iPhone 3G 8GB — $140
Apple iPhone 3G 16GB — $150

Palm Pre Sprint ---$190

BlackBerry:
BlackBerry Tour 9630 ——$180
Blackberry Curve 8900 — $170
Blackberry Storm 9500 — $140
Blackberry Storm 9530 — $155
Blackberry Pearl Flip 8220 — $105
Blackberry Bold 9000 — $135
Blackberry Curve 8320 — $125

HTC:
HTC Snap ——$200
HTC Hero -------$180
HTC Touch Pro — $155
HTC Touch Diamond 2 — $200
HTC Touch Diamond — $140
HTC Touch Cruise — $140
HTC Touch Pro2 $200
HTC Touch Dual — $130
HTC Dream — $195
HTC Touch Cruise 09 — $215
HTC MAX 4G — $200
HTC Touch HD — $165
HTC Touch 3G — $155
HTC Touch Viva — $145
HTC S740 — $155

Eten:
Acer Tempo DX900 ----$190
Eten glofiish X610 — $135
Eten glofiish V900 — $235
Eten glofiish X900 — $185
Eten glofiish DX900 — $165
Eten glofiish M810 — $155
Eten glofiish X650 — $145
Eten glofiish M800 — $160

Nokia:
Nokia 6760 slide–$200
Nokia Surge -$190
Nokia N98—–$200
Nokia N85——$190
Nokia N96 16GB– $175
Nokia E90 — $155
Nokia N97 — $195
Nokia N79 — $175
Nokia E72 — $190
Nokia E71 — $180
Nokia E75 - $185
Nokia 8800 Sapphire Arte — $205
Nokia N93i — $125
Nokia 8600 Luna — $145
Nokia 5530 XpressMusic --$190
Nokia 5800 XPress Music—-$185

Sony Ericsson:
Sony Ericsson Satio --$200
Sony Ericsson Idou—–$190
Sony Ericsson C510 — $185
Sony Ericsson P1 — $125
Sony Ericsson W995 -$190
Sony Ericsson C905 — $145
Sony Ericsson W960 — $130
Sony Ericsson G900 — $150
Sony Ericsson XPERIA X1 — $175
Sony Ericsson C902 — $130
Sony Ericsson W902 — $145

Samsung:
Samsung I8000 Omnia II —— $220
Samsung B7320 OmniaPRO —— $200
Samsung B7300 Omnia LITE——$190
Samsung i8910 Omnia HD ——-$170
Samsung i900 Omnia 16GB — $165
Samsung Omnia 8GB ——-$160
Samsung S8000 Jet ————
Samsung T929 Memoir — $195
Samsung T919 Behold — $185
Samsung Giorgio Armani P520 — $135
Samsung U900 Soul — $160
Samsung G800 — $155
Samsung F490 — $145

LG Phones
LG GW550—— $200
LG Incite——$195
LG GD910—–$180
LG KS500—-$175
LG KF900 Prada—–$180
LG KC780—-$200
LG KP500 Cookie—–$190
LG KC910 Renoir——$180
LG KB770——$190
LG CB630 Invision——$200
LG KS360——-$190

Video Games Console:
Playstation:
Sony PSP Slim Giga Bundle — $105
Sony PlayStation 3 80GB Motorstorm Pack — $155
Sony Playstation 3 60GB — $140
Sony PlayStation 3 40GB — $125

Microsoft Xbox:
Xbox 360 Arcade Console -- $115
Xbox 360 Pro 60GB Console -- $145
Xbox 360 Elite 120GB Console -- $165

Nintendo:
Nintendo DS Lite -- $70
Nintendo Wii Console -- $125

APPLE LAPTOPS
Apple Macbook Air……………………….$600
Apple MacBook (MA700LL/A) Mac Notebook…$500usd
Apple MacBook Pro (MA611LL/A) Notebook…$500usd
Apple MacBook (MA254LL/A) Mac Notebook…$450usd
Apple iBook G3 (M7698LL/A) Mac Notebook..$400usd
Apple MacBook Pro (MA609LL/A) Notebook…$550usd
Apple MacBook Pro (MA600LLA) Notebook…$500usd
Apple MacBook Pro (MA610LL/A) Notebook…$450usd
Apple Macbook Pro (885909119400) Notebook..$445usd

Please review our returns policy for more details below:
Before you return your items, you must contact us and receive a Return Merchandise Authorization Number (RMA). Any returns sent without an RMA number will not be accepted by TYALLEY LIMITED We assume all responsibility for the package until it arrives at our office.

Please include the following information when returning an item:
1) Your RMA number on your invoice (Do not write on the items box).
2) A copy of your original invoice with the RMA number (inside the shipping box).
3) A note stating the problem if you would like the return for replacement or exchange.

We ship 100% of our orders the same business day from our warehouse, typically the product will arrive within 2days via either Fedex/Ups Courier Sevices.

We give maximum guarantee for safe delivery of items bought from us.

Well we offer international standard warranty with full acceptance for replacement or full refund of money back.

We give maximum guarantee for safe delivery of items bought from us

For more informations regarding product and purchasing process send your enquiry to TTYALLEY@YAHOO.COM
We look forward in placing your order with us and giving you the most competent services.

NOTE: First 10 Customers To Purchase 2Units Or More, Attract Free Shipment !!!

Yours Sincerely

Mr. MATHEW DONOVAN
TYALLEY LIMITED
United Kingdom
E-mail: TTYALLEY@YAHOO.COM

Database connection

Tue, 25 Aug 2009 00:03:05 -0700

Hi
I have been trying to get to a database design that I have created in my Bluevoda Control Panel.
However when I try and test the database using Dreamweaver, the only database it shows is "information_schema"

When I enter the password for my database I get the message "access denied for user xxxxxxx_tidus @'localhost' using password: YES

am I forgetting to do something?

all help much appreciated

thanks!!

Jess

sql and asp programmers needed

Mon, 24 Aug 2009 17:48:19 -0700

Looking for ASP/SQL programmers to add to our growing team. This is not for anyone looking for part-time work, at this time we need programmers who are able to put in the hour as we have plenty of work that needs to be done. ASP.net-NO , ASP classic-YES. If you are an outsourcing company, please go away and for the love of it all do not spam or email me, thanks!

If you are hard working and can pretend to get along with or at least pretend to like our other programmers, then please feel free to email me with your resume- not that I will read them because I have found resumes do not always reflect ones capabilities.

This is a telecommuting job, so, you will need a home office that meets the requirements (if you have any clue about programming you will already know this but what they hay!):

-Must maintain a reliably quiet and professional home work environment during working hours.

-Must have reliable high-speed internet (DSL or Cable)

-Must have reliable personal computer which meets minimum system requirements

-Windows XP or 2000

-512 mb RAM

-Internet Explorer 7 or Firefox 2.x web browser

Pay rate is starting at $15.00 an hour for two week probation period for this contract position. After probation period, salary will be determine on results.

We are looking for programmers who can start immediately and work at least 30-40+ hours. Sense of humor is a must with us and thick skin! If you do not have the skills or sense of humor that we are seeking, please do not reply. If you do, please shoot me an email ASAP!

Light DB needed

Sat, 22 Aug 2009 09:20:18 -0700

Hi everybody
I am looking for a very light database, capable of storing just text (booleans would be nice) in user defined fields, and - most important - accessible from JavaScript.
So far I haven't been able to find anything suitable.
Any recommandations?
Many thanks in advance.

ORACLE_SQL

Tue, 18 Aug 2009 00:28:09 -0700

Hi,
Am ramya. I have got some problem in SQL. In my oracle database,
i got some tables created automatically with funny names , as
BIN$cWPOnQLpNT3gQAB/AQAa3w==$0
BIN$cWPOnQLrNT3gQAB/AQAa3w==$0
BIN$cWPOnQLmNT3gQAB/AQAa3w==$0
BIN$cPIH26/UFZngQAB/AQBFhw==$0
BIN$cHe95IEsJt3gQAB/AQBFhw==$0

The above are tables and are visible when used the data dictionaries tab and user_tab_columns alone. Am also not able to view the contents of these tables even and also not able to DROP THIS TABLES.
Please help me to clear this issue...
how to drop them??
how to view their contents?
say me some info about these tables..

Query Optimization

Mon, 17 Aug 2009 03:34:46 -0700

Hi,
This is my first article and so please provide comments on it (good or bad).

The design of the database is one of the most important factors in the performance of the database and with a good database design you also need optimal queries to perform optimally. Everyone wants the performance of their database to be optimal but does not concentrate on designing a query. They just write the query depending on the only major factor. What I want. They don’t consider that even the same thing can be achieved with some alternate queries and in more efficient manner.

Let’s take a very simple 3 table example, Employee, Department and Sub-Department. Schema of

Employee table
1. Employee

1. EmpId
2. SDId
3. EmpName
4. EmpAdd
5. EmpPhone

Sub-Department table
2. SubDepartment

1. SDId
2. DeptId
3. SDName

Department table
3. Department

1. DeptId
2. DeptName

The relationship between the Employee and Sub-Department table is one or more sub-departments have zero or more employees or in other words zero or more employees work in one or more Sub-Departments. The relationship between Department and Sub-Department is one or more Sub-Department is within one and only one Department. The Entity Relationship diagram of the above scenario is

ER Diagram

Now with the above Database schema lets have a very basic queries which can give us the same results and we will analyze as to which is faster and better performing than the other one. Let’s take a very common example with the above database schema, to know all the Employees in a particular department. The common solution that comes to our mind is.

Code: sql

SELECT e.EmpId, e.SDId, e.EmpName, e.EmpAdd, e.EmpPhone
FROM Employee e, SubDepartment sd, Department d
WHERE e.SDId = sd.SDId
AND sd.DeptId = d.DeptId
AND d.DeptId = ‘MyDepartment’

The above solution of joining the 3 tables to give us the output for the MyDepartment as the id of the department is a very common but is a very expensive one. Any organization have an employee to department ratio quite high and joining an Employee to a Department table can be quite a undesirable operation.

If we analyze the above solution then we are getting the output for one and only one Department i.e. MyDepartment. So our aim should be to find the Sub-Department’s in our MyDepartment.
Code: sql

SELECT SDId
FROM SubDepartment
WHERE DeptId = ‘MyDepartment’

The above query gives us the Sub-Department ID’s of all the Sub department present in our concerned department ‘MyDepartment’. Now if we can have the all the employee details present in each subdepartment returned by the above query we get the results that we had with the join from 3 tables.

Code: sql

SELECT e.EmpId, e.SDId, e.EmpName, e.EmpAdd, e.EmpPhone
FROM Employee e
WHERE e.SDId
IN (SELECT SDId
FROM SubDepartment
WHERE DeptId = ‘MyDepartment’)

With the above solution we have avoided 3 table join and also a query to the department table with introduction of a sub query. By avoiding the joins of a tables what we have achieved is no Department table in the query to retrieve the results but managed to provide the same output. Now we have some limitations with the above solutions.

If you are a web developer and if your client is using MySQL and that also there are chances that he might not be using version 5 then you are in trouble as you cannot use Sub queries. Then you can even write the above query using any programming language and avoid even the sub-query. Let’s take the simple example of PHP and MySQL.

Code: PHP

//SQL to give the sub-departments of the queries DeptId
$sql_sub_dept = "SELECT SDId FROM SubDepartment WHERE DeptId = $DeptID";
//Main SQL to give us the Employee of a particular department here $DeptID
$sql_main_dept = " SELECT e.EmpId, e.SDId, e.EmpName, e.EmpAdd, e.EmpPhone FROM Employee e WHERE Employee. SDId IN (";

//Execute the SQL and concatenate each subdepartment ID
$result = mysql_query ($sql_sub_dept);
while($rec = mysql_fetch_array($result))
{
$ sql_main_dept.= $rec["SDId"] ;
$ sql_main_dept.= ',';
}
//Remove the last “,” and end the bracket to complete the SQL.
$sql_main_dept = trim($sql_main_dept,",");
$sql_main_dept.= ")";
Thanks & regards
Lokananth
[url=http://www.mioot.com]Live Chat Software[/url] By miOOt

How to convert a table

Mon, 17 Aug 2009 03:24:09 -0700

Hi, all,

I have a problem to convert table content based on existing content:

DROP TABLE IF EXISTS `list`;
CREATE TABLE `list` (
`FACILITY` varchar(30) NOT NULL,
`PRODUCT` varchar(30) NOT NULL,
`SEGMENT` varchar(30) NOT NULL,
PRIMARY KEY (`FACILITY`,`PRODUCT`,`SEGMENT`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Let's say I know,
I have 2 FACILITY: AUSTIN, BOSTON;
(by

select distinct facility from list;

)
I have 2 PRODUCT: A, B;
(by

select distinct product from list;

)
I have 2 SEGMENT: BIG, SMALL;
(by

select distinct segment from list;

)

the Total combination could be 2*2*2=8

Now the current table "list" contains below data (3 records):
AUSTIN, A, BIG;
AUSTIN, B, SMALL;
BOSTON, A, SMALL;

How can I tell the other 5 combination by MYSQL?
Thanks & regards
Lokananth
[url=http://www.mioot.com]Live Chat Software[/url] By miOOt

mysql query performance issue

Mon, 17 Aug 2009 03:23:28 -0700

Hi All,

I am using testlink tool with mysql ( teamst.org/phpBB2/viewtopic.php?t=1938 ).

I have found that this query takes 54 secs to fetch data..which is not acceptable..
I am not conversant with mysql tuning...

SELECT
NHB.parent_id AS testsuite_id, NHA.parent_id AS tc_id,
NHB.node_order AS z, T.tcversion_id AS tcversion_id,
T.id AS feature_id, TCV.active,
E.id AS exec_id, E.tcversion_id AS executed,
E.testplan_id AS exec_on_tplan, UA.user_id,UA.type,
UA.status, UA.assigner_id,
COALESCE(E.status,'n') AS exec_status
FROM
nodes_hierarchy NHA JOIN nodes_hierarchy NHB ON NHA.parent_id = NHB.id
JOIN testplan_tcversions T ON NHA.id = T.tcversion_id
JOIN tcversions TCV ON NHA.id = TCV.id
JOIN executions E ON (NHA.id = E.tcversion_id AND E.testplan_id=T.testplan_id AND E.build_id=21 )
LEFT OUTER JOIN user_assignments UA ON UA.feature_id = T.id
WHERE T.testplan_id=30397
AND (UA.type=1 OR UA.type IS NULL)
AND E.status='p'
AND E.id IN ( SELECT MAX(id) FROM executions WHERE testplan_id=30397 GROUP BY tcversion_id,testplan_id )
ORDER BY testsuite_id,NHB.node_order,tc_id,E.id ASC;

Any help to bring down the sql execution time would be highly appreciated.

Thanks & regards
Lokananth
[url=http://www.mioot.com]Live Chat Software[/url] By miOOt

Introducing the SELECT Statement

Mon, 17 Aug 2009 03:21:13 -0700

Hi,
The SELECT statement is constructed of clauses that let you look at data in a relational database. These clauses let you select columns and rows from one or more database tables or views, specify one or more conditions, order and summarize the data, and put the selected data in a temporary table.

This chapter shows how to use five SELECT statement clauses. You must include these clauses in a SELECT statement in the following order:

1. Projection clause
2. FROM clause
3. WHERE clause
4. ORDER BY clause
5. INTO TEMP clause

Only the Projection and FROM clauses are required. These two clauses form the basis for every database query because they specify the tables and columns to be retrieved. Use one or more of the other clauses from the following list:

* Add a WHERE clause to select specific rows or create a join condition.
* Add an ORDER BY clause to change the order in which data is produced.
* Add an INTO TEMP clause to save the results as a table for further queries.

Two additional SELECT statement clauses, GROUP BY and HAVING, let you perform more complex data retrieval. They are introduced in Composing Advanced SELECT Statements.
Thanks & regards
Lokananth
[url=http://www.mioot.com]Live Chat Software[/url] By miOOt

Auto increment value in Datagride

Sun, 16 Aug 2009 00:49:06 -0700

hi!
I want to set id for Auto increment in datagride and when user delete the record the value decrement . (if code with LINQ is better)

MySQL Admin & Query Browser

Fri, 14 Aug 2009 09:31:00 -0700

I'M reading a book and MySQL but I need to load the datebase for the book before I can begin to use it. I have both files, create.sql, & populate.sql. I can't figure out how to load them into MySQL. The book suggested that I download MySQL Administrator & MySQL Query Browser, so I did. But I can't seem to login. In order to login to MySQL I just type in my password, but it seem to be more complicated to get into Query Browser or Administrator. Both programs want to know the following.

Stored Connection
Server Host
Username
password
Default Schema

I'M pretty sure my Server Host is "localhost", which is what I have it set to, but I'M not sure. Although I know my password, I don't know my username, the command based MySQL never ask me for my username. So how do I find out what it is?
And what is Default Schema? Thanks.

Trying to insert data using prepared statements in PHP.

Thu, 13 Aug 2009 20:59:06 -0700

<?php
$username = stripslashes($_POST['username']);
$password = stripslashes($_POST['password']);
$state = stripslashes($_POST['state']);
$state_code = stripslashes($_POST['state_code']);
$conn = new mysqli("localhost", "root", "icecold","test");

if (mysqli_connect_errno()){
echo "Unable to connect to database<br>";
echo "Error ". mysqli_connect_errno() . " - ".mysqli_connect_error();
exit;
}

$username = mysqli_real_escape_string($conn, $_POST['username']);
$password = mysqli_real_escape_string($conn, $_POST['password']);
$state = mysqli_real_escape_string($conn, $_POST['state']);
$state_code = mysqli_real_escape_string($conn, $_POST['state_code']);

$sql = "INSERT INTO user_records(username, password, state_code)
VALUES (?, ?, ?)";
$sql2 = "INSERT INTO states(states, state_code)
VALUES (?, ?)";

// initialize prepared statement
$stmt = $conn->stmt_init();
if ($stmt->prepare($sql)) {
// bind parameters and execute statment
$stmt->bind_param('sss', $username, $password, $state_code);
$stmt->execute();
/*
if ($stmt->prepare($sql2)) {
// bind parameters and execute statment
$stmt->bind_param('ss', $states, $state_code);
$stmt->execute();
*/
$conn->close();

echo $username."</br>".$password."</br>".$state_code."< /br>".$state ;

?>
PHP-certification:200-500

IT efficiency can be improved with automated cloning

Thu, 13 Aug 2009 02:22:36 -0700