I need help in two scenarios: The First scenario is a test, the Second scenario is exacly what i need.
"
InsertCommand="INSERT INTO billing.dre_catalog(service_catalog_id, name, price, install, investiment_cost, recurent_cost, install_cost, dre_city_id, telco_id, bandwidth_id, active) VALUES (:service_catalog_id, :name, :price, :install, :investiment_cost, :recurent_cost, :install_cost, :dre_city_id, :telco_id, :bandwidth_id, :active)"
ProviderName=""
SelectCommand="SELECT dre_catalog_id, service_catalog_id, name, price, install, investiment_cost, recurent_cost, install_cost, dre_city_id, telco_id, bandwidth_id, active FROM billing.dre_catalog WHERE (dre_catalog_id = :dre_catalog_id)"
UpdateCommand="UPDATE "dre_catalog" SET "active" = ? WHERE "dre_catalog_id" = ?">
If i use this scenario, i get the error "Parameter name is missing".
"
InsertCommand="INSERT INTO billing.dre_catalog(service_catalog_id, name, price, install, investiment_cost, recurent_cost, install_cost, dre_city_id, telco_id, bandwidth_id, active) VALUES (:service_catalog_id, :name, :price, :install, :investiment_cost, :recurent_cost, :install_cost, :dre_city_id, :telco_id, :bandwidth_id, :active)"
ProviderName=""
SelectCommand="SELECT dre_catalog_id, service_catalog_id, name, price, install, investiment_cost, recurent_cost, install_cost, dre_city_id, telco_id, bandwidth_id, active FROM billing.dre_catalog WHERE (dre_catalog_id = :dre_catalog_id)"
UpdateCommand="UPDATE billing.dre_catalog SET service_catalog_id = :service_catalog_id, name = :name, price = :price, install = install, investiment_cost = :investiment_cost, recurent_cost = :recurent_cost, install_cost = :install_cost, dre_city_id = :dre_city_id, telco_id = :telco_id, bandwidth_id = :bandwidth_id, active = :active WHERE (dre_catalog_id = :dre_catalog_id)">
If i use this scenario, i get the error "could not determine data type of parameter $11".
Please, i need some help fast
I'm stopped because this...