Valid Script

[Mun]

Is this a valid script?

<input type=&quot;text1&quot; name=&quot;text1&quot; value= &quot;<%=rs.fields(&quot;tbl_Name&quot.value%>&quot;>

But it's giving me an error:

Error: Object doesn't support this property or method: 'fields'

Thanks.

 

[baddos]

Do you have your recordset object &quot;rs&quot; defined before trying to use it?

-Bad Dos

 

[GaryC123]

Should be

<input type=&quot;TEXT&quot; name..... Saturday 12.00

20.00

3.00am

Sunday [img http

 

[Mun]

Yes, Bad Dos! I do have recordset.
Sql = &quot;Select tbl_Name from tbl&quot;
rs = Conn.Execute(Sql)

 

[Chopstik]

Try taking off the .value at the end so it would read like this:

<input type=&quot;text1&quot; name=&quot;text1&quot; value= &quot;<%=rs.fields(&quot;tbl_Name&quot%>&quot;> Everything is absolute. Everything else is relative.

 

[GaryC123]

Try it like so...

<input type=&quot;text1&quot; name=&quot;text1&quot; value= &quot;<%=rs.fields.item(&quot;tbl_Name&quot.value%>&quot;> Saturday 12.00

20.00

3.00am

Sunday [img http

 

[cathyw]

Mun,

I think you need to change
rs = Conn.Execute(Sql)
to
Set rs = Conn.Execute(Sql)

You need the set in front because a recordset is an object.

Hope this helps,
Cathy

 

[larryman]

Mun,

I don't think you need Set statement for your recordset when you use Execute statement.

Try this
Sql = &quot;Select tbl_Name from tbl&quot;
rs = Conn.Execute(Sql)
<input type=&quot;text1&quot; name=&quot;text1&quot; value=&quot;<%=rs(&quot;tbl_Name&quot%>&quot;>


Thanks
Oysterbar ride to success. Keep Riding

 

[JamesLean]

cathyw is quite right - you need to use Set when assigning any object to a variable.

The result of conn.Execute will be a recordset, therefore you need the Set.

Sql = "Select tbl_Name from tbl"
Set rs = Conn.Execute(Sql)
...
<input type=&quot;text&quot; name=&quot;text1&quot; value=&quot;<%=rs(&quot;tbl_Name&quot;)%>&quot;>

--James