Welcome Guest, Not a member yet? Register   Sign In
Database Error!!
#9

[eluser]Shaileen[/eluser]
ok now i m geting a different error!!


A Database Error Occurred

Error Number:

ERROR: column "4" does not exist

SELECT "mydsl_auth"."username", "t1_admin"."refid", "t1_admin"."admin_date_sent", "t1_eu"."eu_company", "t1_eu"."eu_contact", "t1_admin"."admin_order_sent", "t1_admin"."admin_deleted", "t1_admin"."admin_cancelled", "t1_admin"."admin_active", "t1_admin"."quote_id", "t1_order"."bandwidth_id" FROM "mydsl_auth", "t1_admin", "t1_eu" WHERE "t1_eu"."eu_address" like '%searchText%' AND "4" IS NULL AND "t1_eu"."seqid" = t1_admin.refid AND "mydsl_auth"."user_id" = t1_admin.salesperson AND "t1_admin"."admin_order_sent" = 1 AND "t1_admin"."admin_active" != 0 AND "t1_order"."refid" = t1_admin.refid ORDER BY "t1_admin"."admin_active" desc

and this is my controller!!

switch($searchGroup)
{
case 'unsent': $searchGroup = 1;
break;
Case 'sent': $searchGroup= 2;
break;
Case 'active': $searchGroup = 3;
break;
Case 'all': $searchGroup = 4;
break;
}


switch($searchGroup)
{
case 1: $groupSearch = " t1_admin.admin_order_sent = 0";
break;
Case 2: $groupSearch = " t1_admin.admin_order_sent = 1 AND t1_admin.admin_active = 0";
break;
Case 3: $groupSearch = " t1_admin.admin_active = 1 AND t1_admin.admin_order_sent = 1";
break;
Case 4: $groupSearch = "";
break;
}


Messages In This Thread
Database Error!! - by El Forum - 03-04-2010, 09:30 AM
Database Error!! - by El Forum - 03-04-2010, 09:45 AM
Database Error!! - by El Forum - 03-04-2010, 09:46 AM
Database Error!! - by El Forum - 03-04-2010, 09:47 AM
Database Error!! - by El Forum - 03-04-2010, 09:48 AM
Database Error!! - by El Forum - 03-04-2010, 09:52 AM
Database Error!! - by El Forum - 03-04-2010, 09:54 AM
Database Error!! - by El Forum - 03-04-2010, 11:15 AM
Database Error!! - by El Forum - 03-05-2010, 09:27 AM
Database Error!! - by El Forum - 03-05-2010, 10:28 AM
Database Error!! - by El Forum - 03-05-2010, 11:32 AM
Database Error!! - by El Forum - 03-05-2010, 11:52 AM
Database Error!! - by El Forum - 03-05-2010, 12:04 PM



Theme © iAndrew 2016 - Forum software by © MyBB