Re: convert from hexadecimal to a decimal

From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 10/28/04 

Date: Thu, 28 Oct 2004 10:21:29 +0200

On Wed, 27 Oct 2004 19:31:12 -0500, landung wrote:

>hi all,
>
>when i run this query, it will result this :
>
>Server: Msg 207, Level 16, State 3, Procedure hexchar2, Line 5
>Invalid column name 'n'.
>
>May i know the 'n' factor is ???

Hi landung,

It's a column in the numbers table I used for this query.

If you don't have a numbers table yet, check out this link:
http://www.aspfaq.com/show.asp?id=2516

If you do have a numbers table, but with another column name, change the
query to reflect the names of your numbers table and column.

Best, Hugo 

-- 
(Remove _NO_ and _SPAM_ to get my e-mail address)

Relevant Pages

  • RE: Subquery in SqlDataSource failing
    ... Removed the square brackets and the query with the subquery works ... I have a query in SqlDataSource that has a subquery. ... Invalid column name 'Mailboxes.BoxNumber'. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: percent of
    ... >Invalid column name 'TabNam'. ... I saw and fixed some errors that were obvious on re-reading the ... Anyway, here's the fixed query. ...
    (microsoft.public.sqlserver.programming)
  • RE: Subquery in SqlDataSource failing
    ... Remove square brackets from your subqueries. ... I have a query in SqlDataSource that has a subquery. ... AccessDataSource but get error when running it in SqlDataSource. ... Invalid column name 'Mailboxes.BoxNumber'. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Subquery in AccessDataSource Query Builder Failing
    ... OK I got the query working with AccessDataSource. ... slightly and tried the same thing by ignoring the query builder. ... Invalid column name 'Mailboxes.BoxNumber'. ... You can ignore error message and run the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Trim Email Address down to domain only
    ... When I check this query I get an invalid column name '. ... the spelling of everything and that looks good. ... > If EMail_Address is Char (as opposed to Varchar), ...
    (microsoft.public.access.queries)