kRi Posted January 26, 2010 Report Share Posted January 26, 2010 (edited) Errors: Warning: mssql_query() [function.mssql-query]: message: Disallowed implicit conversion from data type varchar to data type varbinary, table 'Registred.dbo.MEMB_MONEY', column 'memb__pwd'. Use the CONVERT function to run this query. (severity 16) in Kāds varētu uzrakstīt priekšā pareizu sintaksi jamai convert f-ijai? Es tik biš vairāk kā cūka no aviācijas par šito saprotu.. Edited January 26, 2010 by kRi Link to comment Share on other sites More sharing options...
X ID Posted January 26, 2010 Report Share Posted January 26, 2010 Un kā tavs kverijs šobrīd izskatās? P.S. CONVERT (data_type[(length)], expression [, style]) Link to comment Share on other sites More sharing options...
kRi Posted January 26, 2010 Author Report Share Posted January 26, 2010 { $rand = rand(10000, 99999); if($Web['MD5'] == 1){ $md5_code=" [dbo].[UFN_MD5_ENCODEVALUE]('$pw', '$login')"; } else{ $md5_code="$pw"; } $msquery3 = "INSERT INTO MEMB_MONEY (memb__pwd)VALUES ('$pw') *Izgriezu no tiek kverijiem to galveno, kas pie vainas Īsāk sākot, pāriets no vienas CMS uz citu, abas ar MD5. Jaunajai CMS nepatīk vecā datubāzes varbinary tabula. Cik saprotu, laikam vaina ir tajā, ka paroles ģenerē ne tā kā vajag konkrētajai datubāzei.. Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now