"Tim Gaunt" <Tgaunt@csi.com> wrote in message
news:bu4fkl$8o7$1@hercules.btinternet.com...
> Hi,
>
> I'm new to SQL Server and have encountered an interesting problem and was
> wondering whether there were any solutions.
>
> Basically I retreive records from the SQL Server and populate a form which
> the user filled in earlier however, although there is data stored in the
> fields, it returns null for certain fields namely:
>
> KDLDesignation
> CSSDesignation
> anything starting with EC_ or MC_
>
> I don't think they're reserved words and I'm flumoxed, any ideas?
>
> Cheers.
>
> Tim
>
>

"Tim Gaunt" <tgaunt@csi.com> wrote in message
news:eWCoQiQ3DHA.2168@TK2MSFTNGP12.phx.gbl...
> I'm using a standard recordset in the format:
>
> <%
> Dim ConAss
> Dim ConAss_numRows
>
> Set ConAss = Server.CreateObject("ADODB.Recordset")
> ConAss.ActiveConnection = MM_Delay_STRING
> ConAss.Source = "SELECT * FROM dbo.ContactAssesment WHERE CFNID = " +
> Replace(ConAss__MMColParam, "'", "''") + ""
> ConAss.CursorType = 0
> ConAss.CursorLocation = 2
> ConAss.LockType = 1
> ConAss.Open()
>
> ConAss_numRows = 0
> %>
>
> To retreive the field values:
>
> <%=(ConAss.Fields.Item("EC_Forename").Value)%>
>
> As mentioned in my previous post, all the other fields are coming
> through with the correct data in, its just the fields:
>
> KDLDesignation
> CSSDesignation
> anything starting with EC_ or MC_
>
> that are being retrieved with null values. I hope thats enough info to
> work out whats wrong, if not let me know.
>
> Tim
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

"Tim Gaunt" <Tgaunt@csi.com> wrote in message
news:buk4pp$sdq$1@sparta.btinternet.com...
> Sorry but I'm being rather thick, how should I put it in a string variable
> and how should I analyse the query?
>
> Sorry if its obvious but I'm very tired and I'm not thinking straight.
>
> Cheers.
>
> Tim
>
>
> "William Morris" <news.remove.this.and.the.dots@seamlyne.com> wrote in
> message news:bugvd9$hsila$1@ID-205671.news.uni-berlin.de...
> > Looks good to me. Try taking your query and putting into a string
> variable
> > first, then response.write it. What happens when you run that query in
> > Query Analyzer? Have you verified that the values truly aren't null for
> the
> > *exact* query being run?
> >
> > "Tim Gaunt" <tgaunt@csi.com> wrote in message
> > news:eWCoQiQ3DHA.2168@TK2MSFTNGP12.phx.gbl...
> > > I'm using a standard recordset in the format:
> > >
> > > <%
> > > Dim ConAss
> > > Dim ConAss_numRows
> > >
> > > Set ConAss = Server.CreateObject("ADODB.Recordset")
> > > ConAss.ActiveConnection = MM_Delay_STRING
> > > ConAss.Source = "SELECT * FROM dbo.ContactAssesment WHERE CFNID = " +
> > > Replace(ConAss__MMColParam, "'", "''") + ""
> > > ConAss.CursorType = 0
> > > ConAss.CursorLocation = 2
> > > ConAss.LockType = 1
> > > ConAss.Open()
> > >
> > > ConAss_numRows = 0
> > > %>
> > >
> > > To retreive the field values:
> > >
> > > <%=(ConAss.Fields.Item("EC_Forename").Value)%>
> > >
> > > As mentioned in my previous post, all the other fields are coming
> > > through with the correct data in, its just the fields:
> > >
> > > KDLDesignation
> > > CSSDesignation
> > > anything starting with EC_ or MC_
> > >
> > > that are being retrieved with null values. I hope thats enough info to
> > > work out whats wrong, if not let me know.
> > >
> > > Tim
> > >
> > > *** Sent via Developersdex http://www.developersdex.com ***
> > > Don't just participate in USENET...get rewarded for it!
> >
> >
>
>

> Looks good to me. Try taking your query and putting into a string
variable
> first, then response.write it. What happens when you run that query in
> Query Analyzer? Have you verified that the values truly aren't null for
the
> *exact* query being run?
>
> "Tim Gaunt" <tgaunt@csi.com> wrote in message
> news:eWCoQiQ3DHA.2168@TK2MSFTNGP12.phx.gbl...
> > I'm using a standard recordset in the format:
> >
> > <%
> > Dim ConAss
> > Dim ConAss_numRows
> >
> > Set ConAss = Server.CreateObject("ADODB.Recordset")
> > ConAss.ActiveConnection = MM_Delay_STRING
> > ConAss.Source = "SELECT * FROM dbo.ContactAssesment WHERE CFNID = " +
> > Replace(ConAss__MMColParam, "'", "''") + ""
> > ConAss.CursorType = 0
> > ConAss.CursorLocation = 2
> > ConAss.LockType = 1
> > ConAss.Open()
> >
> > ConAss_numRows = 0
> > %>
> >
> > To retreive the field values:
> >
> > <%=(ConAss.Fields.Item("EC_Forename").Value)%>
> >
> > As mentioned in my previous post, all the other fields are coming
> > through with the correct data in, its just the fields:
> >
> > KDLDesignation
> > CSSDesignation
> > anything starting with EC_ or MC_
> >
> > that are being retrieved with null values. I hope thats enough info to
> > work out whats wrong, if not let me know.
> >
> > Tim
> >
> > *** Sent via Developersdex http://www.developersdex.com ***
> > Don't just participate in USENET...get rewarded for it!
>
>