dbWriter get flag SQL code
Note this code requires the dbWriter IPtoCountry database and the
country database with flags
<%
CREATE PROCEDURE [dbo].[sp_GetFlag]
(
@Flag varchar(255) OUTPUT,
@USER_IP VARCHAR(20)
)
AS
DECLARE @LONG_IP BIGINT
DECLARE @C varchar(50)
SET @Flag = 'ERROR'
SET NOCOUNT ON
SET @USER_IP = RTRIM( LTRIM(@USER_IP))
SET @LONG_IP = [dbo].LONGFROMIP(@USER_IP)
SET @C = (SELECT Cntry from [dbo].tbl_IPTOCOUNTRY
WHERE ( @LONG_IP >= LONG_Start) AND (@LONG_IP <= LONG_END))
DECLARE @CCC varchar(50)
DECLARE @theCountry varchar(50)
SELECT @FLAG= flag, @CCC = C_ISO, @theCountry = Country
FROM [dbo].tbl_Countrys_ISO
WHERE ([dbo].tbl_Countrys_ISO.C_ISO = @C)
%> |
|
