I am trying to search a MS SQL database column for 6 numbers. The data in the column is a string of characters example: ab01234555cd0122abc987654efg Using RegEx : [0-9]{6} Results are : 012345 and 987654 Here is my current MS…
My current Website Control Panel is PLESK Parallels, and i'm trying to use PDO MSSQL on my website. I've searched the internet and i'm aware that the PDO dll needs to be in my php.ini file and such, but I…
I'm trying to build a flexible attribution model for site traffic. I've started out by making a last-click model, where a conversion is attributed to a channel of traffic based on the last visit a visitor made prior to converting.…
I have a query something like SELECT S.product_id, S.link, C.id AS category_id FROM Products P INNER JOIN SEO S ON S.product_id = P.id AND P.product_type = 1 LEFT OUTER JOIN Categories C ON c.product_id = P.id WHERE P.active = 1…
I have a function which calls a stored procedure with providing its parameters. int8 CDBAgent::CreateKnights(uint16 sClanID, uint8 bNation, string & strKnightsName, string & strChief, uint8 bFlag) { int8 bRet = -1; unique_ptr<OdbcCommand> dbCommand(m_GameDB->CreateCommand()); if (dbCommand.get() == nullptr) return bRet; dbCommand->AddParameter(SQL_PARAM_OUTPUT,…
i want to get records which is present in employees table but not in department i.e (Employees - department) output should be like this Employee(ID,Name), Department(Id,Name) i tried this select * from Employee as e left join Department as d…
Table : Post id user_id group_id Text 1 1 1 AAA 2 2 2 BBB 3 2 2 CCC 4 3 2 DDD 5 2 3 EEE Table : UserMaster user_id username 1 Raj 2 Meet 3 Kishan Table :…
I get this error when I upload the website on the server, ie parallels plesk server. I create the tables on the plesk server and selects SQL server 2012. But I think this is a connection string error. If you…
I'm trying obtain one tabla of cars which have three rows in relations with other three columns (make, model and group) and I only want obtain one car by model. Here a image of MySQL table: You will see three…
We are developing a site at work for the xmas/new year period where individuals can buy/sell what they want its for charity basically, look at it as a smaller version of ebay. We currently have 15 parent categories, and these…