Gorm Raw Argument Unsupported Error

Created2022-09-03|Updated2025-09-27|DevelopmentBackend

|Post Views:

Problem: Raw second arg must be non-empty and fields referenced in SQL.

sql := "SELECT * FROM test WHERE @Placeholder "
var sqlParam struct { Applyno string; Status *int; Placeholder int }
sqlParam.Placeholder = 1
if info.Applyno != "" { sql += " AND applyno = @Applyno "; sqlParam.Applyno = info.Applyno }
db.Raw(sql, sqlParam).Scan(&dataList)

Author: Harry

Link: https://harrywork.com/blog/p/26189/

Copyright Notice: All articles on this blog are licensed under CC BY-NC-SA 4.0 unless otherwise stated.

Thanks

Paypal
Wechat

Related Articles

Go GORM Raw SQL Named Parameters

Use a struct to supply named parameters (@FieldName) in GORM Raw queries and paginate results.

Go Parse PHP Serialize to JSON

Convert PHP serialized array data into JSON using a Go phpserialize library.

Go Gin API Sign Middleware

Simple request signature verification middleware for Gin.

Go Hot Upgrade via Nginx Proxy

Achieve zero-downtime upgrade by switching backend port in nginx and reloading.

Go ioutil Deprecated After 1.16

ioutil package deprecated; move helpers to io or os in Go 1.16+.

Go Read Request Body Twice

Restore request body after reading to allow subsequent handlers consumption.

Comments

Loading Database